DBA Data[Home] [Help]

APPS.XLA_EVENTS_PKG dependencies on XLA_ENVIRONMENT_PKG

Line 1418: ,last_updated_by = xla_environment_pkg.g_usr_id

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

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

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

Line 1422: ,program_id = xla_environment_pkg.g_prog_id

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:

Line 1423: ,request_id = xla_environment_pkg.g_Req_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:
1427: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1900: ,last_updated_by = xla_environment_pkg.g_usr_id

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

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

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

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

Line 1905: ,request_id = xla_environment_pkg.g_Req_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;
1909:

Line 2357: ,last_updated_by = xla_environment_pkg.g_usr_id

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

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

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

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

Line 2362: ,request_id = xla_environment_pkg.g_Req_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;
2366:

Line 5180: , xla_environment_pkg.g_usr_id

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

Line 5182: , xla_environment_pkg.g_usr_id

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

Line 5183: , xla_environment_pkg.g_login_id

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

Line 5348: ,xla_environment_pkg.g_usr_id

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

Line 5350: ,xla_environment_pkg.g_usr_id

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

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

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

Line 5354: ,xla_environment_pkg.g_prog_id

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

Line 5355: ,xla_environment_pkg.g_req_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
5359: ,reference_num_4

Line 5433: ,xla_environment_pkg.g_usr_id

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

Line 5435: ,xla_environment_pkg.g_usr_id

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

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

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

Line 5439: ,xla_environment_pkg.g_prog_id

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

Line 5440: ,xla_environment_pkg.g_req_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
5444: ,reference_num_4

Line 8378: ,xla_environment_pkg.g_usr_id

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

Line 8380: ,xla_environment_pkg.g_usr_id

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

Line 8381: ,xla_environment_pkg.g_login_id

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

Line 8578: ,xla_environment_pkg.g_usr_id

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

Line 8580: ,xla_environment_pkg.g_usr_id

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

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

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

Line 8584: ,xla_environment_pkg.g_prog_id

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

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