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_LINE_TYPES_PKG dependencies on XLA_ENVIRONMENT_PKG

Line 27: g_created_by INTEGER := xla_environment_pkg.g_usr_id;

23: -- declaring private package variables
24: -------------------------------------------------------------------------------
25: g_creation_date DATE := sysdate;
26: g_last_update_date DATE := sysdate;
27: g_created_by INTEGER := xla_environment_pkg.g_usr_id;
28: g_last_update_login INTEGER := xla_environment_pkg.g_login_id;
29: g_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;
30:
31: -------------------------------------------------------------------------------

Line 28: g_last_update_login INTEGER := xla_environment_pkg.g_login_id;

24: -------------------------------------------------------------------------------
25: g_creation_date DATE := sysdate;
26: g_last_update_date DATE := sysdate;
27: g_created_by INTEGER := xla_environment_pkg.g_usr_id;
28: g_last_update_login INTEGER := xla_environment_pkg.g_login_id;
29: g_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;
30:
31: -------------------------------------------------------------------------------
32: -- declaring private package arrays

Line 29: g_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;

25: g_creation_date DATE := sysdate;
26: g_last_update_date DATE := sysdate;
27: g_created_by INTEGER := xla_environment_pkg.g_usr_id;
28: g_last_update_login INTEGER := xla_environment_pkg.g_login_id;
29: g_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;
30:
31: -------------------------------------------------------------------------------
32: -- declaring private package arrays
33: -------------------------------------------------------------------------------

Line 153: l_created_by INTEGER := xla_environment_pkg.g_usr_id;

149:
150: l_condition_id integer;
151: l_creation_date DATE := sysdate;
152: l_last_update_date DATE := sysdate;
153: l_created_by INTEGER := xla_environment_pkg.g_usr_id;
154: l_last_update_login INTEGER := xla_environment_pkg.g_login_id;
155: l_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;
156: l_con_flexfield_segment_code VARCHAR2(30);
157: l_con_v_flexfield_segment_code VARCHAR2(30);

Line 154: l_last_update_login INTEGER := xla_environment_pkg.g_login_id;

150: l_condition_id integer;
151: l_creation_date DATE := sysdate;
152: l_last_update_date DATE := sysdate;
153: l_created_by INTEGER := xla_environment_pkg.g_usr_id;
154: l_last_update_login INTEGER := xla_environment_pkg.g_login_id;
155: l_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;
156: l_con_flexfield_segment_code VARCHAR2(30);
157: l_con_v_flexfield_segment_code VARCHAR2(30);
158: l_source_flex_appl_id NUMBER(15);

Line 155: l_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;

151: l_creation_date DATE := sysdate;
152: l_last_update_date DATE := sysdate;
153: l_created_by INTEGER := xla_environment_pkg.g_usr_id;
154: l_last_update_login INTEGER := xla_environment_pkg.g_login_id;
155: l_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;
156: l_con_flexfield_segment_code VARCHAR2(30);
157: l_con_v_flexfield_segment_code VARCHAR2(30);
158: l_source_flex_appl_id NUMBER(15);
159: l_source_id_flex_code VARCHAR2(30);

Line 1494: , last_updated_by = xla_environment_pkg.g_usr_id

1490: UPDATE xla_product_rules_b xpr
1491: SET compile_status_code = 'N'
1492: , updated_flag = 'Y'
1493: , last_update_date = sysdate
1494: , last_updated_by = xla_environment_pkg.g_usr_id
1495: , last_update_login = xla_environment_pkg.g_login_id
1496: WHERE application_id = p_application_id
1497: AND amb_context_code = p_amb_context_code
1498: AND product_rule_type_code = l_product_rule_type_codes(i)

Line 1495: , last_update_login = xla_environment_pkg.g_login_id

1491: SET compile_status_code = 'N'
1492: , updated_flag = 'Y'
1493: , last_update_date = sysdate
1494: , last_updated_by = xla_environment_pkg.g_usr_id
1495: , last_update_login = xla_environment_pkg.g_login_id
1496: WHERE application_id = p_application_id
1497: AND amb_context_code = p_amb_context_code
1498: AND product_rule_type_code = l_product_rule_type_codes(i)
1499: AND product_rule_code = l_product_rule_codes(i)

