eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_PENSION_EXTRACTS dependencies on BEN_EXT_RSLT_DTL

Line 279: FROM ben_ext_rslt_dtl dtl

275: CURSOR csr_rslt_dtl(c_person_id IN NUMBER
276: ,c_ext_rslt_id IN NUMBER
277: ,c_ext_dtl_rcd_id IN NUMBER ) IS
278: SELECT *
279: FROM ben_ext_rslt_dtl dtl
280: WHERE dtl.ext_rslt_id = c_ext_rslt_id
281: AND dtl.person_id = c_person_id
282: AND dtl.ext_rcd_id = c_ext_dtl_rcd_id;
283: -- =============================================================================

Line 859: ,p_data_element_value IN ben_ext_rslt_dtl.val_01%TYPE

855: -- ================================================================================
856: PROCEDURE Update_Record_Values
857: (p_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
858: ,p_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
859: ,p_data_element_value IN ben_ext_rslt_dtl.val_01%TYPE
860: ,p_data_ele_seqnum IN NUMBER
861: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
862: ) IS
863:

Line 861: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE

857: (p_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
858: ,p_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
859: ,p_data_element_value IN ben_ext_rslt_dtl.val_01%TYPE
860: ,p_data_ele_seqnum IN NUMBER
861: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
862: ) IS
863:
864: CURSOR csr_seqnum
865: (c_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE

Line 880: l_ext_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;

876: ORDER BY seq_num;
877:
878: l_seqnum_rec csr_seqnum%ROWTYPE;
879: l_proc_name VARCHAR2(150):= g_proc_name||'Update_Record_Values';
880: l_ext_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;
881:
882: BEGIN
883: hr_utility.set_location('Entering :'||l_proc_name, 5);
884: l_ext_dtl_rec_nc := p_ext_dtl_rec;

Line 1067: (p_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE

1063: -- =============================================================================
1064: -- ~ Ins_Rslt_Dtl : Inserts a record into the results detail record.
1065: -- =============================================================================
1066: PROCEDURE Ins_Rslt_Dtl
1067: (p_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
1068: ,p_val_tab IN ValTabTyp
1069: ,p_rslt_dtl_id OUT NOCOPY NUMBER
1070: ) IS
1071:

Line 1073: l_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;

1069: ,p_rslt_dtl_id OUT NOCOPY NUMBER
1070: ) IS
1071:
1072: l_proc_name VARCHAR2(150) := g_proc_name||'Ins_Rslt_Dtl';
1073: l_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;
1074:
1075: BEGIN
1076: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
1077: l_dtl_rec_nc := p_dtl_rec;

Line 1080: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;

1076: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
1077: l_dtl_rec_nc := p_dtl_rec;
1078:
1079: -- Get the next sequence NUMBER to insert a record into the table
1080: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
1081: INSERT INTO ben_ext_rslt_dtl
1082: (ext_rslt_dtl_id
1083: ,ext_rslt_id
1084: ,business_group_id

Line 1081: INSERT INTO ben_ext_rslt_dtl

1077: l_dtl_rec_nc := p_dtl_rec;
1078:
1079: -- Get the next sequence NUMBER to insert a record into the table
1080: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
1081: INSERT INTO ben_ext_rslt_dtl
1082: (ext_rslt_dtl_id
1083: ,ext_rslt_id
1084: ,business_group_id
1085: ,ext_rcd_id

Line 1289: (p_dtl_rec IN ben_ext_rslt_dtl%ROWTYPE

1285: -- =============================================================================
1286: -- ~Upd_Rslt_Dtl : Updates the primary assignment record in results detail table
1287: -- =============================================================================
1288: PROCEDURE Upd_Rslt_Dtl
1289: (p_dtl_rec IN ben_ext_rslt_dtl%ROWTYPE
1290: ,p_val_tab IN ValTabTyp ) IS
1291:
1292: l_proc_name VARCHAR2(150):= g_proc_name||'upd_rslt_dtl';
1293:

Line 1295: UPDATE ben_ext_rslt_dtl

1291:
1292: l_proc_name VARCHAR2(150):= g_proc_name||'upd_rslt_dtl';
1293:
1294: BEGIN
1295: UPDATE ben_ext_rslt_dtl
1296: set val_01 = p_val_tab(1)
1297: ,val_02 = p_val_tab(2)
1298: ,val_03 = p_val_tab(3)
1299: ,val_04 = p_val_tab(4)

Line 1826: (p_rslt_rec IN ben_ext_rslt_dtl%ROWTYPE

1822: -- =============================================================================
1823: -- Copy_Rec_Values :
1824: -- =============================================================================
1825: PROCEDURE Copy_Rec_Values
1826: (p_rslt_rec IN ben_ext_rslt_dtl%ROWTYPE
1827: ,p_val_tab IN OUT NOCOPY ValTabTyp) IS
1828:
1829: l_proc_name VARCHAR2(150) := g_proc_name ||'Copy_Rec_Values ';
1830: BEGIN

Line 1981: ,p_rslt_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE

1977: (p_assignment_id IN per_all_assignments.assignment_id%TYPE
1978: ,p_organization_id IN per_all_assignments.organization_id%TYPE
1979: ,p_effective_date IN DATE
1980: ,p_ext_dtl_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
1981: ,p_rslt_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
1982: ,p_asgaction_no IN NUMBER
1983: ,p_error_message OUT NOCOPY VARCHAR2) IS
1984:
1985: CURSOR csr_rule_ele

Line 2037: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;

2033: l_ben_params csr_ben%ROWTYPE;
2034: l_proc_name CONSTANT VARCHAR2(150) := g_proc_name ||'Process_Ext_Rslt_Dtl_Rec';
2035: l_foumula_type_id ff_formulas_f.formula_id%TYPE;
2036: l_outputs Ff_Exec.outputs_t;
2037: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;
2038: l_ff_value_fmt ben_ext_rslt_dtl.val_01%TYPE;
2039: l_max_len NUMBER;
2040: l_rqd_elmt_is_present VARCHAR2(2) := 'Y';
2041: l_person_id per_all_people_f.person_id%TYPE;

Line 2038: l_ff_value_fmt ben_ext_rslt_dtl.val_01%TYPE;

2034: l_proc_name CONSTANT VARCHAR2(150) := g_proc_name ||'Process_Ext_Rslt_Dtl_Rec';
2035: l_foumula_type_id ff_formulas_f.formula_id%TYPE;
2036: l_outputs Ff_Exec.outputs_t;
2037: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;
2038: l_ff_value_fmt ben_ext_rslt_dtl.val_01%TYPE;
2039: l_max_len NUMBER;
2040: l_rqd_elmt_is_present VARCHAR2(2) := 'Y';
2041: l_person_id per_all_people_f.person_id%TYPE;
2042: --

Line 2204: -- for the ben_ext_rslt_dtl when inserting or updating the record.

2200: END Process_Ext_Rslt_Dtl_Rec;
2201:
2202: -- =============================================================================
2203: -- Create_AsgAction_Lines: This procedure executes all the person based formulas
2204: -- for the ben_ext_rslt_dtl when inserting or updating the record.
2205: -- =============================================================================
2206: PROCEDURE Create_AsgAction_Lines
2207: (p_assignment_id IN NUMBER
2208: ,p_business_group_id IN NUMBER

Line 2298: -- Process_Assignments: This procedure creates a row in ben_ext_rslt_dtl table

2294: END IF;
2295: hr_utility.set_location('Leaving: '||l_proc_name, 80);
2296: END Get_Element_Details;
2297: -- =============================================================================
2298: -- Process_Assignments: This procedure creates a row in ben_ext_rslt_dtl table
2299: -- for each valid assig action when the reporting dimension is ASG_RUN.
2300: -- =============================================================================
2301: PROCEDURE Process_Assignments
2302: (p_assignment_id IN NUMBER

Line 2561: DELETE ben_ext_rslt_dtl

2557: );
2558: FETCH csr_rslt_dtl INTO l_main_rec;
2559: CLOSE csr_rslt_dtl;
2560: --
2561: DELETE ben_ext_rslt_dtl
2562: WHERE ext_rslt_dtl_id = l_main_rec.ext_rslt_dtl_id
2563: AND person_id = l_person_id;
2564: END IF;
2565: g_AfterTax.Count := 0;

Line 4466: (p_business_group_id ben_ext_rslt_dtl.business_group_id%TYPE

4462: -- ~ Del_Service_Detail_Recs : Delete all the records created as part
4463: -- ~ of hidden record as they are not required.
4464: -- ========================================================================
4465: FUNCTION Del_Service_Detail_Recs
4466: (p_business_group_id ben_ext_rslt_dtl.business_group_id%TYPE
4467: )RETURN NUMBER IS
4468: CURSOR csr_err (c_bg_id IN NUMBER
4469: ,c_ext_rslt_id IN NUMBER) IS
4470: SELECT err.person_id

Line 4494: FROM ben_ext_rslt_dtl

4490: -- Loop through each detail record for the extract
4491: LOOP
4492: -- Delete all hidden detail records for the all persons
4493: DELETE
4494: FROM ben_ext_rslt_dtl
4495: WHERE ext_rcd_id = csr_rcd_rec.ext_rcd_id
4496: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
4497: AND business_group_id = p_business_group_id;
4498: END LOOP;

Line 4518: FROM ben_ext_rslt_dtl dtl

4514: ,p_business_group_id => p_business_group_id
4515: ,p_benefit_action_id => l_ben_params.benefit_action_id
4516: ,p_flag_thread => 'Y');
4517: DELETE
4518: FROM ben_ext_rslt_dtl dtl
4519: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
4520: AND dtl.person_id = err_rec.person_id
4521: AND dtl.business_group_id = p_business_group_id;
4522: