eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_AAD_EXPORT_PVT dependencies on XLA_ENVIRONMENT_PKG

Line 1549: ,xla_environment_pkg.g_usr_id

1545: ,p_version_comment
1546: ,DECODE(p_versioning_mode,'LEAPFROG','Y','N')
1547: ,1
1548: ,sysdate
1549: ,xla_environment_pkg.g_usr_id
1550: ,sysdate
1551: ,xla_environment_pkg.g_usr_id
1552: ,xla_environment_pkg.g_login_id
1553: ,sysdate

Line 1551: ,xla_environment_pkg.g_usr_id

1547: ,1
1548: ,sysdate
1549: ,xla_environment_pkg.g_usr_id
1550: ,sysdate
1551: ,xla_environment_pkg.g_usr_id
1552: ,xla_environment_pkg.g_login_id
1553: ,sysdate
1554: ,xla_environment_pkg.g_prog_appl_id
1555: ,xla_environment_pkg.g_prog_id

Line 1552: ,xla_environment_pkg.g_login_id

1548: ,sysdate
1549: ,xla_environment_pkg.g_usr_id
1550: ,sysdate
1551: ,xla_environment_pkg.g_usr_id
1552: ,xla_environment_pkg.g_login_id
1553: ,sysdate
1554: ,xla_environment_pkg.g_prog_appl_id
1555: ,xla_environment_pkg.g_prog_id
1556: ,xla_environment_pkg.g_req_Id);

Line 1554: ,xla_environment_pkg.g_prog_appl_id

1550: ,sysdate
1551: ,xla_environment_pkg.g_usr_id
1552: ,xla_environment_pkg.g_login_id
1553: ,sysdate
1554: ,xla_environment_pkg.g_prog_appl_id
1555: ,xla_environment_pkg.g_prog_id
1556: ,xla_environment_pkg.g_req_Id);
1557:
1558: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1555: ,xla_environment_pkg.g_prog_id

1551: ,xla_environment_pkg.g_usr_id
1552: ,xla_environment_pkg.g_login_id
1553: ,sysdate
1554: ,xla_environment_pkg.g_prog_appl_id
1555: ,xla_environment_pkg.g_prog_id
1556: ,xla_environment_pkg.g_req_Id);
1557:
1558: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1559: trace(p_msg => '# row inserted in xla_aads_h = '||SQL%ROWCOUNT,

Line 1556: ,xla_environment_pkg.g_req_Id);

