APPS.XLA_SEG_RULES_PKG dependencies on XLA_ENVIRONMENT_PKG

Line 208: l_created_by := xla_environment_pkg.g_usr_id;

204:
205:
206: l_creation_date := sysdate;
207: l_last_update_date := sysdate;
208: l_created_by := xla_environment_pkg.g_usr_id;
209: l_last_update_login := xla_environment_pkg.g_login_id;
210: l_last_updated_by := xla_environment_pkg.g_usr_id;
211:
212: OPEN c_seg_rule_details;

Line 209: l_last_update_login := xla_environment_pkg.g_login_id;

205:
206: l_creation_date := sysdate;
207: l_last_update_date := sysdate;
208: l_created_by := xla_environment_pkg.g_usr_id;
209: l_last_update_login := xla_environment_pkg.g_login_id;
210: l_last_updated_by := xla_environment_pkg.g_usr_id;
211:
212: OPEN c_seg_rule_details;
213: LOOP

Line 210: l_last_updated_by := xla_environment_pkg.g_usr_id;

206: l_creation_date := sysdate;
207: l_last_update_date := sysdate;
208: l_created_by := xla_environment_pkg.g_usr_id;
209: l_last_update_login := xla_environment_pkg.g_login_id;
210: l_last_updated_by := xla_environment_pkg.g_usr_id;
211:
212: OPEN c_seg_rule_details;
213: LOOP
214: FETCH c_seg_rule_details

Line 944: , last_updated_by = xla_environment_pkg.g_usr_id

940:
941: UPDATE xla_line_definitions_b xld
942: SET validation_status_code = 'N'
943: , last_update_date = sysdate
944: , last_updated_by = xla_environment_pkg.g_usr_id
945: , last_update_login = xla_environment_pkg.g_login_id
946: WHERE xld.application_id = p_application_id
947: AND xld.amb_context_code = p_amb_context_code
948: AND xld.validation_status_code <> 'N'

Line 945: , last_update_login = xla_environment_pkg.g_login_id

941: UPDATE xla_line_definitions_b xld
942: SET validation_status_code = 'N'
943: , last_update_date = sysdate
944: , last_updated_by = xla_environment_pkg.g_usr_id
945: , last_update_login = xla_environment_pkg.g_login_id
946: WHERE xld.application_id = p_application_id
947: AND xld.amb_context_code = p_amb_context_code
948: AND xld.validation_status_code <> 'N'
949: AND EXISTS

Line 974: , last_updated_by = xla_environment_pkg.g_usr_id

970: UPDATE xla_product_rules_b
971: SET compile_status_code = 'N'
972: , updated_flag = 'Y'
973: , last_update_date = sysdate
974: , last_updated_by = xla_environment_pkg.g_usr_id
975: , last_update_login = xla_environment_pkg.g_login_id
976: WHERE application_id = p_application_id
977: AND amb_context_code = p_amb_context_code
978: AND product_rule_type_code = l_product_rule_type_codes(i)

Line 975: , last_update_login = xla_environment_pkg.g_login_id

971: SET compile_status_code = 'N'
972: , updated_flag = 'Y'
973: , last_update_date = sysdate
974: , last_updated_by = xla_environment_pkg.g_usr_id
975: , last_update_login = xla_environment_pkg.g_login_id
976: WHERE application_id = p_application_id
977: AND amb_context_code = p_amb_context_code
978: AND product_rule_type_code = l_product_rule_type_codes(i)
979: AND product_rule_code = l_product_rule_codes(i)

Line 987: , last_updated_by = xla_environment_pkg.g_usr_id

983: FORALL i IN 1..l_event_class_codes.LAST
984: UPDATE xla_prod_acct_headers xpa
985: SET validation_status_code = 'N'
986: , last_update_date = sysdate
987: , last_updated_by = xla_environment_pkg.g_usr_id
988: , last_update_login = xla_environment_pkg.g_login_id
989: WHERE application_id = p_application_id
990: AND amb_context_code = p_amb_context_code
991: AND event_class_code = l_event_class_codes(i)

Line 988: , last_update_login = xla_environment_pkg.g_login_id

984: UPDATE xla_prod_acct_headers xpa
985: SET validation_status_code = 'N'
986: , last_update_date = sysdate
987: , last_updated_by = xla_environment_pkg.g_usr_id
988: , last_update_login = xla_environment_pkg.g_login_id
989: WHERE application_id = p_application_id
990: AND amb_context_code = p_amb_context_code
991: AND event_class_code = l_event_class_codes(i)
992: AND product_rule_type_code = l_product_rule_type_codes(i)

Line 1001: , last_updated_by = xla_environment_pkg.g_usr_id

997:
998: UPDATE xla_appli_amb_contexts
999: SET updated_flag = 'Y'
1000: , last_update_date = sysdate
1001: , last_updated_by = xla_environment_pkg.g_usr_id
1002: , last_update_login = xla_environment_pkg.g_login_id
1003: WHERE application_id = p_application_id
1004: AND amb_context_code = p_amb_context_code
1005: AND updated_flag <> 'Y';

Line 1002: , last_update_login = xla_environment_pkg.g_login_id

998: UPDATE xla_appli_amb_contexts
999: SET updated_flag = 'Y'
1000: , last_update_date = sysdate
1001: , last_updated_by = xla_environment_pkg.g_usr_id
1002: , last_update_login = xla_environment_pkg.g_login_id
1003: WHERE application_id = p_application_id
1004: AND amb_context_code = p_amb_context_code
1005: AND updated_flag <> 'Y';
1006: