APPS.XLA_AAD_MERGE_PVT dependencies on XLA_ENVIRONMENT_PKG

Line 367: ,xla_environment_pkg.g_usr_id

363: ,C_OWNER_SYSTEM
364: ,l_version_nums(i)
365: ,1
366: ,sysdate
367: ,xla_environment_pkg.g_usr_id
368: ,sysdate
369: ,xla_environment_pkg.g_usr_id
370: ,xla_environment_pkg.g_login_id
371: ,sysdate

Line 369: ,xla_environment_pkg.g_usr_id

365: ,1
366: ,sysdate
367: ,xla_environment_pkg.g_usr_id
368: ,sysdate
369: ,xla_environment_pkg.g_usr_id
370: ,xla_environment_pkg.g_login_id
371: ,sysdate
372: ,xla_environment_pkg.g_prog_appl_id
373: ,xla_environment_pkg.g_prog_id

Line 370: ,xla_environment_pkg.g_login_id

366: ,sysdate
367: ,xla_environment_pkg.g_usr_id
368: ,sysdate
369: ,xla_environment_pkg.g_usr_id
370: ,xla_environment_pkg.g_login_id
371: ,sysdate
372: ,xla_environment_pkg.g_prog_appl_id
373: ,xla_environment_pkg.g_prog_id
374: ,xla_environment_pkg.g_req_Id);

Line 372: ,xla_environment_pkg.g_prog_appl_id

368: ,sysdate
369: ,xla_environment_pkg.g_usr_id
370: ,xla_environment_pkg.g_login_id
371: ,sysdate
372: ,xla_environment_pkg.g_prog_appl_id
373: ,xla_environment_pkg.g_prog_id
374: ,xla_environment_pkg.g_req_Id);
375:
376: -- Delete JLD aasignment that is no longer assigned to the header

Line 373: ,xla_environment_pkg.g_prog_id

369: ,xla_environment_pkg.g_usr_id
370: ,xla_environment_pkg.g_login_id
371: ,sysdate
372: ,xla_environment_pkg.g_prog_appl_id
373: ,xla_environment_pkg.g_prog_id
374: ,xla_environment_pkg.g_req_Id);
375:
376: -- Delete JLD aasignment that is no longer assigned to the header
377: DELETE FROM xla_aad_line_defn_assgns w

Line 374: ,xla_environment_pkg.g_req_Id);

370: ,xla_environment_pkg.g_login_id
371: ,sysdate
372: ,xla_environment_pkg.g_prog_appl_id
373: ,xla_environment_pkg.g_prog_id
374: ,xla_environment_pkg.g_req_Id);
375:
376: -- Delete JLD aasignment that is no longer assigned to the header
377: DELETE FROM xla_aad_line_defn_assgns w
378: WHERE application_id = g_application_id

Line 1581: ,xla_environment_pkg.g_usr_id

1577: ,C_OWNER_SYSTEM
1578: ,l_codes(i)
1579: ,1
1580: ,sysdate
1581: ,xla_environment_pkg.g_usr_id
1582: ,sysdate
1583: ,xla_environment_pkg.g_usr_id
1584: ,xla_environment_pkg.g_login_id
1585: ,sysdate

Line 1583: ,xla_environment_pkg.g_usr_id

1579: ,1
1580: ,sysdate
1581: ,xla_environment_pkg.g_usr_id
1582: ,sysdate
1583: ,xla_environment_pkg.g_usr_id
1584: ,xla_environment_pkg.g_login_id
1585: ,sysdate
1586: ,xla_environment_pkg.g_prog_appl_id
1587: ,xla_environment_pkg.g_prog_id

Line 1584: ,xla_environment_pkg.g_login_id

1580: ,sysdate
1581: ,xla_environment_pkg.g_usr_id
1582: ,sysdate
1583: ,xla_environment_pkg.g_usr_id
1584: ,xla_environment_pkg.g_login_id
1585: ,sysdate
1586: ,xla_environment_pkg.g_prog_appl_id
1587: ,xla_environment_pkg.g_prog_id
1588: ,xla_environment_pkg.g_req_Id

Line 1586: ,xla_environment_pkg.g_prog_appl_id