1552: ,xla_environment_pkg.g_login_id
1553: ,sysdate
1554: ,xla_environment_pkg.g_prog_appl_id
1555: ,xla_environment_pkg.g_prog_id
1556: ,xla_environment_pkg.g_req_Id);
1557:
1558: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1559: trace(p_msg => '# row inserted in xla_aads_h = '||SQL%ROWCOUNT,
1560: p_module => l_log_module,

Line 1596: ,created_by = xla_environment_pkg.g_usr_id

1592: SET version_num = l_versions_to(i)
1593: ,updated_flag = 'N'
1594: ,product_rule_version = p_user_version
1595: ,creation_date = sysdate
1596: ,created_by = xla_environment_pkg.g_usr_id
1597: ,last_update_date = sysdate
1598: ,last_updated_by = xla_environment_pkg.g_usr_id
1599: ,last_update_login = xla_environment_pkg.g_login_id
1600: WHERE application_id = p_application_id

Line 1598: ,last_updated_by = xla_environment_pkg.g_usr_id

1594: ,product_rule_version = p_user_version
1595: ,creation_date = sysdate
1596: ,created_by = xla_environment_pkg.g_usr_id
1597: ,last_update_date = sysdate
1598: ,last_updated_by = xla_environment_pkg.g_usr_id
1599: ,last_update_login = xla_environment_pkg.g_login_id
1600: WHERE application_id = p_application_id
1601: AND amb_context_code = p_amb_context_code
1602: AND product_rule_type_code = p_owner_type

Line 1599: ,last_update_login = xla_environment_pkg.g_login_id

1595: ,creation_date = sysdate
1596: ,created_by = xla_environment_pkg.g_usr_id
1597: ,last_update_date = sysdate
1598: ,last_updated_by = xla_environment_pkg.g_usr_id
1599: ,last_update_login = xla_environment_pkg.g_login_id
1600: WHERE application_id = p_application_id
1601: AND amb_context_code = p_amb_context_code
1602: AND product_rule_type_code = p_owner_type
1603: AND product_rule_code = l_aad_codes(i);

Line 1616: , program_application_id = xla_environment_pkg.g_prog_appl_id

1612: UPDATE xla_aads_h
1613: SET user_version = p_user_version
1614: , version_comment = p_version_comment
1615: , program_update_date = sysdate
1616: , program_application_id = xla_environment_pkg.g_prog_appl_id
1617: , program_id = xla_environment_pkg.g_prog_id
1618: , request_id = xla_environment_pkg.g_req_Id
1619: WHERE application_id = p_application_id
1620: AND product_rule_type_code = p_owner_type

Line 1617: , program_id = xla_environment_pkg.g_prog_id

1613: SET user_version = p_user_version
1614: , version_comment = p_version_comment
1615: , program_update_date = sysdate
1616: , program_application_id = xla_environment_pkg.g_prog_appl_id
1617: , program_id = xla_environment_pkg.g_prog_id
1618: , request_id = xla_environment_pkg.g_req_Id
1619: WHERE application_id = p_application_id
1620: AND product_rule_type_code = p_owner_type
1621: AND product_rule_code = l_aad_codes(i)

Line 1618: , request_id = xla_environment_pkg.g_req_Id

1614: , version_comment = p_version_comment
1615: , program_update_date = sysdate
1616: , program_application_id = xla_environment_pkg.g_prog_appl_id
1617: , program_id = xla_environment_pkg.g_prog_id
1618: , request_id = xla_environment_pkg.g_req_Id
1619: WHERE application_id = p_application_id
1620: AND product_rule_type_code = p_owner_type
1621: AND product_rule_code = l_aad_codes(i)
1622: AND version_num = l_versions_to(i)

Line 1771: ,xla_environment_pkg.g_usr_id

1767: ,l_ac_version_from(i)
1768: ,DECODE(p_versioning_mode,'LEAPFROG','Y','N')
1769: ,1
1770: ,sysdate
1771: ,xla_environment_pkg.g_usr_id
1772: ,sysdate
1773: ,xla_environment_pkg.g_usr_id
1774: ,xla_environment_pkg.g_login_id
1775: ,sysdate

Line 1773: ,xla_environment_pkg.g_usr_id

1769: ,1
1770: ,sysdate
1771: ,xla_environment_pkg.g_usr_id
1772: ,sysdate
1773: ,xla_environment_pkg.g_usr_id
1774: ,xla_environment_pkg.g_login_id
1775: ,sysdate
1776: ,xla_environment_pkg.g_prog_appl_id
1777: ,xla_environment_pkg.g_prog_id

Line 1774: ,xla_environment_pkg.g_login_id

1770: ,sysdate
1771: ,xla_environment_pkg.g_usr_id
1772: ,sysdate
1773: ,xla_environment_pkg.g_usr_id
1774: ,xla_environment_pkg.g_login_id
1775: ,sysdate
1776: ,xla_environment_pkg.g_prog_appl_id
1777: ,xla_environment_pkg.g_prog_id
1778: ,xla_environment_pkg.g_req_Id);

Line 1776: ,xla_environment_pkg.g_prog_appl_id

1772: ,sysdate
1773: ,xla_environment_pkg.g_usr_id
1774: ,xla_environment_pkg.g_login_id
1775: ,sysdate
1776: ,xla_environment_pkg.g_prog_appl_id
1777: ,xla_environment_pkg.g_prog_id
1778: ,xla_environment_pkg.g_req_Id);
1779:
1780: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1777: ,xla_environment_pkg.g_prog_id

1773: ,xla_environment_pkg.g_usr_id
1774: ,xla_environment_pkg.g_login_id
1775: ,sysdate
1776: ,xla_environment_pkg.g_prog_appl_id
1777: ,xla_environment_pkg.g_prog_id
1778: ,xla_environment_pkg.g_req_Id);
1779:
1780: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1781: trace(p_msg => '# row inserted in xla_amb_components_h = '||SQL%ROWCOUNT,

Line 1778: ,xla_environment_pkg.g_req_Id);

1774: ,xla_environment_pkg.g_login_id
1775: ,sysdate
1776: ,xla_environment_pkg.g_prog_appl_id
1777: ,xla_environment_pkg.g_prog_id
1778: ,xla_environment_pkg.g_req_Id);
1779:
1780: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1781: trace(p_msg => '# row inserted in xla_amb_components_h = '||SQL%ROWCOUNT,
1782: p_module => l_log_module,

Line 1791: ,created_by = xla_environment_pkg.g_usr_id

1787: UPDATE xla_analytical_hdrs_b
1788: SET version_num = l_ac_version_to(i)
1789: ,updated_flag = 'N'
1790: ,creation_date = sysdate
1791: ,created_by = xla_environment_pkg.g_usr_id
1792: ,last_update_date = sysdate
1793: ,last_updated_by = xla_environment_pkg.g_usr_id
1794: ,last_update_login = xla_environment_pkg.g_login_id
1795: WHERE analytical_criterion_type_code = l_ac_owner_codes(i)

Line 1793: ,last_updated_by = xla_environment_pkg.g_usr_id

1789: ,updated_flag = 'N'
1790: ,creation_date = sysdate
1791: ,created_by = xla_environment_pkg.g_usr_id
1792: ,last_update_date = sysdate
1793: ,last_updated_by = xla_environment_pkg.g_usr_id
1794: ,last_update_login = xla_environment_pkg.g_login_id
1795: WHERE analytical_criterion_type_code = l_ac_owner_codes(i)
1796: AND analytical_criterion_code = l_ac_codes(i)
1797: AND amb_context_code = p_amb_context_code;

Line 1794: ,last_update_login = xla_environment_pkg.g_login_id

1790: ,creation_date = sysdate
1791: ,created_by = xla_environment_pkg.g_usr_id
1792: ,last_update_date = sysdate
1793: ,last_updated_by = xla_environment_pkg.g_usr_id
1794: ,last_update_login = xla_environment_pkg.g_login_id
1795: WHERE analytical_criterion_type_code = l_ac_owner_codes(i)
1796: AND analytical_criterion_code = l_ac_codes(i)
1797: AND amb_context_code = p_amb_context_code;
1798:

Line 1931: ,xla_environment_pkg.g_usr_id

1927: ,l_adr_version_from(i)
1928: ,DECODE(p_versioning_mode,'LEAPFROG','Y','N')
1929: ,1
1930: ,sysdate
1931: ,xla_environment_pkg.g_usr_id
1932: ,sysdate
1933: ,xla_environment_pkg.g_usr_id
1934: ,xla_environment_pkg.g_login_id
1935: ,sysdate

Line 1933: ,xla_environment_pkg.g_usr_id

1929: ,1
1930: ,sysdate
1931: ,xla_environment_pkg.g_usr_id
1932: ,sysdate
1933: ,xla_environment_pkg.g_usr_id
1934: ,xla_environment_pkg.g_login_id
1935: ,sysdate
1936: ,xla_environment_pkg.g_prog_appl_id
1937: ,xla_environment_pkg.g_prog_id

Line 1934: ,xla_environment_pkg.g_login_id

1930: ,sysdate
1931: ,xla_environment_pkg.g_usr_id
1932: ,sysdate
1933: ,xla_environment_pkg.g_usr_id
1934: ,xla_environment_pkg.g_login_id
1935: ,sysdate
1936: ,xla_environment_pkg.g_prog_appl_id
1937: ,xla_environment_pkg.g_prog_id
1938: ,xla_environment_pkg.g_req_Id);

Line 1936: ,xla_environment_pkg.g_prog_appl_id

1932: ,sysdate
1933: ,xla_environment_pkg.g_usr_id
1934: ,xla_environment_pkg.g_login_id
1935: ,sysdate
1936: ,xla_environment_pkg.g_prog_appl_id
1937: ,xla_environment_pkg.g_prog_id
1938: ,xla_environment_pkg.g_req_Id);
1939:
1940: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1937: ,xla_environment_pkg.g_prog_id

1933: ,xla_environment_pkg.g_usr_id
1934: ,xla_environment_pkg.g_login_id
1935: ,sysdate
1936: ,xla_environment_pkg.g_prog_appl_id
1937: ,xla_environment_pkg.g_prog_id
1938: ,xla_environment_pkg.g_req_Id);
1939:
1940: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1941: trace(p_msg => '# row inserted in xla_amb_components_h = '||SQL%ROWCOUNT,

Line 1938: ,xla_environment_pkg.g_req_Id);

