How to call a Concurrent Program from Database Trigger in oracle apps

CREATE OR REPLACE TRIGGER apps.xx_acct_analysis_tbl_t2
   AFTER INSERT
   ON gl.gl_je_headers
   REFERENCING NEW AS NEW OLD AS OLD
   FOR EACH ROW
DECLARE
   l_boolean        BOOLEAN;
   l_je_header_id   NUMBER;
   l_request_id     NUMBER;
BEGIN
   IF (    :NEW.status != 'P'
       AND :NEW.actual_flag = 'A'
       AND :NEW.attribute10 = 'Y'
       AND :NEW.je_source = 'AutoCopy'
      )
   THEN
      l_boolean := fnd_request.set_mode (TRUE);
      l_je_header_id := :NEW.je_header_id;
      l_request_id :=
         fnd_request.submit_request
                                   (application      => 'SQLGL',
                                    program          => 'XX_ACCT_ANALYSIS_IMPORT',
                                    start_time       => SYSDATE,
                                    argument1        => l_je_header_id,
                                    argument2        => NULL
                                   );
   END IF;
END xx_acct_analysis_tbl_t2;
/

----------------------------------------------------------------
CREATE OR REPLACE TRIGGER apps.xx_acct_analysis_tbl_t1
   AFTER UPDATE
   ON gl.gl_je_headers
   REFERENCING NEW AS NEW OLD AS OLD
   FOR EACH ROW
DECLARE
   l_boolean        BOOLEAN;
   l_je_header_id   NUMBER;
   l_request_id     NUMBER;
BEGIN
   IF (:NEW.status = 'P' AND :OLD.status != 'P' AND :OLD.actual_flag = 'A')
   THEN
      l_boolean := fnd_request.set_mode (TRUE);
      l_je_header_id := :OLD.je_header_id;
      l_request_id :=
         fnd_request.submit_request
                                   (application      => 'SQLGL',
                                    program          => 'XX_ACCT_ANALYSIS_IMPORT',
                                    start_time       => SYSDATE,
                                    argument1        => l_je_header_id,
                                    argument2        => NULL
                                   );
   END IF;
ENDxx_acct_analysis_tbl_t1;
/

How to find Legal Entity Address in Oracle Apps

SELECT    DECODE (hla.address_line_1, NULL, NULL, hla.address_line_1)
       || DECODE (hla.address_line_2, NULL, NULL, ', ' || hla.address_line_2)
       || DECODE (hla.address_line_3, NULL, NULL, ', ' || hla.address_line_3)
       || DECODE (hla.loc_information15,
                  NULL, NULL,
                  ', ' || hla.loc_information15
                 )
       || DECODE (hla.loc_information16,
                  NULL, NULL,
                  ', ' || hla.loc_information16
                 )
       || DECODE (ftv.territory_short_name,
                  NULL, NULL,
                  ', ' || ftv.territory_short_name
                 )
       || DECODE (hla.postal_code, NULL, NULL, ' - ' || hla.postal_code)  LE_Address
  FROM xle_entity_profiles etbp,
       xle_registrations reg,
       hr_locations_all hla,
       fnd_territories_vl ftv
 WHERE etbp.legal_entity_id = reg.source_id
   AND etbp.legal_entity_id = (SELECT   DISTINCT DEFAULT_LEGAL_CONTEXT_ID
                               FROM   HR_OPERATING_UNITS
                              WHERE   NAME = 'XX_OPERATING_UNIT')
   AND reg.source_table = 'XLE_ENTITY_PROFILES'
   AND identifying_flag = 'Y'
   AND hla.location_id = reg.location_id
   AND ftv.territory_code = hla.country;