1414: UPDATE xla_events
1415: SET event_status_code = p_event_status_code
1416: ,process_status_code = C_INTERNAL_UNPROCESSED
1417: ,last_update_date = sysdate
1418: ,last_updated_by = xla_environment_pkg.g_usr_id
1419: ,last_update_login = xla_environment_pkg.g_login_id
1420: ,program_update_date = sysdate
1421: ,program_application_id = xla_environment_pkg.g_prog_appl_id
1422: ,program_id = xla_environment_pkg.g_prog_id
1415: SET event_status_code = p_event_status_code
1416: ,process_status_code = C_INTERNAL_UNPROCESSED
1417: ,last_update_date = sysdate
1418: ,last_updated_by = xla_environment_pkg.g_usr_id
1419: ,last_update_login = xla_environment_pkg.g_login_id
1420: ,program_update_date = sysdate
1421: ,program_application_id = xla_environment_pkg.g_prog_appl_id
1422: ,program_id = xla_environment_pkg.g_prog_id
1423: ,request_id = xla_environment_pkg.g_Req_Id
1417: ,last_update_date = sysdate
1418: ,last_updated_by = xla_environment_pkg.g_usr_id
1419: ,last_update_login = xla_environment_pkg.g_login_id
1420: ,program_update_date = sysdate
1421: ,program_application_id = xla_environment_pkg.g_prog_appl_id
1422: ,program_id = xla_environment_pkg.g_prog_id
1423: ,request_id = xla_environment_pkg.g_Req_Id
1424: WHERE event_id = l_array_events(i);
1425: if(g_gapless_flag='Y') then
1418: ,last_updated_by = xla_environment_pkg.g_usr_id
1419: ,last_update_login = xla_environment_pkg.g_login_id
1420: ,program_update_date = sysdate
1421: ,program_application_id = xla_environment_pkg.g_prog_appl_id
1422: ,program_id = xla_environment_pkg.g_prog_id
1423: ,request_id = xla_environment_pkg.g_Req_Id
1424: WHERE event_id = l_array_events(i);
1425: if(g_gapless_flag='Y') then
1426:
1419: ,last_update_login = xla_environment_pkg.g_login_id
1420: ,program_update_date = sysdate
1421: ,program_application_id = xla_environment_pkg.g_prog_appl_id
1422: ,program_id = xla_environment_pkg.g_prog_id
1423: ,request_id = xla_environment_pkg.g_Req_Id
1424: WHERE event_id = l_array_events(i);
1425: if(g_gapless_flag='Y') then
1426:
1427: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1896: p_reference_info.reference_date_3,reference_date_3)
1897: ,reference_date_4 = DECODE(p_overwrite_ref_info,C_YES,
1898: p_reference_info.reference_date_4,reference_date_4)
1899: ,last_update_date = sysdate
1900: ,last_updated_by = xla_environment_pkg.g_usr_id
1901: ,last_update_login = xla_environment_pkg.g_login_id
1902: ,program_update_date = sysdate
1903: ,program_application_id= xla_environment_pkg.g_prog_appl_id
1904: ,program_id = xla_environment_pkg.g_prog_id
1897: ,reference_date_4 = DECODE(p_overwrite_ref_info,C_YES,
1898: p_reference_info.reference_date_4,reference_date_4)
1899: ,last_update_date = sysdate
1900: ,last_updated_by = xla_environment_pkg.g_usr_id
1901: ,last_update_login = xla_environment_pkg.g_login_id
1902: ,program_update_date = sysdate
1903: ,program_application_id= xla_environment_pkg.g_prog_appl_id
1904: ,program_id = xla_environment_pkg.g_prog_id
1905: ,request_id = xla_environment_pkg.g_Req_Id
1899: ,last_update_date = sysdate
1900: ,last_updated_by = xla_environment_pkg.g_usr_id
1901: ,last_update_login = xla_environment_pkg.g_login_id
1902: ,program_update_date = sysdate
1903: ,program_application_id= xla_environment_pkg.g_prog_appl_id
1904: ,program_id = xla_environment_pkg.g_prog_id
1905: ,request_id = xla_environment_pkg.g_Req_Id
1906: WHERE event_id = p_event_id
1907: AND entity_id = g_entity_id
1900: ,last_updated_by = xla_environment_pkg.g_usr_id
1901: ,last_update_login = xla_environment_pkg.g_login_id
1902: ,program_update_date = sysdate
1903: ,program_application_id= xla_environment_pkg.g_prog_appl_id
1904: ,program_id = xla_environment_pkg.g_prog_id
1905: ,request_id = xla_environment_pkg.g_Req_Id
1906: WHERE event_id = p_event_id
1907: AND entity_id = g_entity_id
1908: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED;
1901: ,last_update_login = xla_environment_pkg.g_login_id
1902: ,program_update_date = sysdate
1903: ,program_application_id= xla_environment_pkg.g_prog_appl_id
1904: ,program_id = xla_environment_pkg.g_prog_id
1905: ,request_id = xla_environment_pkg.g_Req_Id
1906: WHERE event_id = p_event_id
1907: AND entity_id = g_entity_id
1908: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED;
1909:
2353: p_reference_info.reference_date_3,reference_date_3)
2354: ,reference_date_4 = DECODE(p_overwrite_ref_info,C_YES,
2355: p_reference_info.reference_date_4,reference_date_4)
2356: ,last_update_date = sysdate
2357: ,last_updated_by = xla_environment_pkg.g_usr_id
2358: ,last_update_login = xla_environment_pkg.g_login_id
2359: ,program_update_date = sysdate
2360: ,program_application_id= xla_environment_pkg.g_prog_appl_id
2361: ,program_id = xla_environment_pkg.g_prog_id
2354: ,reference_date_4 = DECODE(p_overwrite_ref_info,C_YES,
2355: p_reference_info.reference_date_4,reference_date_4)
2356: ,last_update_date = sysdate
2357: ,last_updated_by = xla_environment_pkg.g_usr_id
2358: ,last_update_login = xla_environment_pkg.g_login_id
2359: ,program_update_date = sysdate
2360: ,program_application_id= xla_environment_pkg.g_prog_appl_id
2361: ,program_id = xla_environment_pkg.g_prog_id
2362: ,request_id = xla_environment_pkg.g_Req_Id
2356: ,last_update_date = sysdate
2357: ,last_updated_by = xla_environment_pkg.g_usr_id
2358: ,last_update_login = xla_environment_pkg.g_login_id
2359: ,program_update_date = sysdate
2360: ,program_application_id= xla_environment_pkg.g_prog_appl_id
2361: ,program_id = xla_environment_pkg.g_prog_id
2362: ,request_id = xla_environment_pkg.g_Req_Id
2363: WHERE event_id = p_event_id
2364: AND entity_id = g_entity_id
2357: ,last_updated_by = xla_environment_pkg.g_usr_id
2358: ,last_update_login = xla_environment_pkg.g_login_id
2359: ,program_update_date = sysdate
2360: ,program_application_id= xla_environment_pkg.g_prog_appl_id
2361: ,program_id = xla_environment_pkg.g_prog_id
2362: ,request_id = xla_environment_pkg.g_Req_Id
2363: WHERE event_id = p_event_id
2364: AND entity_id = g_entity_id
2365: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED;
2358: ,last_update_login = xla_environment_pkg.g_login_id
2359: ,program_update_date = sysdate
2360: ,program_application_id= xla_environment_pkg.g_prog_appl_id
2361: ,program_id = xla_environment_pkg.g_prog_id
2362: ,request_id = xla_environment_pkg.g_Req_Id
2363: WHERE event_id = p_event_id
2364: AND entity_id = g_entity_id
2365: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED;
2366:
5176: , xe.legal_entity_id /* Bug 4458604*/
5177: , p_entity_type_code
5178: , xe.transaction_number
5179: , sysdate
5180: , xla_environment_pkg.g_usr_id
5181: , sysdate
5182: , xla_environment_pkg.g_usr_id
5183: , xla_environment_pkg.g_login_id
5184: , xe.valuation_method
5178: , xe.transaction_number
5179: , sysdate
5180: , xla_environment_pkg.g_usr_id
5181: , sysdate
5182: , xla_environment_pkg.g_usr_id
5183: , xla_environment_pkg.g_login_id
5184: , xe.valuation_method
5185: , xe.security_id_int_1
5186: , xe.security_id_int_2
5179: , sysdate
5180: , xla_environment_pkg.g_usr_id
5181: , sysdate
5182: , xla_environment_pkg.g_usr_id
5183: , xla_environment_pkg.g_login_id
5184: , xe.valuation_method
5185: , xe.security_id_int_1
5186: , xe.security_id_int_2
5187: , xe.security_id_int_3
5344: ,TRUNC(event_date)
5345: ,nvl(transaction_date, TRUNC(event_date))
5346: ,nvl(xla_events_int_gt.budgetary_control_flag,'N')
5347: ,sysdate
5348: ,xla_environment_pkg.g_usr_id
5349: ,sysdate
5350: ,xla_environment_pkg.g_usr_id
5351: ,xla_environment_pkg.g_login_id
5352: ,sysdate
5346: ,nvl(xla_events_int_gt.budgetary_control_flag,'N')
5347: ,sysdate
5348: ,xla_environment_pkg.g_usr_id
5349: ,sysdate
5350: ,xla_environment_pkg.g_usr_id
5351: ,xla_environment_pkg.g_login_id
5352: ,sysdate
5353: ,xla_environment_pkg.g_prog_appl_id
5354: ,xla_environment_pkg.g_prog_id
5347: ,sysdate
5348: ,xla_environment_pkg.g_usr_id
5349: ,sysdate
5350: ,xla_environment_pkg.g_usr_id
5351: ,xla_environment_pkg.g_login_id
5352: ,sysdate
5353: ,xla_environment_pkg.g_prog_appl_id
5354: ,xla_environment_pkg.g_prog_id
5355: ,xla_environment_pkg.g_req_Id
5349: ,sysdate
5350: ,xla_environment_pkg.g_usr_id
5351: ,xla_environment_pkg.g_login_id
5352: ,sysdate
5353: ,xla_environment_pkg.g_prog_appl_id
5354: ,xla_environment_pkg.g_prog_id
5355: ,xla_environment_pkg.g_req_Id
5356: ,reference_num_1
5357: ,reference_num_2
5350: ,xla_environment_pkg.g_usr_id
5351: ,xla_environment_pkg.g_login_id
5352: ,sysdate
5353: ,xla_environment_pkg.g_prog_appl_id
5354: ,xla_environment_pkg.g_prog_id
5355: ,xla_environment_pkg.g_req_Id
5356: ,reference_num_1
5357: ,reference_num_2
5358: ,reference_num_3
5351: ,xla_environment_pkg.g_login_id
5352: ,sysdate
5353: ,xla_environment_pkg.g_prog_appl_id
5354: ,xla_environment_pkg.g_prog_id
5355: ,xla_environment_pkg.g_req_Id
5356: ,reference_num_1
5357: ,reference_num_2
5358: ,reference_num_3
5359: ,reference_num_4
5429: ,TRUNC(event_date)
5430: ,nvl(transaction_date, TRUNC(event_date))
5431: ,nvl(xla_events_int_gt.budgetary_control_flag,'N')
5432: ,sysdate
5433: ,xla_environment_pkg.g_usr_id
5434: ,sysdate
5435: ,xla_environment_pkg.g_usr_id
5436: ,xla_environment_pkg.g_login_id
5437: ,sysdate
5431: ,nvl(xla_events_int_gt.budgetary_control_flag,'N')
5432: ,sysdate
5433: ,xla_environment_pkg.g_usr_id
5434: ,sysdate
5435: ,xla_environment_pkg.g_usr_id
5436: ,xla_environment_pkg.g_login_id
5437: ,sysdate
5438: ,xla_environment_pkg.g_prog_appl_id
5439: ,xla_environment_pkg.g_prog_id
5432: ,sysdate
5433: ,xla_environment_pkg.g_usr_id
5434: ,sysdate
5435: ,xla_environment_pkg.g_usr_id
5436: ,xla_environment_pkg.g_login_id
5437: ,sysdate
5438: ,xla_environment_pkg.g_prog_appl_id
5439: ,xla_environment_pkg.g_prog_id
5440: ,xla_environment_pkg.g_req_Id
5434: ,sysdate
5435: ,xla_environment_pkg.g_usr_id
5436: ,xla_environment_pkg.g_login_id
5437: ,sysdate
5438: ,xla_environment_pkg.g_prog_appl_id
5439: ,xla_environment_pkg.g_prog_id
5440: ,xla_environment_pkg.g_req_Id
5441: ,reference_num_1
5442: ,reference_num_2
5435: ,xla_environment_pkg.g_usr_id
5436: ,xla_environment_pkg.g_login_id
5437: ,sysdate
5438: ,xla_environment_pkg.g_prog_appl_id
5439: ,xla_environment_pkg.g_prog_id
5440: ,xla_environment_pkg.g_req_Id
5441: ,reference_num_1
5442: ,reference_num_2
5443: ,reference_num_3
5436: ,xla_environment_pkg.g_login_id
5437: ,sysdate
5438: ,xla_environment_pkg.g_prog_appl_id
5439: ,xla_environment_pkg.g_prog_id
5440: ,xla_environment_pkg.g_req_Id
5441: ,reference_num_1
5442: ,reference_num_2
5443: ,reference_num_3
5444: ,reference_num_4
8374: ,p_event_source_info.legal_entity_id
8375: ,p_event_source_info.entity_type_code
8376: ,p_event_source_info.transaction_number
8377: ,sysdate
8378: ,xla_environment_pkg.g_usr_id
8379: ,sysdate
8380: ,xla_environment_pkg.g_usr_id
8381: ,xla_environment_pkg.g_login_id
8382: ,p_valuation_method
8376: ,p_event_source_info.transaction_number
8377: ,sysdate
8378: ,xla_environment_pkg.g_usr_id
8379: ,sysdate
8380: ,xla_environment_pkg.g_usr_id
8381: ,xla_environment_pkg.g_login_id
8382: ,p_valuation_method
8383: ,xla_events_pub_pkg.g_security.security_id_int_1
8384: ,xla_events_pub_pkg.g_security.security_id_int_2
8377: ,sysdate
8378: ,xla_environment_pkg.g_usr_id
8379: ,sysdate
8380: ,xla_environment_pkg.g_usr_id
8381: ,xla_environment_pkg.g_login_id
8382: ,p_valuation_method
8383: ,xla_events_pub_pkg.g_security.security_id_int_1
8384: ,xla_events_pub_pkg.g_security.security_id_int_2
8385: ,xla_events_pub_pkg.g_security.security_id_int_3
8574: ,p_process_status_code
8575: ,TRUNC(p_event_date)
8576: ,p_budgetary_control_flag
8577: ,sysdate
8578: ,xla_environment_pkg.g_usr_id
8579: ,sysdate
8580: ,xla_environment_pkg.g_usr_id
8581: ,xla_environment_pkg.g_login_id
8582: ,sysdate
8576: ,p_budgetary_control_flag
8577: ,sysdate
8578: ,xla_environment_pkg.g_usr_id
8579: ,sysdate
8580: ,xla_environment_pkg.g_usr_id
8581: ,xla_environment_pkg.g_login_id
8582: ,sysdate
8583: ,xla_environment_pkg.g_prog_appl_id
8584: ,xla_environment_pkg.g_prog_id
8577: ,sysdate
8578: ,xla_environment_pkg.g_usr_id
8579: ,sysdate
8580: ,xla_environment_pkg.g_usr_id
8581: ,xla_environment_pkg.g_login_id
8582: ,sysdate
8583: ,xla_environment_pkg.g_prog_appl_id
8584: ,xla_environment_pkg.g_prog_id
8585: ,xla_environment_pkg.g_Req_Id
8579: ,sysdate
8580: ,xla_environment_pkg.g_usr_id
8581: ,xla_environment_pkg.g_login_id
8582: ,sysdate
8583: ,xla_environment_pkg.g_prog_appl_id
8584: ,xla_environment_pkg.g_prog_id
8585: ,xla_environment_pkg.g_Req_Id
8586: ,p_reference_info.reference_num_1
8587: ,p_reference_info.reference_num_2
8580: ,xla_environment_pkg.g_usr_id
8581: ,xla_environment_pkg.g_login_id
8582: ,sysdate
8583: ,xla_environment_pkg.g_prog_appl_id
8584: ,xla_environment_pkg.g_prog_id
8585: ,xla_environment_pkg.g_Req_Id
8586: ,p_reference_info.reference_num_1
8587: ,p_reference_info.reference_num_2
8588: ,p_reference_info.reference_num_3
8581: ,xla_environment_pkg.g_login_id
8582: ,sysdate
8583: ,xla_environment_pkg.g_prog_appl_id
8584: ,xla_environment_pkg.g_prog_id
8585: ,xla_environment_pkg.g_Req_Id
8586: ,p_reference_info.reference_num_1
8587: ,p_reference_info.reference_num_2
8588: ,p_reference_info.reference_num_3
8589: ,p_reference_info.reference_num_4