APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on BEN_EXT_PERSON

Line 1332: ,p_param3_value => to_char(nvl(ben_ext_person.g_person_id, -1))

1328: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
1329: ,p_param2 => 'EXT_RSLT_ID'
1330: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
1331: ,p_param3 => 'EXT_PERSON_ID'
1332: ,p_param3_value => to_char(nvl(ben_ext_person.g_person_id, -1))
1333: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
1334: ,p_param4_value => to_char(g_business_group_id)
1335: ,p_param5 => 'EXT_USER_VALUE'
1336: ,p_param5_value => i.String_Val

Line 2454: Ben_Ext_Person.g_person_id);

2450:
2451: -- Get the person id for the assignment and store it in a global
2452: -- variable
2453: g_person_id:= Nvl(get_current_extract_person(p_assignment_id),
2454: Ben_Ext_Person.g_person_id);
2455:
2456: --If person is not retro hired then g_retro_hires record is null
2457: Hr_Utility.set_location('c_start_date'||g_extract_params(bg_id).extract_start_date, 15);
2458: Hr_Utility.set_location('c_end_date'||g_extract_params(bg_id).extract_end_date, 15);

Line 7643: Nvl(Ben_Ext_Person.g_elmt_name

7639: l_ext_rslt_id:= get_current_extract_result;
7640: IF l_ext_rslt_id <> -1 THEN
7641: IF p_error_NUMBER IS NULL THEN
7642: l_error_text:= 'Warning raised in data element '||
7643: Nvl(Ben_Ext_Person.g_elmt_name
7644: ,Ben_Ext_Fmt.g_elmt_name)||'. '||
7645: p_error_text;
7646: ELSE
7647: Ben_Ext_Thread.g_err_num := p_error_NUMBER;

Line 7651: p_error_text,Nvl(Ben_Ext_Person.g_elmt_name,Ben_Ext_Fmt.g_elmt_name) );

7647: Ben_Ext_Thread.g_err_num := p_error_NUMBER;
7648: Ben_Ext_Thread.g_err_name := p_error_text;
7649: l_error_text :=
7650: Ben_Ext_Fmt.get_error_msg(To_Number(Substr(p_error_text, 5, 5)),
7651: p_error_text,Nvl(Ben_Ext_Person.g_elmt_name,Ben_Ext_Fmt.g_elmt_name) );
7652:
7653: END IF;
7654: l_person_id:= Nvl(get_current_extract_person(p_assignment_id)
7655: ,Ben_Ext_Person.g_person_id);

Line 7655: ,Ben_Ext_Person.g_person_id);

7651: p_error_text,Nvl(Ben_Ext_Person.g_elmt_name,Ben_Ext_Fmt.g_elmt_name) );
7652:
7653: END IF;
7654: l_person_id:= Nvl(get_current_extract_person(p_assignment_id)
7655: ,Ben_Ext_Person.g_person_id);
7656:
7657: IF l_person_id IS NOT NULL THEN
7658: --
7659: Ben_Ext_Util.write_err