1934: ,xla_environment_pkg.g_login_id
1935: ,sysdate
1936: ,xla_environment_pkg.g_prog_appl_id
1937: ,xla_environment_pkg.g_prog_id
1938: ,xla_environment_pkg.g_req_Id);
1939:
1940: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1941: trace(p_msg => '# row inserted in xla_amb_components_h = '||SQL%ROWCOUNT,
1942: p_module => l_log_module,

Line 1951: ,created_by = xla_environment_pkg.g_usr_id

1947: UPDATE xla_seg_rules_b
1948: SET version_num = l_adr_version_to(i)
1949: ,updated_flag = 'N'
1950: ,creation_date = sysdate
1951: ,created_by = xla_environment_pkg.g_usr_id
1952: ,last_update_date = sysdate
1953: ,last_updated_by = xla_environment_pkg.g_usr_id
1954: ,last_update_login = xla_environment_pkg.g_login_id
1955: WHERE segment_rule_type_code = l_adr_owner_codes(i)

Line 1953: ,last_updated_by = xla_environment_pkg.g_usr_id

1949: ,updated_flag = 'N'
1950: ,creation_date = sysdate
1951: ,created_by = xla_environment_pkg.g_usr_id
1952: ,last_update_date = sysdate
1953: ,last_updated_by = xla_environment_pkg.g_usr_id
1954: ,last_update_login = xla_environment_pkg.g_login_id
1955: WHERE segment_rule_type_code = l_adr_owner_codes(i)
1956: AND segment_rule_code = l_adr_codes(i)
1957: AND application_id = p_application_id

Line 1954: ,last_update_login = xla_environment_pkg.g_login_id

1950: ,creation_date = sysdate
1951: ,created_by = xla_environment_pkg.g_usr_id
1952: ,last_update_date = sysdate
1953: ,last_updated_by = xla_environment_pkg.g_usr_id
1954: ,last_update_login = xla_environment_pkg.g_login_id
1955: WHERE segment_rule_type_code = l_adr_owner_codes(i)
1956: AND segment_rule_code = l_adr_codes(i)
1957: AND application_id = p_application_id
1958: AND amb_context_code = p_amb_context_code;

Line 2090: ,xla_environment_pkg.g_usr_id

2086: ,l_ms_version_from(i)
2087: ,DECODE(p_versioning_mode,'LEAPFROG','Y','N')
2088: ,1
2089: ,sysdate
2090: ,xla_environment_pkg.g_usr_id
2091: ,sysdate
2092: ,xla_environment_pkg.g_usr_id
2093: ,xla_environment_pkg.g_login_id
2094: ,sysdate

Line 2092: ,xla_environment_pkg.g_usr_id

2088: ,1
2089: ,sysdate
2090: ,xla_environment_pkg.g_usr_id
2091: ,sysdate
2092: ,xla_environment_pkg.g_usr_id
2093: ,xla_environment_pkg.g_login_id
2094: ,sysdate
2095: ,xla_environment_pkg.g_prog_appl_id
2096: ,xla_environment_pkg.g_prog_id

Line 2093: ,xla_environment_pkg.g_login_id

2089: ,sysdate
2090: ,xla_environment_pkg.g_usr_id
2091: ,sysdate
2092: ,xla_environment_pkg.g_usr_id
2093: ,xla_environment_pkg.g_login_id
2094: ,sysdate
2095: ,xla_environment_pkg.g_prog_appl_id
2096: ,xla_environment_pkg.g_prog_id
2097: ,xla_environment_pkg.g_req_Id);

Line 2095: ,xla_environment_pkg.g_prog_appl_id

2091: ,sysdate
2092: ,xla_environment_pkg.g_usr_id
2093: ,xla_environment_pkg.g_login_id
2094: ,sysdate
2095: ,xla_environment_pkg.g_prog_appl_id
2096: ,xla_environment_pkg.g_prog_id
2097: ,xla_environment_pkg.g_req_Id);
2098:
2099: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 2096: ,xla_environment_pkg.g_prog_id

2092: ,xla_environment_pkg.g_usr_id
2093: ,xla_environment_pkg.g_login_id
2094: ,sysdate
2095: ,xla_environment_pkg.g_prog_appl_id
2096: ,xla_environment_pkg.g_prog_id
2097: ,xla_environment_pkg.g_req_Id);
2098:
2099: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2100: trace(p_msg => '# row inserted in xla_amb_components_h = '||SQL%ROWCOUNT,

Line 2097: ,xla_environment_pkg.g_req_Id);

