APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on FND_GLOBAL

Line 85: l_business_group_id := fnd_global.per_business_group_id;

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

Line 2558: ,request_id = fnd_global.conc_request_id

2554:
2555: debug(l_proc_name, 20);
2556: UPDATE pqp_ext_cross_person_records
2557: SET processing_status = 'U'
2558: ,request_id = fnd_global.conc_request_id
2559: ,last_updated_by = fnd_global.user_id
2560: ,last_update_date = SYSDATE
2561: ,last_update_login = fnd_global.login_id
2562: ,object_version_number = (object_version_number + 1)

Line 2559: ,last_updated_by = fnd_global.user_id

2555: debug(l_proc_name, 20);
2556: UPDATE pqp_ext_cross_person_records
2557: SET processing_status = 'U'
2558: ,request_id = fnd_global.conc_request_id
2559: ,last_updated_by = fnd_global.user_id
2560: ,last_update_date = SYSDATE
2561: ,last_update_login = fnd_global.login_id
2562: ,object_version_number = (object_version_number + 1)
2563: WHERE record_type = 'X'

Line 2561: ,last_update_login = fnd_global.login_id

2557: SET processing_status = 'U'
2558: ,request_id = fnd_global.conc_request_id
2559: ,last_updated_by = fnd_global.user_id
2560: ,last_update_date = SYSDATE
2561: ,last_update_login = fnd_global.login_id
2562: ,object_version_number = (object_version_number + 1)
2563: WHERE record_type = 'X'
2564: AND ext_dfn_id = ben_ext_thread.g_ext_dfn_id --ENH2
2565: AND lea_number = g_lea_number; --ENH1

Line 10873: ,last_updated_by = fnd_global.user_id

10869: ,effective_start_date = p_effective_start_date
10870: ,effective_end_date = p_effective_end_date
10871: ,processing_status = p_processing_status
10872: ,request_id = p_request_id
10873: ,last_updated_by = fnd_global.user_id
10874: ,last_update_date = SYSDATE
10875: ,last_update_login = fnd_global.login_id
10876: ,object_version_number = (l_multirec_per.object_version_number + 1)
10877: WHERE CURRENT OF csr_multirec_person;

Line 10875: ,last_update_login = fnd_global.login_id

10871: ,processing_status = p_processing_status
10872: ,request_id = p_request_id
10873: ,last_updated_by = fnd_global.user_id
10874: ,last_update_date = SYSDATE
10875: ,last_update_login = fnd_global.login_id
10876: ,object_version_number = (l_multirec_per.object_version_number + 1)
10877: WHERE CURRENT OF csr_multirec_person;
10878:
10879: l_report_person := TRUE;

Line 10936: ,fnd_global.user_id

10932: ,p_effective_start_date
10933: ,p_effective_end_date
10934: ,p_processing_status
10935: ,p_request_id
10936: ,fnd_global.user_id
10937: ,SYSDATE
10938: ,1
10939: );
10940:

Line 11078: ,p_request_id => fnd_global.conc_request_id

11074: ,p_national_identifier => l_per_details.national_identifier
11075: ,p_effective_start_date => p_effective_date
11076: ,p_effective_end_date => NULL
11077: ,p_processing_status => 'P'
11078: ,p_request_id => fnd_global.conc_request_id
11079: );
11080:
11081: END IF; -- l_person_has_multiple_recs THEN
11082:

Line 11131: ,p_request_id => fnd_global.conc_request_id

11127: ,p_national_identifier => l_per_details.national_identifier
11128: ,p_effective_start_date => p_effective_date
11129: ,p_effective_end_date => NULL
11130: ,p_processing_status => 'P'
11131: ,p_request_id => fnd_global.conc_request_id
11132: );
11133:
11134: ELSE
11135: -- Person is already being processed by another BG that

Line 11168: ,p_request_id => fnd_global.conc_request_id

11164: ,p_national_identifier => l_per_details.national_identifier
11165: ,p_effective_start_date => p_effective_date
11166: ,p_effective_end_date => NULL
11167: ,p_processing_status => 'P'
11168: ,p_request_id => fnd_global.conc_request_id
11169: );
11170:
11171: ELSE
11172: debug(l_proc_name, 105);