DBA Data[Home] [Help]

APPS.PQP_US_PENSION_EXTRACTS dependencies on BEN_EXT_PERSON

Line 5121: Ben_Ext_Person.g_person_id);

5117: -- Check if for this assignment id there are assign. action(s) which have
5118: -- processed the element(s). If any then return return Y i.e. assign needs
5119: -- to be extracted.
5120: g_person_id:= Nvl(get_current_extract_person(p_assignment_id),
5121: Ben_Ext_Person.g_person_id);
5122: l_effective_date := Least(g_extract_params(i).extract_end_date,
5123: p_effective_date);
5124: Hr_Utility.set_location('..Processing Assig Id : '||p_assignment_id, 17);
5125: Hr_Utility.set_location('..Processing Person Id : '||g_person_id, 17);

Line 5387: Nvl(Ben_Ext_Person.g_elmt_name

5383: l_ext_rslt_id:= get_current_extract_result;
5384: IF l_ext_rslt_id <> -1 THEN
5385: IF p_error_NUMBER IS NULL THEN
5386: l_error_text:= 'Warning raised in data element '||
5387: Nvl(Ben_Ext_Person.g_elmt_name
5388: ,Ben_Ext_Fmt.g_elmt_name)||'. '||
5389: p_error_text;
5390: ELSE
5391: Ben_Ext_Thread.g_err_num := p_error_NUMBER;

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

5391: Ben_Ext_Thread.g_err_num := p_error_NUMBER;
5392: Ben_Ext_Thread.g_err_name := p_error_text;
5393: l_error_text :=
5394: Ben_Ext_Fmt.get_error_msg(To_Number(Substr(p_error_text, 5, 5)),
5395: p_error_text,Nvl(Ben_Ext_Person.g_elmt_name,Ben_Ext_Fmt.g_elmt_name) );
5396:
5397: END IF;
5398: l_person_id:= Nvl(get_current_extract_person(p_assignment_id)
5399: ,Ben_Ext_Person.g_person_id);

Line 5399: ,Ben_Ext_Person.g_person_id);

5395: p_error_text,Nvl(Ben_Ext_Person.g_elmt_name,Ben_Ext_Fmt.g_elmt_name) );
5396:
5397: END IF;
5398: l_person_id:= Nvl(get_current_extract_person(p_assignment_id)
5399: ,Ben_Ext_Person.g_person_id);
5400:
5401: IF l_person_id IS NOT NULL THEN
5402: --
5403: Ben_Ext_Util.write_err