DBA Data[Home] [Help]

APPS.XLA_AAD_OVERWRITE_PVT dependencies on XLA_ENVIRONMENT_PKG

Line 349: ,xla_environment_pkg.g_usr_id

345: ,s.product_rule_type_code
346: ,s.version_num
347: ,1
348: ,sysdate
349: ,xla_environment_pkg.g_usr_id
350: ,sysdate
351: ,xla_environment_pkg.g_usr_id
352: ,xla_environment_pkg.g_login_id
353: ,sysdate

Line 351: ,xla_environment_pkg.g_usr_id

347: ,1
348: ,sysdate
349: ,xla_environment_pkg.g_usr_id
350: ,sysdate
351: ,xla_environment_pkg.g_usr_id
352: ,xla_environment_pkg.g_login_id
353: ,sysdate
354: ,xla_environment_pkg.g_prog_appl_id
355: ,xla_environment_pkg.g_prog_id

Line 352: ,xla_environment_pkg.g_login_id

348: ,sysdate
349: ,xla_environment_pkg.g_usr_id
350: ,sysdate
351: ,xla_environment_pkg.g_usr_id
352: ,xla_environment_pkg.g_login_id
353: ,sysdate
354: ,xla_environment_pkg.g_prog_appl_id
355: ,xla_environment_pkg.g_prog_id
356: ,xla_environment_pkg.g_req_Id

Line 354: ,xla_environment_pkg.g_prog_appl_id

350: ,sysdate
351: ,xla_environment_pkg.g_usr_id
352: ,xla_environment_pkg.g_login_id
353: ,sysdate
354: ,xla_environment_pkg.g_prog_appl_id
355: ,xla_environment_pkg.g_prog_id
356: ,xla_environment_pkg.g_req_Id
357: FROM xla_product_rules_b s
358: WHERE s.application_id = g_application_id

Line 355: ,xla_environment_pkg.g_prog_id

351: ,xla_environment_pkg.g_usr_id
352: ,xla_environment_pkg.g_login_id
353: ,sysdate
354: ,xla_environment_pkg.g_prog_appl_id
355: ,xla_environment_pkg.g_prog_id
356: ,xla_environment_pkg.g_req_Id
357: FROM xla_product_rules_b s
358: WHERE s.application_id = g_application_id
359: AND s.amb_context_code = g_staging_context_code;

Line 356: ,xla_environment_pkg.g_req_Id

352: ,xla_environment_pkg.g_login_id
353: ,sysdate
354: ,xla_environment_pkg.g_prog_appl_id
355: ,xla_environment_pkg.g_prog_id
356: ,xla_environment_pkg.g_req_Id
357: FROM xla_product_rules_b s
358: WHERE s.application_id = g_application_id
359: AND s.amb_context_code = g_staging_context_code;
360:

Line 583: ,xla_environment_pkg.g_usr_id

579: ,ms.version_from
580: ,ms.version_to
581: ,1
582: ,sysdate
583: ,xla_environment_pkg.g_usr_id
584: ,sysdate
585: ,xla_environment_pkg.g_usr_id
586: ,xla_environment_pkg.g_login_id
587: ,sysdate

Line 585: ,xla_environment_pkg.g_usr_id

581: ,1
582: ,sysdate
583: ,xla_environment_pkg.g_usr_id
584: ,sysdate
585: ,xla_environment_pkg.g_usr_id
586: ,xla_environment_pkg.g_login_id
587: ,sysdate
588: ,xla_environment_pkg.g_prog_appl_id
589: ,xla_environment_pkg.g_prog_id

Line 586: ,xla_environment_pkg.g_login_id

582: ,sysdate
583: ,xla_environment_pkg.g_usr_id
584: ,sysdate
585: ,xla_environment_pkg.g_usr_id
586: ,xla_environment_pkg.g_login_id
587: ,sysdate
588: ,xla_environment_pkg.g_prog_appl_id
589: ,xla_environment_pkg.g_prog_id
590: ,xla_environment_pkg.g_req_Id

Line 588: ,xla_environment_pkg.g_prog_appl_id

