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: -------------------------------------------------------------------------------
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
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: -------------------------------------------------------------------------------
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);
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);
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);
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)
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)
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)
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)
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';
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:
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);
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);
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);