APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on FND_GLOBAL

Line 84: l_business_group_id := fnd_global.per_business_group_id;

80: OPEN pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
81: FETCH pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes INTO l_extract_attributes;
82: CLOSE pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
83:
84: l_business_group_id := fnd_global.per_business_group_id;
85:
86: BEGIN
87: g_trace := hruserdt.get_table_value
88: (p_bus_group_id => l_business_group_id

Line 2586: ,request_id = fnd_global.conc_request_id

2582:
2583: debug(l_proc_name, 20);
2584: UPDATE pqp_ext_cross_person_records
2585: SET processing_status = 'U'
2586: ,request_id = fnd_global.conc_request_id
2587: ,last_updated_by = fnd_global.user_id
2588: ,last_update_date = SYSDATE
2589: ,last_update_login = fnd_global.login_id
2590: ,object_version_number = (object_version_number + 1)

Line 2587: ,last_updated_by = fnd_global.user_id

2583: debug(l_proc_name, 20);
2584: UPDATE pqp_ext_cross_person_records
2585: SET processing_status = 'U'
2586: ,request_id = fnd_global.conc_request_id
2587: ,last_updated_by = fnd_global.user_id
2588: ,last_update_date = SYSDATE
2589: ,last_update_login = fnd_global.login_id
2590: ,object_version_number = (object_version_number + 1)
2591: WHERE record_type = 'X'

Line 2589: ,last_update_login = fnd_global.login_id

2585: SET processing_status = 'U'
2586: ,request_id = fnd_global.conc_request_id
2587: ,last_updated_by = fnd_global.user_id
2588: ,last_update_date = SYSDATE
2589: ,last_update_login = fnd_global.login_id
2590: ,object_version_number = (object_version_number + 1)
2591: WHERE record_type = 'X'
2592: AND ext_dfn_id = ben_ext_thread.g_ext_dfn_id --ENH2
2593: AND lea_number = g_lea_number; --ENH1

Line 11070: ,last_updated_by = fnd_global.user_id

11066: ,effective_start_date = p_effective_start_date
11067: ,effective_end_date = p_effective_end_date
11068: ,processing_status = p_processing_status
11069: ,request_id = p_request_id
11070: ,last_updated_by = fnd_global.user_id
11071: ,last_update_date = SYSDATE
11072: ,last_update_login = fnd_global.login_id
11073: ,object_version_number = (l_multirec_per.object_version_number + 1)
11074: WHERE CURRENT OF csr_multirec_person;

Line 11072: ,last_update_login = fnd_global.login_id

11068: ,processing_status = p_processing_status
11069: ,request_id = p_request_id
11070: ,last_updated_by = fnd_global.user_id
11071: ,last_update_date = SYSDATE
11072: ,last_update_login = fnd_global.login_id
11073: ,object_version_number = (l_multirec_per.object_version_number + 1)
11074: WHERE CURRENT OF csr_multirec_person;
11075:
11076: l_report_person := TRUE;

Line 11133: ,fnd_global.user_id

11129: ,p_effective_start_date
11130: ,p_effective_end_date
11131: ,p_processing_status
11132: ,p_request_id
11133: ,fnd_global.user_id
11134: ,SYSDATE
11135: ,1
11136: );
11137:

Line 11275: ,p_request_id => fnd_global.conc_request_id

11271: ,p_national_identifier => l_per_details.national_identifier
11272: ,p_effective_start_date => p_effective_date
11273: ,p_effective_end_date => NULL
11274: ,p_processing_status => 'P'
11275: ,p_request_id => fnd_global.conc_request_id
11276: );
11277:
11278: END IF; -- l_person_has_multiple_recs THEN
11279:

Line 11328: ,p_request_id => fnd_global.conc_request_id

11324: ,p_national_identifier => l_per_details.national_identifier
11325: ,p_effective_start_date => p_effective_date
11326: ,p_effective_end_date => NULL
11327: ,p_processing_status => 'P'
11328: ,p_request_id => fnd_global.conc_request_id
11329: );
11330:
11331: ELSE
11332: -- Person is already being processed by another BG that

Line 11365: ,p_request_id => fnd_global.conc_request_id

11361: ,p_national_identifier => l_per_details.national_identifier
11362: ,p_effective_start_date => p_effective_date
11363: ,p_effective_end_date => NULL
11364: ,p_processing_status => 'P'
11365: ,p_request_id => fnd_global.conc_request_id
11366: );
11367:
11368: ELSE
11369: debug(l_proc_name, 105);