2093: ,xla_environment_pkg.g_login_id
2094: ,sysdate
2095: ,xla_environment_pkg.g_prog_appl_id
2096: ,xla_environment_pkg.g_prog_id
2097: ,xla_environment_pkg.g_req_Id);
2098:
2099: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2100: trace(p_msg => '# row inserted in xla_amb_components_h = '||SQL%ROWCOUNT,
2101: p_module => l_log_module,

Line 2110: ,created_by = xla_environment_pkg.g_usr_id

2106: UPDATE xla_mapping_sets_b
2107: SET version_num = l_ms_version_to(i)
2108: ,updated_flag = 'N'
2109: ,creation_date = sysdate
2110: ,created_by = xla_environment_pkg.g_usr_id
2111: ,last_update_date = sysdate
2112: ,last_updated_by = xla_environment_pkg.g_usr_id
2113: ,last_update_login = xla_environment_pkg.g_login_id
2114: WHERE mapping_set_code = l_ms_codes(i)

Line 2112: ,last_updated_by = xla_environment_pkg.g_usr_id

2108: ,updated_flag = 'N'
2109: ,creation_date = sysdate
2110: ,created_by = xla_environment_pkg.g_usr_id
2111: ,last_update_date = sysdate
2112: ,last_updated_by = xla_environment_pkg.g_usr_id
2113: ,last_update_login = xla_environment_pkg.g_login_id
2114: WHERE mapping_set_code = l_ms_codes(i)
2115: AND amb_context_code = p_amb_context_code;
2116:

Line 2113: ,last_update_login = xla_environment_pkg.g_login_id

2109: ,creation_date = sysdate
2110: ,created_by = xla_environment_pkg.g_usr_id
2111: ,last_update_date = sysdate
2112: ,last_updated_by = xla_environment_pkg.g_usr_id
2113: ,last_update_login = xla_environment_pkg.g_login_id
2114: WHERE mapping_set_code = l_ms_codes(i)
2115: AND amb_context_code = p_amb_context_code;
2116:
2117: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 2195: ,xla_environment_pkg.g_usr_id

2191: ,product_rule_type_code
2192: ,version_num
2193: ,1
2194: ,sysdate
2195: ,xla_environment_pkg.g_usr_id
2196: ,sysdate
2197: ,xla_environment_pkg.g_usr_id
2198: ,xla_environment_pkg.g_login_id
2199: ,sysdate

Line 2197: ,xla_environment_pkg.g_usr_id

2193: ,1
2194: ,sysdate
2195: ,xla_environment_pkg.g_usr_id
2196: ,sysdate
2197: ,xla_environment_pkg.g_usr_id
2198: ,xla_environment_pkg.g_login_id
2199: ,sysdate
2200: ,xla_environment_pkg.g_prog_appl_id
2201: ,xla_environment_pkg.g_prog_id

Line 2198: ,xla_environment_pkg.g_login_id

2194: ,sysdate
2195: ,xla_environment_pkg.g_usr_id
2196: ,sysdate
2197: ,xla_environment_pkg.g_usr_id
2198: ,xla_environment_pkg.g_login_id
2199: ,sysdate
2200: ,xla_environment_pkg.g_prog_appl_id
2201: ,xla_environment_pkg.g_prog_id
2202: ,xla_environment_pkg.g_req_Id

Line 2200: ,xla_environment_pkg.g_prog_appl_id

2196: ,sysdate
2197: ,xla_environment_pkg.g_usr_id
2198: ,xla_environment_pkg.g_login_id
2199: ,sysdate
2200: ,xla_environment_pkg.g_prog_appl_id
2201: ,xla_environment_pkg.g_prog_id
2202: ,xla_environment_pkg.g_req_Id
2203: FROM xla_product_rules_b
2204: WHERE application_id = p_application_id

Line 2201: ,xla_environment_pkg.g_prog_id

2197: ,xla_environment_pkg.g_usr_id
2198: ,xla_environment_pkg.g_login_id
2199: ,sysdate
2200: ,xla_environment_pkg.g_prog_appl_id
2201: ,xla_environment_pkg.g_prog_id
2202: ,xla_environment_pkg.g_req_Id
2203: FROM xla_product_rules_b
2204: WHERE application_id = p_application_id
2205: AND amb_context_code = p_amb_context_code;

Line 2202: ,xla_environment_pkg.g_req_Id

2198: ,xla_environment_pkg.g_login_id
2199: ,sysdate
2200: ,xla_environment_pkg.g_prog_appl_id
2201: ,xla_environment_pkg.g_prog_id
2202: ,xla_environment_pkg.g_req_Id
2203: FROM xla_product_rules_b
2204: WHERE application_id = p_application_id
2205: AND amb_context_code = p_amb_context_code;
2206: