1436: UPDATE xla_events
1437: SET event_status_code = p_event_status_code
1438: ,process_status_code = C_INTERNAL_UNPROCESSED
1439: ,last_update_date = sysdate
1440: ,last_updated_by = xla_environment_pkg.g_usr_id
1441: ,last_update_login = xla_environment_pkg.g_login_id
1442: ,program_update_date = sysdate
1443: ,program_application_id = xla_environment_pkg.g_prog_appl_id
1444: ,program_id = xla_environment_pkg.g_prog_id
1437: SET event_status_code = p_event_status_code
1438: ,process_status_code = C_INTERNAL_UNPROCESSED
1439: ,last_update_date = sysdate
1440: ,last_updated_by = xla_environment_pkg.g_usr_id
1441: ,last_update_login = xla_environment_pkg.g_login_id
1442: ,program_update_date = sysdate
1443: ,program_application_id = xla_environment_pkg.g_prog_appl_id
1444: ,program_id = xla_environment_pkg.g_prog_id
1445: ,request_id = xla_environment_pkg.g_Req_Id
1439: ,last_update_date = sysdate
1440: ,last_updated_by = xla_environment_pkg.g_usr_id
1441: ,last_update_login = xla_environment_pkg.g_login_id
1442: ,program_update_date = sysdate
1443: ,program_application_id = xla_environment_pkg.g_prog_appl_id
1444: ,program_id = xla_environment_pkg.g_prog_id
1445: ,request_id = xla_environment_pkg.g_Req_Id
1446: WHERE event_id = l_array_events(i)
1447: AND application_id = g_application_id -- 8967771
1440: ,last_updated_by = xla_environment_pkg.g_usr_id
1441: ,last_update_login = xla_environment_pkg.g_login_id
1442: ,program_update_date = sysdate
1443: ,program_application_id = xla_environment_pkg.g_prog_appl_id
1444: ,program_id = xla_environment_pkg.g_prog_id
1445: ,request_id = xla_environment_pkg.g_Req_Id
1446: WHERE event_id = l_array_events(i)
1447: AND application_id = g_application_id -- 8967771
1448: ;
1441: ,last_update_login = xla_environment_pkg.g_login_id
1442: ,program_update_date = sysdate
1443: ,program_application_id = xla_environment_pkg.g_prog_appl_id
1444: ,program_id = xla_environment_pkg.g_prog_id
1445: ,request_id = xla_environment_pkg.g_Req_Id
1446: WHERE event_id = l_array_events(i)
1447: AND application_id = g_application_id -- 8967771
1448: ;
1449: if(g_gapless_flag='Y') then
1927: p_reference_info.reference_date_3,reference_date_3)
1928: ,reference_date_4 = DECODE(p_overwrite_ref_info,C_YES,
1929: p_reference_info.reference_date_4,reference_date_4)
1930: ,last_update_date = sysdate
1931: ,last_updated_by = xla_environment_pkg.g_usr_id
1932: ,last_update_login = xla_environment_pkg.g_login_id
1933: ,program_update_date = sysdate
1934: ,program_application_id= xla_environment_pkg.g_prog_appl_id
1935: ,program_id = xla_environment_pkg.g_prog_id
1928: ,reference_date_4 = DECODE(p_overwrite_ref_info,C_YES,
1929: p_reference_info.reference_date_4,reference_date_4)
1930: ,last_update_date = sysdate
1931: ,last_updated_by = xla_environment_pkg.g_usr_id
1932: ,last_update_login = xla_environment_pkg.g_login_id
1933: ,program_update_date = sysdate
1934: ,program_application_id= xla_environment_pkg.g_prog_appl_id
1935: ,program_id = xla_environment_pkg.g_prog_id
1936: ,request_id = xla_environment_pkg.g_Req_Id
1930: ,last_update_date = sysdate
1931: ,last_updated_by = xla_environment_pkg.g_usr_id
1932: ,last_update_login = xla_environment_pkg.g_login_id
1933: ,program_update_date = sysdate
1934: ,program_application_id= xla_environment_pkg.g_prog_appl_id
1935: ,program_id = xla_environment_pkg.g_prog_id
1936: ,request_id = xla_environment_pkg.g_Req_Id
1937: WHERE event_id = p_event_id
1938: AND entity_id = g_entity_id
1931: ,last_updated_by = xla_environment_pkg.g_usr_id
1932: ,last_update_login = xla_environment_pkg.g_login_id
1933: ,program_update_date = sysdate
1934: ,program_application_id= xla_environment_pkg.g_prog_appl_id
1935: ,program_id = xla_environment_pkg.g_prog_id
1936: ,request_id = xla_environment_pkg.g_Req_Id
1937: WHERE event_id = p_event_id
1938: AND entity_id = g_entity_id
1939: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED
1932: ,last_update_login = xla_environment_pkg.g_login_id
1933: ,program_update_date = sysdate
1934: ,program_application_id= xla_environment_pkg.g_prog_appl_id
1935: ,program_id = xla_environment_pkg.g_prog_id
1936: ,request_id = xla_environment_pkg.g_Req_Id
1937: WHERE event_id = p_event_id
1938: AND entity_id = g_entity_id
1939: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED
1940: AND application_id = g_application_id -- 8967771
2402: p_reference_info.reference_date_3,reference_date_3)
2403: ,reference_date_4 = DECODE(p_overwrite_ref_info,C_YES,
2404: p_reference_info.reference_date_4,reference_date_4)
2405: ,last_update_date = sysdate
2406: ,last_updated_by = xla_environment_pkg.g_usr_id
2407: ,last_update_login = xla_environment_pkg.g_login_id
2408: ,program_update_date = sysdate
2409: ,program_application_id= xla_environment_pkg.g_prog_appl_id
2410: ,program_id = xla_environment_pkg.g_prog_id
2403: ,reference_date_4 = DECODE(p_overwrite_ref_info,C_YES,
2404: p_reference_info.reference_date_4,reference_date_4)
2405: ,last_update_date = sysdate
2406: ,last_updated_by = xla_environment_pkg.g_usr_id
2407: ,last_update_login = xla_environment_pkg.g_login_id
2408: ,program_update_date = sysdate
2409: ,program_application_id= xla_environment_pkg.g_prog_appl_id
2410: ,program_id = xla_environment_pkg.g_prog_id
2411: ,request_id = xla_environment_pkg.g_Req_Id
2405: ,last_update_date = sysdate
2406: ,last_updated_by = xla_environment_pkg.g_usr_id
2407: ,last_update_login = xla_environment_pkg.g_login_id
2408: ,program_update_date = sysdate
2409: ,program_application_id= xla_environment_pkg.g_prog_appl_id
2410: ,program_id = xla_environment_pkg.g_prog_id
2411: ,request_id = xla_environment_pkg.g_Req_Id
2412: WHERE event_id = p_event_id
2413: AND entity_id = g_entity_id
2406: ,last_updated_by = xla_environment_pkg.g_usr_id
2407: ,last_update_login = xla_environment_pkg.g_login_id
2408: ,program_update_date = sysdate
2409: ,program_application_id= xla_environment_pkg.g_prog_appl_id
2410: ,program_id = xla_environment_pkg.g_prog_id
2411: ,request_id = xla_environment_pkg.g_Req_Id
2412: WHERE event_id = p_event_id
2413: AND entity_id = g_entity_id
2414: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED
2407: ,last_update_login = xla_environment_pkg.g_login_id
2408: ,program_update_date = sysdate
2409: ,program_application_id= xla_environment_pkg.g_prog_appl_id
2410: ,program_id = xla_environment_pkg.g_prog_id
2411: ,request_id = xla_environment_pkg.g_Req_Id
2412: WHERE event_id = p_event_id
2413: AND entity_id = g_entity_id
2414: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED
2415: AND application_id = g_application_id -- 8967771
5638: , xe.legal_entity_id /* Bug 4458604*/
5639: , p_entity_type_code
5640: , xe.transaction_number
5641: , sysdate
5642: , xla_environment_pkg.g_usr_id
5643: , sysdate
5644: , xla_environment_pkg.g_usr_id
5645: , xla_environment_pkg.g_login_id
5646: , xe.valuation_method
5640: , xe.transaction_number
5641: , sysdate
5642: , xla_environment_pkg.g_usr_id
5643: , sysdate
5644: , xla_environment_pkg.g_usr_id
5645: , xla_environment_pkg.g_login_id
5646: , xe.valuation_method
5647: , xe.security_id_int_1
5648: , xe.security_id_int_2
5641: , sysdate
5642: , xla_environment_pkg.g_usr_id
5643: , sysdate
5644: , xla_environment_pkg.g_usr_id
5645: , xla_environment_pkg.g_login_id
5646: , xe.valuation_method
5647: , xe.security_id_int_1
5648: , xe.security_id_int_2
5649: , xe.security_id_int_3
5806: ,TRUNC(event_date)
5807: ,nvl(transaction_date, TRUNC(event_date))
5808: ,nvl(xla_events_int_gt.budgetary_control_flag,'N')
5809: ,sysdate
5810: ,xla_environment_pkg.g_usr_id
5811: ,sysdate
5812: ,xla_environment_pkg.g_usr_id
5813: ,xla_environment_pkg.g_login_id
5814: ,sysdate
5808: ,nvl(xla_events_int_gt.budgetary_control_flag,'N')
5809: ,sysdate
5810: ,xla_environment_pkg.g_usr_id
5811: ,sysdate
5812: ,xla_environment_pkg.g_usr_id
5813: ,xla_environment_pkg.g_login_id
5814: ,sysdate
5815: ,xla_environment_pkg.g_prog_appl_id
5816: ,xla_environment_pkg.g_prog_id
5809: ,sysdate
5810: ,xla_environment_pkg.g_usr_id
5811: ,sysdate
5812: ,xla_environment_pkg.g_usr_id
5813: ,xla_environment_pkg.g_login_id
5814: ,sysdate
5815: ,xla_environment_pkg.g_prog_appl_id
5816: ,xla_environment_pkg.g_prog_id
5817: ,xla_environment_pkg.g_req_Id
5811: ,sysdate
5812: ,xla_environment_pkg.g_usr_id
5813: ,xla_environment_pkg.g_login_id
5814: ,sysdate
5815: ,xla_environment_pkg.g_prog_appl_id
5816: ,xla_environment_pkg.g_prog_id
5817: ,xla_environment_pkg.g_req_Id
5818: ,reference_num_1
5819: ,reference_num_2
5812: ,xla_environment_pkg.g_usr_id
5813: ,xla_environment_pkg.g_login_id
5814: ,sysdate
5815: ,xla_environment_pkg.g_prog_appl_id
5816: ,xla_environment_pkg.g_prog_id
5817: ,xla_environment_pkg.g_req_Id
5818: ,reference_num_1
5819: ,reference_num_2
5820: ,reference_num_3
5813: ,xla_environment_pkg.g_login_id
5814: ,sysdate
5815: ,xla_environment_pkg.g_prog_appl_id
5816: ,xla_environment_pkg.g_prog_id
5817: ,xla_environment_pkg.g_req_Id
5818: ,reference_num_1
5819: ,reference_num_2
5820: ,reference_num_3
5821: ,reference_num_4
5891: ,TRUNC(event_date)
5892: ,nvl(transaction_date, TRUNC(event_date))
5893: ,nvl(xla_events_int_gt.budgetary_control_flag,'N')
5894: ,sysdate
5895: ,xla_environment_pkg.g_usr_id
5896: ,sysdate
5897: ,xla_environment_pkg.g_usr_id
5898: ,xla_environment_pkg.g_login_id
5899: ,sysdate
5893: ,nvl(xla_events_int_gt.budgetary_control_flag,'N')
5894: ,sysdate
5895: ,xla_environment_pkg.g_usr_id
5896: ,sysdate
5897: ,xla_environment_pkg.g_usr_id
5898: ,xla_environment_pkg.g_login_id
5899: ,sysdate
5900: ,xla_environment_pkg.g_prog_appl_id
5901: ,xla_environment_pkg.g_prog_id
5894: ,sysdate
5895: ,xla_environment_pkg.g_usr_id
5896: ,sysdate
5897: ,xla_environment_pkg.g_usr_id
5898: ,xla_environment_pkg.g_login_id
5899: ,sysdate
5900: ,xla_environment_pkg.g_prog_appl_id
5901: ,xla_environment_pkg.g_prog_id
5902: ,xla_environment_pkg.g_req_Id
5896: ,sysdate
5897: ,xla_environment_pkg.g_usr_id
5898: ,xla_environment_pkg.g_login_id
5899: ,sysdate
5900: ,xla_environment_pkg.g_prog_appl_id
5901: ,xla_environment_pkg.g_prog_id
5902: ,xla_environment_pkg.g_req_Id
5903: ,reference_num_1
5904: ,reference_num_2
5897: ,xla_environment_pkg.g_usr_id
5898: ,xla_environment_pkg.g_login_id
5899: ,sysdate
5900: ,xla_environment_pkg.g_prog_appl_id
5901: ,xla_environment_pkg.g_prog_id
5902: ,xla_environment_pkg.g_req_Id
5903: ,reference_num_1
5904: ,reference_num_2
5905: ,reference_num_3
5898: ,xla_environment_pkg.g_login_id
5899: ,sysdate
5900: ,xla_environment_pkg.g_prog_appl_id
5901: ,xla_environment_pkg.g_prog_id
5902: ,xla_environment_pkg.g_req_Id
5903: ,reference_num_1
5904: ,reference_num_2
5905: ,reference_num_3
5906: ,reference_num_4
9103: ,p_event_source_info.legal_entity_id
9104: ,p_event_source_info.entity_type_code
9105: ,p_event_source_info.transaction_number
9106: ,sysdate
9107: ,xla_environment_pkg.g_usr_id
9108: ,sysdate
9109: ,xla_environment_pkg.g_usr_id
9110: ,xla_environment_pkg.g_login_id
9111: ,p_valuation_method
9105: ,p_event_source_info.transaction_number
9106: ,sysdate
9107: ,xla_environment_pkg.g_usr_id
9108: ,sysdate
9109: ,xla_environment_pkg.g_usr_id
9110: ,xla_environment_pkg.g_login_id
9111: ,p_valuation_method
9112: ,xla_events_pub_pkg.g_security.security_id_int_1
9113: ,xla_events_pub_pkg.g_security.security_id_int_2
9106: ,sysdate
9107: ,xla_environment_pkg.g_usr_id
9108: ,sysdate
9109: ,xla_environment_pkg.g_usr_id
9110: ,xla_environment_pkg.g_login_id
9111: ,p_valuation_method
9112: ,xla_events_pub_pkg.g_security.security_id_int_1
9113: ,xla_events_pub_pkg.g_security.security_id_int_2
9114: ,xla_events_pub_pkg.g_security.security_id_int_3
9305: ,p_process_status_code
9306: ,TRUNC(p_event_date)
9307: ,p_budgetary_control_flag
9308: ,sysdate
9309: ,xla_environment_pkg.g_usr_id
9310: ,sysdate
9311: ,xla_environment_pkg.g_usr_id
9312: ,xla_environment_pkg.g_login_id
9313: ,sysdate
9307: ,p_budgetary_control_flag
9308: ,sysdate
9309: ,xla_environment_pkg.g_usr_id
9310: ,sysdate
9311: ,xla_environment_pkg.g_usr_id
9312: ,xla_environment_pkg.g_login_id
9313: ,sysdate
9314: ,xla_environment_pkg.g_prog_appl_id
9315: ,xla_environment_pkg.g_prog_id
9308: ,sysdate
9309: ,xla_environment_pkg.g_usr_id
9310: ,sysdate
9311: ,xla_environment_pkg.g_usr_id
9312: ,xla_environment_pkg.g_login_id
9313: ,sysdate
9314: ,xla_environment_pkg.g_prog_appl_id
9315: ,xla_environment_pkg.g_prog_id
9316: ,xla_environment_pkg.g_Req_Id
9310: ,sysdate
9311: ,xla_environment_pkg.g_usr_id
9312: ,xla_environment_pkg.g_login_id
9313: ,sysdate
9314: ,xla_environment_pkg.g_prog_appl_id
9315: ,xla_environment_pkg.g_prog_id
9316: ,xla_environment_pkg.g_Req_Id
9317: ,p_reference_info.reference_num_1
9318: ,p_reference_info.reference_num_2
9311: ,xla_environment_pkg.g_usr_id
9312: ,xla_environment_pkg.g_login_id
9313: ,sysdate
9314: ,xla_environment_pkg.g_prog_appl_id
9315: ,xla_environment_pkg.g_prog_id
9316: ,xla_environment_pkg.g_Req_Id
9317: ,p_reference_info.reference_num_1
9318: ,p_reference_info.reference_num_2
9319: ,p_reference_info.reference_num_3
9312: ,xla_environment_pkg.g_login_id
9313: ,sysdate
9314: ,xla_environment_pkg.g_prog_appl_id
9315: ,xla_environment_pkg.g_prog_id
9316: ,xla_environment_pkg.g_Req_Id
9317: ,p_reference_info.reference_num_1
9318: ,p_reference_info.reference_num_2
9319: ,p_reference_info.reference_num_3
9320: ,p_reference_info.reference_num_4