584: ,sysdate
585: ,xla_environment_pkg.g_usr_id
586: ,xla_environment_pkg.g_login_id
587: ,sysdate
588: ,xla_environment_pkg.g_prog_appl_id
589: ,xla_environment_pkg.g_prog_id
590: ,xla_environment_pkg.g_req_Id
591: FROM xla_seg_rule_details d
592: ,TABLE(CAST(l_mapping_sets AS xla_component_tbl_type)) ms

Line 589: ,xla_environment_pkg.g_prog_id

585: ,xla_environment_pkg.g_usr_id
586: ,xla_environment_pkg.g_login_id
587: ,sysdate
588: ,xla_environment_pkg.g_prog_appl_id
589: ,xla_environment_pkg.g_prog_id
590: ,xla_environment_pkg.g_req_Id
591: FROM xla_seg_rule_details d
592: ,TABLE(CAST(l_mapping_sets AS xla_component_tbl_type)) ms
593: WHERE d.amb_context_code = g_amb_context_code

Line 590: ,xla_environment_pkg.g_req_Id

586: ,xla_environment_pkg.g_login_id
587: ,sysdate
588: ,xla_environment_pkg.g_prog_appl_id
589: ,xla_environment_pkg.g_prog_id
590: ,xla_environment_pkg.g_req_Id
591: FROM xla_seg_rule_details d
592: ,TABLE(CAST(l_mapping_sets AS xla_component_tbl_type)) ms
593: WHERE d.amb_context_code = g_amb_context_code
594: AND d.application_id <> g_application_id

Line 781: ,xla_environment_pkg.g_usr_id

777: ,version_from
778: ,version_to
779: ,1
780: ,sysdate
781: ,xla_environment_pkg.g_usr_id
782: ,sysdate
783: ,xla_environment_pkg.g_usr_id
784: ,xla_environment_pkg.g_login_id
785: ,sysdate

Line 783: ,xla_environment_pkg.g_usr_id

779: ,1
780: ,sysdate
781: ,xla_environment_pkg.g_usr_id
782: ,sysdate
783: ,xla_environment_pkg.g_usr_id
784: ,xla_environment_pkg.g_login_id
785: ,sysdate
786: ,xla_environment_pkg.g_prog_appl_id
787: ,xla_environment_pkg.g_prog_id

Line 784: ,xla_environment_pkg.g_login_id

780: ,sysdate
781: ,xla_environment_pkg.g_usr_id
782: ,sysdate
783: ,xla_environment_pkg.g_usr_id
784: ,xla_environment_pkg.g_login_id
785: ,sysdate
786: ,xla_environment_pkg.g_prog_appl_id
787: ,xla_environment_pkg.g_prog_id
788: ,xla_environment_pkg.g_req_Id

Line 786: ,xla_environment_pkg.g_prog_appl_id

782: ,sysdate
783: ,xla_environment_pkg.g_usr_id
784: ,xla_environment_pkg.g_login_id
785: ,sysdate
786: ,xla_environment_pkg.g_prog_appl_id
787: ,xla_environment_pkg.g_prog_id
788: ,xla_environment_pkg.g_req_Id
789: FROM (SELECT a.application_id
790: ,a.analytical_criterion_type_code

Line 787: ,xla_environment_pkg.g_prog_id

783: ,xla_environment_pkg.g_usr_id
784: ,xla_environment_pkg.g_login_id
785: ,sysdate
786: ,xla_environment_pkg.g_prog_appl_id
787: ,xla_environment_pkg.g_prog_id
788: ,xla_environment_pkg.g_req_Id
789: FROM (SELECT a.application_id
790: ,a.analytical_criterion_type_code
791: ,a.analytical_criterion_code

Line 788: ,xla_environment_pkg.g_req_Id

784: ,xla_environment_pkg.g_login_id
785: ,sysdate
786: ,xla_environment_pkg.g_prog_appl_id
787: ,xla_environment_pkg.g_prog_id
788: ,xla_environment_pkg.g_req_Id
789: FROM (SELECT a.application_id
790: ,a.analytical_criterion_type_code
791: ,a.analytical_criterion_code
792: ,ac.version_from

Line 1024: ,xla_environment_pkg.g_usr_id

1020: ,version_from
1021: ,version_to
1022: ,1
1023: ,sysdate
1024: ,xla_environment_pkg.g_usr_id
1025: ,sysdate
1026: ,xla_environment_pkg.g_usr_id
1027: ,xla_environment_pkg.g_login_id
1028: ,sysdate

Line 1026: ,xla_environment_pkg.g_usr_id

1022: ,1
1023: ,sysdate
1024: ,xla_environment_pkg.g_usr_id
1025: ,sysdate
1026: ,xla_environment_pkg.g_usr_id
1027: ,xla_environment_pkg.g_login_id
1028: ,sysdate
1029: ,xla_environment_pkg.g_prog_appl_id
1030: ,xla_environment_pkg.g_prog_id

Line 1027: ,xla_environment_pkg.g_login_id

1023: ,sysdate
1024: ,xla_environment_pkg.g_usr_id
1025: ,sysdate
1026: ,xla_environment_pkg.g_usr_id
1027: ,xla_environment_pkg.g_login_id
1028: ,sysdate
1029: ,xla_environment_pkg.g_prog_appl_id
1030: ,xla_environment_pkg.g_prog_id
1031: ,xla_environment_pkg.g_req_Id

Line 1029: ,xla_environment_pkg.g_prog_appl_id

1025: ,sysdate
1026: ,xla_environment_pkg.g_usr_id
1027: ,xla_environment_pkg.g_login_id
1028: ,sysdate
1029: ,xla_environment_pkg.g_prog_appl_id
1030: ,xla_environment_pkg.g_prog_id
1031: ,xla_environment_pkg.g_req_Id
1032: FROM (SELECT a.application_id
1033: ,a.segment_rule_type_code

Line 1030: ,xla_environment_pkg.g_prog_id

1026: ,xla_environment_pkg.g_usr_id
1027: ,xla_environment_pkg.g_login_id
1028: ,sysdate
1029: ,xla_environment_pkg.g_prog_appl_id
1030: ,xla_environment_pkg.g_prog_id
1031: ,xla_environment_pkg.g_req_Id
1032: FROM (SELECT a.application_id
1033: ,a.segment_rule_type_code
1034: ,a.segment_rule_code

Line 1031: ,xla_environment_pkg.g_req_Id

1027: ,xla_environment_pkg.g_login_id
1028: ,sysdate
1029: ,xla_environment_pkg.g_prog_appl_id
1030: ,xla_environment_pkg.g_prog_id
1031: ,xla_environment_pkg.g_req_Id
1032: FROM (SELECT a.application_id
1033: ,a.segment_rule_type_code
1034: ,a.segment_rule_code
1035: ,adr.version_from

Line 1194: ,xla_environment_pkg.g_usr_id

1190: ,segment_rule_type_code
1191: ,segment_rule_code
1192: ,1
1193: ,sysdate
1194: ,xla_environment_pkg.g_usr_id
1195: ,sysdate
1196: ,xla_environment_pkg.g_usr_id
1197: ,xla_environment_pkg.g_login_id
1198: ,sysdate

Line 1196: ,xla_environment_pkg.g_usr_id

1192: ,1
1193: ,sysdate
1194: ,xla_environment_pkg.g_usr_id
1195: ,sysdate
1196: ,xla_environment_pkg.g_usr_id
1197: ,xla_environment_pkg.g_login_id
1198: ,sysdate
1199: ,xla_environment_pkg.g_prog_appl_id
1200: ,xla_environment_pkg.g_prog_id

Line 1197: ,xla_environment_pkg.g_login_id

1193: ,sysdate
1194: ,xla_environment_pkg.g_usr_id
1195: ,sysdate
1196: ,xla_environment_pkg.g_usr_id
1197: ,xla_environment_pkg.g_login_id
1198: ,sysdate
1199: ,xla_environment_pkg.g_prog_appl_id
1200: ,xla_environment_pkg.g_prog_id
1201: ,xla_environment_pkg.g_req_Id

Line 1199: ,xla_environment_pkg.g_prog_appl_id

1195: ,sysdate
1196: ,xla_environment_pkg.g_usr_id
1197: ,xla_environment_pkg.g_login_id
1198: ,sysdate
1199: ,xla_environment_pkg.g_prog_appl_id
1200: ,xla_environment_pkg.g_prog_id
1201: ,xla_environment_pkg.g_req_Id
1202: FROM xla_line_defn_adr_assgns xld
1203: WHERE xld.amb_context_code = g_amb_context_code

Line 1200: ,xla_environment_pkg.g_prog_id

1196: ,xla_environment_pkg.g_usr_id
1197: ,xla_environment_pkg.g_login_id
1198: ,sysdate
1199: ,xla_environment_pkg.g_prog_appl_id
1200: ,xla_environment_pkg.g_prog_id
1201: ,xla_environment_pkg.g_req_Id
1202: FROM xla_line_defn_adr_assgns xld
1203: WHERE xld.amb_context_code = g_amb_context_code
1204: AND xld.application_id <> g_application_id

Line 1201: ,xla_environment_pkg.g_req_Id

1197: ,xla_environment_pkg.g_login_id
1198: ,sysdate
1199: ,xla_environment_pkg.g_prog_appl_id
1200: ,xla_environment_pkg.g_prog_id
1201: ,xla_environment_pkg.g_req_Id
1202: FROM xla_line_defn_adr_assgns xld
1203: WHERE xld.amb_context_code = g_amb_context_code
1204: AND xld.application_id <> g_application_id
1205: AND xld.segment_rule_appl_id = g_application_id

Line 1788: ,xla_environment_pkg.g_usr_id

1784: ,s.transaction_coa_id
1785: ,s.accounting_coa_id
1786: ,s.enabled_flag
1787: ,sysdate
1788: ,xla_environment_pkg.g_usr_id
1789: ,sysdate
1790: ,xla_environment_pkg.g_usr_id
1791: ,xla_environment_pkg.g_login_id
1792: FROM xla_stage_acctg_methods s

Line 1790: ,xla_environment_pkg.g_usr_id

1786: ,s.enabled_flag
1787: ,sysdate
1788: ,xla_environment_pkg.g_usr_id
1789: ,sysdate
1790: ,xla_environment_pkg.g_usr_id
1791: ,xla_environment_pkg.g_login_id
1792: FROM xla_stage_acctg_methods s
1793: LEFT OUTER JOIN xla_acctg_methods_b w
1794: ON w.accounting_method_type_code = s.accounting_method_type_code

Line 1791: ,xla_environment_pkg.g_login_id

1787: ,sysdate
1788: ,xla_environment_pkg.g_usr_id
1789: ,sysdate
1790: ,xla_environment_pkg.g_usr_id
1791: ,xla_environment_pkg.g_login_id
1792: FROM xla_stage_acctg_methods s
1793: LEFT OUTER JOIN xla_acctg_methods_b w
1794: ON w.accounting_method_type_code = s.accounting_method_type_code
1795: AND w.accounting_method_code = s.accounting_method_code

Line 1825: ,xla_environment_pkg.g_usr_id

1821: ,s.name
1822: ,s.description
1823: ,USERENV('LANG')
1824: ,sysdate
1825: ,xla_environment_pkg.g_usr_id
1826: ,sysdate
1827: ,xla_environment_pkg.g_usr_id
1828: ,xla_environment_pkg.g_login_id
1829: FROM xla_stage_acctg_methods s

Line 1827: ,xla_environment_pkg.g_usr_id

1823: ,USERENV('LANG')
1824: ,sysdate
1825: ,xla_environment_pkg.g_usr_id
1826: ,sysdate
1827: ,xla_environment_pkg.g_usr_id
1828: ,xla_environment_pkg.g_login_id
1829: FROM xla_stage_acctg_methods s
1830: JOIN fnd_languages fl
1831: ON fl.installed_flag IN ('I', 'B')

Line 1828: ,xla_environment_pkg.g_login_id

1824: ,sysdate
1825: ,xla_environment_pkg.g_usr_id
1826: ,sysdate
1827: ,xla_environment_pkg.g_usr_id
1828: ,xla_environment_pkg.g_login_id
1829: FROM xla_stage_acctg_methods s
1830: JOIN fnd_languages fl
1831: ON fl.installed_flag IN ('I', 'B')
1832: LEFT OUTER JOIN xla_acctg_methods_tl w