DBA Data[Home] [Help]

APPS.XLA_EVENTS_PKG dependencies on XLA_ENVIRONMENT_PKG

Line 1440: ,last_updated_by = xla_environment_pkg.g_usr_id

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

Line 1441: ,last_update_login = xla_environment_pkg.g_login_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

Line 1443: ,program_application_id = xla_environment_pkg.g_prog_appl_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

Line 1444: ,program_id = xla_environment_pkg.g_prog_id

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

Line 1445: ,request_id = xla_environment_pkg.g_Req_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: ;
1449: if(g_gapless_flag='Y') then

Line 1931: ,last_updated_by = xla_environment_pkg.g_usr_id

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

Line 1932: ,last_update_login = xla_environment_pkg.g_login_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

Line 1934: ,program_application_id= xla_environment_pkg.g_prog_appl_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

Line 1935: ,program_id = xla_environment_pkg.g_prog_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

Line 1936: ,request_id = xla_environment_pkg.g_Req_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
1940: AND application_id = g_application_id -- 8967771

Line 2406: ,last_updated_by = xla_environment_pkg.g_usr_id

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

Line 2407: ,last_update_login = xla_environment_pkg.g_login_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

Line 2409: ,program_application_id= xla_environment_pkg.g_prog_appl_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

Line 2410: ,program_id = xla_environment_pkg.g_prog_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

Line 2411: ,request_id = xla_environment_pkg.g_Req_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
2415: AND application_id = g_application_id -- 8967771

Line 5642: , xla_environment_pkg.g_usr_id

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

Line 5644: , xla_environment_pkg.g_usr_id

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

Line 5645: , xla_environment_pkg.g_login_id

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

Line 5810: ,xla_environment_pkg.g_usr_id

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

Line 5812: ,xla_environment_pkg.g_usr_id

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

Line 5813: ,xla_environment_pkg.g_login_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

Line 5815: ,xla_environment_pkg.g_prog_appl_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

Line 5816: ,xla_environment_pkg.g_prog_id

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

Line 5817: ,xla_environment_pkg.g_req_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
5821: ,reference_num_4

Line 5895: ,xla_environment_pkg.g_usr_id

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

Line 5897: ,xla_environment_pkg.g_usr_id

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

Line 5898: ,xla_environment_pkg.g_login_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

Line 5900: ,xla_environment_pkg.g_prog_appl_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

Line 5901: ,xla_environment_pkg.g_prog_id

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

Line 5902: ,xla_environment_pkg.g_req_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
5906: ,reference_num_4

Line 9107: ,xla_environment_pkg.g_usr_id

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

Line 9109: ,xla_environment_pkg.g_usr_id

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

Line 9110: ,xla_environment_pkg.g_login_id

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

Line 9309: ,xla_environment_pkg.g_usr_id

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

Line 9311: ,xla_environment_pkg.g_usr_id

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

Line 9312: ,xla_environment_pkg.g_login_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

Line 9314: ,xla_environment_pkg.g_prog_appl_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

Line 9315: ,xla_environment_pkg.g_prog_id

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

Line 9316: ,xla_environment_pkg.g_Req_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
9320: ,p_reference_info.reference_num_4