1582: ,sysdate
1583: ,xla_environment_pkg.g_usr_id
1584: ,xla_environment_pkg.g_login_id
1585: ,sysdate
1586: ,xla_environment_pkg.g_prog_appl_id
1587: ,xla_environment_pkg.g_prog_id
1588: ,xla_environment_pkg.g_req_Id
1589: FROM (SELECT application_id
1590: FROM xla_seg_rule_details s

Line 1587: ,xla_environment_pkg.g_prog_id

1583: ,xla_environment_pkg.g_usr_id
1584: ,xla_environment_pkg.g_login_id
1585: ,sysdate
1586: ,xla_environment_pkg.g_prog_appl_id
1587: ,xla_environment_pkg.g_prog_id
1588: ,xla_environment_pkg.g_req_Id
1589: FROM (SELECT application_id
1590: FROM xla_seg_rule_details s
1591: WHERE application_id <> g_application_id

Line 1588: ,xla_environment_pkg.g_req_Id

1584: ,xla_environment_pkg.g_login_id
1585: ,sysdate
1586: ,xla_environment_pkg.g_prog_appl_id
1587: ,xla_environment_pkg.g_prog_id
1588: ,xla_environment_pkg.g_req_Id
1589: FROM (SELECT application_id
1590: FROM xla_seg_rule_details s
1591: WHERE application_id <> g_application_id
1592: AND amb_context_code = g_amb_context_code

Line 2149: ,xla_environment_pkg.g_usr_id

2145: ,w.version_num
2146: ,s.version_num
2147: ,1
2148: ,sysdate
2149: ,xla_environment_pkg.g_usr_id
2150: ,sysdate
2151: ,xla_environment_pkg.g_usr_id
2152: ,xla_environment_pkg.g_login_id
2153: ,sysdate

Line 2151: ,xla_environment_pkg.g_usr_id

2147: ,1
2148: ,sysdate
2149: ,xla_environment_pkg.g_usr_id
2150: ,sysdate
2151: ,xla_environment_pkg.g_usr_id
2152: ,xla_environment_pkg.g_login_id
2153: ,sysdate
2154: ,xla_environment_pkg.g_prog_appl_id
2155: ,xla_environment_pkg.g_prog_id

Line 2152: ,xla_environment_pkg.g_login_id

2148: ,sysdate
2149: ,xla_environment_pkg.g_usr_id
2150: ,sysdate
2151: ,xla_environment_pkg.g_usr_id
2152: ,xla_environment_pkg.g_login_id
2153: ,sysdate
2154: ,xla_environment_pkg.g_prog_appl_id
2155: ,xla_environment_pkg.g_prog_id
2156: ,xla_environment_pkg.g_req_Id

Line 2154: ,xla_environment_pkg.g_prog_appl_id

2150: ,sysdate
2151: ,xla_environment_pkg.g_usr_id
2152: ,xla_environment_pkg.g_login_id
2153: ,sysdate
2154: ,xla_environment_pkg.g_prog_appl_id
2155: ,xla_environment_pkg.g_prog_id
2156: ,xla_environment_pkg.g_req_Id
2157: FROM xla_product_rules_b s
2158: , xla_product_rules_b w

Line 2155: ,xla_environment_pkg.g_prog_id

2151: ,xla_environment_pkg.g_usr_id
2152: ,xla_environment_pkg.g_login_id
2153: ,sysdate
2154: ,xla_environment_pkg.g_prog_appl_id
2155: ,xla_environment_pkg.g_prog_id
2156: ,xla_environment_pkg.g_req_Id
2157: FROM xla_product_rules_b s
2158: , xla_product_rules_b w
2159: WHERE s.application_id = g_application_id

Line 2156: ,xla_environment_pkg.g_req_Id

2152: ,xla_environment_pkg.g_login_id
2153: ,sysdate
2154: ,xla_environment_pkg.g_prog_appl_id
2155: ,xla_environment_pkg.g_prog_id
2156: ,xla_environment_pkg.g_req_Id
2157: FROM xla_product_rules_b s
2158: , xla_product_rules_b w
2159: WHERE s.application_id = g_application_id
2160: AND s.amb_context_code = g_staging_context_code

Line 6211: ,xla_environment_pkg.g_usr_id

6207: ,s.transaction_coa_id
6208: ,s.accounting_coa_id
6209: ,s.enabled_flag
6210: ,sysdate
6211: ,xla_environment_pkg.g_usr_id
6212: ,sysdate
6213: ,xla_environment_pkg.g_usr_id
6214: ,xla_environment_pkg.g_login_id
6215: FROM xla_stage_acctg_methods s

Line 6213: ,xla_environment_pkg.g_usr_id

6209: ,s.enabled_flag
6210: ,sysdate
6211: ,xla_environment_pkg.g_usr_id
6212: ,sysdate
6213: ,xla_environment_pkg.g_usr_id
6214: ,xla_environment_pkg.g_login_id
6215: FROM xla_stage_acctg_methods s
6216: LEFT OUTER JOIN xla_acctg_methods_b w
6217: ON w.accounting_method_type_code = s.accounting_method_type_code

Line 6214: ,xla_environment_pkg.g_login_id

6210: ,sysdate
6211: ,xla_environment_pkg.g_usr_id
6212: ,sysdate
6213: ,xla_environment_pkg.g_usr_id
6214: ,xla_environment_pkg.g_login_id
6215: FROM xla_stage_acctg_methods s
6216: LEFT OUTER JOIN xla_acctg_methods_b w
6217: ON w.accounting_method_type_code = s.accounting_method_type_code
6218: AND w.accounting_method_code = s.accounting_method_code

Line 6255: ,xla_environment_pkg.g_usr_id

6251: ,s.name
6252: ,s.description
6253: ,USERENV('LANG')
6254: ,sysdate
6255: ,xla_environment_pkg.g_usr_id
6256: ,sysdate
6257: ,xla_environment_pkg.g_usr_id
6258: ,xla_environment_pkg.g_login_id
6259: FROM xla_stage_acctg_methods s

Line 6257: ,xla_environment_pkg.g_usr_id

6253: ,USERENV('LANG')
6254: ,sysdate
6255: ,xla_environment_pkg.g_usr_id
6256: ,sysdate
6257: ,xla_environment_pkg.g_usr_id
6258: ,xla_environment_pkg.g_login_id
6259: FROM xla_stage_acctg_methods s
6260: JOIN fnd_languages fl
6261: ON fl.installed_flag IN ('I', 'B')

Line 6258: ,xla_environment_pkg.g_login_id

6254: ,sysdate
6255: ,xla_environment_pkg.g_usr_id
6256: ,sysdate
6257: ,xla_environment_pkg.g_usr_id
6258: ,xla_environment_pkg.g_login_id
6259: FROM xla_stage_acctg_methods s
6260: JOIN fnd_languages fl
6261: ON fl.installed_flag IN ('I', 'B')
6262: LEFT OUTER JOIN xla_acctg_methods_tl w

Line 6331: ,xla_environment_pkg.g_usr_id

6327: ,accounting_method_type_code
6328: ,accounting_method_code
6329: ,1
6330: ,sysdate
6331: ,xla_environment_pkg.g_usr_id
6332: ,sysdate
6333: ,xla_environment_pkg.g_usr_id
6334: ,xla_environment_pkg.g_login_id
6335: ,sysdate

Line 6333: ,xla_environment_pkg.g_usr_id

6329: ,1
6330: ,sysdate
6331: ,xla_environment_pkg.g_usr_id
6332: ,sysdate
6333: ,xla_environment_pkg.g_usr_id
6334: ,xla_environment_pkg.g_login_id
6335: ,sysdate
6336: ,xla_environment_pkg.g_prog_appl_id
6337: ,xla_environment_pkg.g_prog_id

Line 6334: ,xla_environment_pkg.g_login_id

6330: ,sysdate
6331: ,xla_environment_pkg.g_usr_id
6332: ,sysdate
6333: ,xla_environment_pkg.g_usr_id
6334: ,xla_environment_pkg.g_login_id
6335: ,sysdate
6336: ,xla_environment_pkg.g_prog_appl_id
6337: ,xla_environment_pkg.g_prog_id
6338: ,xla_environment_pkg.g_req_Id

Line 6336: ,xla_environment_pkg.g_prog_appl_id

6332: ,sysdate
6333: ,xla_environment_pkg.g_usr_id
6334: ,xla_environment_pkg.g_login_id
6335: ,sysdate
6336: ,xla_environment_pkg.g_prog_appl_id
6337: ,xla_environment_pkg.g_prog_id
6338: ,xla_environment_pkg.g_req_Id
6339: FROM (SELECT distinct product_rule_type_code
6340: , product_rule_code

Line 6337: ,xla_environment_pkg.g_prog_id

6333: ,xla_environment_pkg.g_usr_id
6334: ,xla_environment_pkg.g_login_id
6335: ,sysdate
6336: ,xla_environment_pkg.g_prog_appl_id
6337: ,xla_environment_pkg.g_prog_id
6338: ,xla_environment_pkg.g_req_Id
6339: FROM (SELECT distinct product_rule_type_code
6340: , product_rule_code
6341: , accounting_method_type_code

Line 6338: ,xla_environment_pkg.g_req_Id

6334: ,xla_environment_pkg.g_login_id
6335: ,sysdate
6336: ,xla_environment_pkg.g_prog_appl_id
6337: ,xla_environment_pkg.g_prog_id
6338: ,xla_environment_pkg.g_req_Id
6339: FROM (SELECT distinct product_rule_type_code
6340: , product_rule_code
6341: , accounting_method_type_code
6342: , accounting_method_code

Line 7017: g_usr_id := xla_environment_pkg.g_usr_id;

7013:
7014: -- Initialize global variables
7015: x_return_status := FND_API.G_RET_STS_SUCCESS;
7016:
7017: g_usr_id := xla_environment_pkg.g_usr_id;
7018: g_login_id := xla_environment_pkg.g_login_id;
7019: g_application_id := p_application_id;
7020: g_amb_context_code := p_amb_context_code;
7021: g_analyzed_flag := p_analyzed_flag;

Line 7018: g_login_id := xla_environment_pkg.g_login_id;

7014: -- Initialize global variables
7015: x_return_status := FND_API.G_RET_STS_SUCCESS;
7016:
7017: g_usr_id := xla_environment_pkg.g_usr_id;
7018: g_login_id := xla_environment_pkg.g_login_id;
7019: g_application_id := p_application_id;
7020: g_amb_context_code := p_amb_context_code;
7021: g_analyzed_flag := p_analyzed_flag;
7022: g_compile_flag := p_compile_flag;