Line 1507: , last_updated_by = xla_environment_pkg.g_usr_id

1503: FORALL i IN 1..l_event_class_codes.LAST
1504: UPDATE xla_prod_acct_headers xpa
1505: SET validation_status_code = 'N'
1506: , last_update_date = sysdate
1507: , last_updated_by = xla_environment_pkg.g_usr_id
1508: , last_update_login = xla_environment_pkg.g_login_id
1509: WHERE application_id = p_application_id
1510: AND amb_context_code = p_amb_context_code
1511: AND event_class_code = l_event_class_codes(i)

Line 1508: , last_update_login = xla_environment_pkg.g_login_id

1504: UPDATE xla_prod_acct_headers xpa
1505: SET validation_status_code = 'N'
1506: , last_update_date = sysdate
1507: , last_updated_by = xla_environment_pkg.g_usr_id
1508: , last_update_login = xla_environment_pkg.g_login_id
1509: WHERE application_id = p_application_id
1510: AND amb_context_code = p_amb_context_code
1511: AND event_class_code = l_event_class_codes(i)
1512: AND product_rule_type_code = l_product_rule_type_codes(i)

Line 1521: , last_updated_by = xla_environment_pkg.g_usr_id

1517:
1518: UPDATE xla_appli_amb_contexts
1519: SET updated_flag = 'Y'
1520: , last_update_date = sysdate
1521: , last_updated_by = xla_environment_pkg.g_usr_id
1522: , last_update_login = xla_environment_pkg.g_login_id
1523: WHERE application_id = p_application_id
1524: AND amb_context_code = p_amb_context_code
1525: AND updated_flag <> 'Y';

Line 1522: , last_update_login = xla_environment_pkg.g_login_id

1518: UPDATE xla_appli_amb_contexts
1519: SET updated_flag = 'Y'
1520: , last_update_date = sysdate
1521: , last_updated_by = xla_environment_pkg.g_usr_id
1522: , last_update_login = xla_environment_pkg.g_login_id
1523: WHERE application_id = p_application_id
1524: AND amb_context_code = p_amb_context_code
1525: AND updated_flag <> 'Y';
1526:

Line 1830: l_created_by INTEGER := xla_environment_pkg.g_usr_id;

1826:
1827: l_condition_id integer;
1828: l_creation_date DATE := sysdate;
1829: l_last_update_date DATE := sysdate;
1830: l_created_by INTEGER := xla_environment_pkg.g_usr_id;
1831: l_last_update_login INTEGER := xla_environment_pkg.g_login_id;
1832: l_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;
1833: l_con_flexfield_segment_code VARCHAR2(30);
1834: l_con_flexfield_segment_name VARCHAR2(80);

Line 1831: l_last_update_login INTEGER := xla_environment_pkg.g_login_id;

1827: l_condition_id integer;
1828: l_creation_date DATE := sysdate;
1829: l_last_update_date DATE := sysdate;
1830: l_created_by INTEGER := xla_environment_pkg.g_usr_id;
1831: l_last_update_login INTEGER := xla_environment_pkg.g_login_id;
1832: l_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;
1833: l_con_flexfield_segment_code VARCHAR2(30);
1834: l_con_flexfield_segment_name VARCHAR2(80);
1835: l_con_v_flexfield_segment_code VARCHAR2(30);

Line 1832: l_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;

1828: l_creation_date DATE := sysdate;
1829: l_last_update_date DATE := sysdate;
1830: l_created_by INTEGER := xla_environment_pkg.g_usr_id;
1831: l_last_update_login INTEGER := xla_environment_pkg.g_login_id;
1832: l_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;
1833: l_con_flexfield_segment_code VARCHAR2(30);
1834: l_con_flexfield_segment_name VARCHAR2(80);
1835: l_con_v_flexfield_segment_code VARCHAR2(30);
1836: l_con_v_flexfield_segment_name VARCHAR2(80);