DBA Data[Home] [Help]

APPS.PQP_NL_PENSION_EXTRACTS dependencies on BEN_EXT_PERSON

Line 6034: Ben_Ext_Person.g_person_id);

6030:
6031: -- Get the person id for the assignment and store it in a global
6032: -- variable
6033: g_person_id:= Nvl(get_current_extract_person(p_assignment_id),
6034: Ben_Ext_Person.g_person_id);
6035:
6036: -- Derive the effective date
6037: l_effective_date := Least(g_extract_params(i).extract_end_date,
6038: p_effective_date);

Line 6380: Nvl(Ben_Ext_Person.g_elmt_name

6376: l_ext_rslt_id:= get_current_extract_result;
6377: IF l_ext_rslt_id <> -1 THEN
6378: IF p_error_NUMBER IS NULL THEN
6379: l_error_text:= 'Warning raised in data element '||
6380: Nvl(Ben_Ext_Person.g_elmt_name
6381: ,Ben_Ext_Fmt.g_elmt_name)||'. '||
6382: p_error_text;
6383: ELSE
6384: Ben_Ext_Thread.g_err_num := p_error_NUMBER;

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

6384: Ben_Ext_Thread.g_err_num := p_error_NUMBER;
6385: Ben_Ext_Thread.g_err_name := p_error_text;
6386: l_error_text :=
6387: Ben_Ext_Fmt.get_error_msg(To_Number(Substr(p_error_text, 5, 5)),
6388: p_error_text,Nvl(Ben_Ext_Person.g_elmt_name,Ben_Ext_Fmt.g_elmt_name) );
6389:
6390: END IF;
6391: l_person_id:= Nvl(get_current_extract_person(p_assignment_id)
6392: ,Ben_Ext_Person.g_person_id);

Line 6392: ,Ben_Ext_Person.g_person_id);

6388: p_error_text,Nvl(Ben_Ext_Person.g_elmt_name,Ben_Ext_Fmt.g_elmt_name) );
6389:
6390: END IF;
6391: l_person_id:= Nvl(get_current_extract_person(p_assignment_id)
6392: ,Ben_Ext_Person.g_person_id);
6393:
6394: IF l_person_id IS NOT NULL THEN
6395: --
6396: Ben_Ext_Util.write_err