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_US_PENSION_EXTRACTS dependencies on BEN_EXT_RSLT_DTL

Line 246: FROM ben_ext_rslt_dtl dtl

242: CURSOR csr_rslt_dtl(c_person_id IN NUMBER
243: ,c_ext_rslt_id IN NUMBER
244: ,c_ext_dtl_rcd_id IN NUMBER ) IS
245: SELECT *
246: FROM ben_ext_rslt_dtl dtl
247: WHERE dtl.ext_rslt_id = c_ext_rslt_id
248: AND dtl.person_id = c_person_id
249: AND dtl.ext_rcd_id = c_ext_dtl_rcd_id;
250: -- =============================================================================

Line 1676: ,p_data_element_value IN ben_ext_rslt_dtl.val_01%TYPE

1672: -- ================================================================================
1673: PROCEDURE Update_Record_Values
1674: (p_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
1675: ,p_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
1676: ,p_data_element_value IN ben_ext_rslt_dtl.val_01%TYPE
1677: ,p_data_ele_seqnum IN NUMBER
1678: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
1679: ) IS
1680: CURSOR csr_seqnum (c_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE

Line 1678: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE

1674: (p_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
1675: ,p_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
1676: ,p_data_element_value IN ben_ext_rslt_dtl.val_01%TYPE
1677: ,p_data_ele_seqnum IN NUMBER
1678: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
1679: ) IS
1680: CURSOR csr_seqnum (c_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
1681: ,c_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
1682: ) IS

Line 1695: l_ext_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;

1691: ORDER BY seq_num;
1692:
1693: l_seqnum_rec csr_seqnum%ROWTYPE;
1694: l_proc_name VARCHAR2(150):= g_proc_name||'Update_Record_Values';
1695: l_ext_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;
1696: BEGIN
1697:
1698: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
1699: -- nocopy changes

Line 1881: (p_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE

1877: -- ================================================================================
1878: -- ~ Ins_Rslt_Dtl : Inserts a record into the results detail record.
1879: -- ================================================================================
1880: PROCEDURE Ins_Rslt_Dtl
1881: (p_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
1882: ,p_val_tab IN ValTabTyp
1883: ,p_rslt_dtl_id OUT NOCOPY NUMBER
1884: ) IS
1885:

Line 1887: l_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;

1883: ,p_rslt_dtl_id OUT NOCOPY NUMBER
1884: ) IS
1885:
1886: l_proc_name VARCHAR2(150) := g_proc_name||'Ins_Rslt_Dtl';
1887: l_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;
1888:
1889: BEGIN -- ins_rslt_dtl
1890: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
1891: -- nocopy changes

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

1890: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
1891: -- nocopy changes
1892: l_dtl_rec_nc := p_dtl_rec;
1893: -- Get the next sequence NUMBER to insert a record into the table
1894: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
1895: INSERT INTO ben_ext_rslt_dtl
1896: (EXT_RSLT_DTL_ID
1897: ,EXT_RSLT_ID
1898: ,BUSINESS_GROUP_ID

Line 1895: INSERT INTO ben_ext_rslt_dtl

1891: -- nocopy changes
1892: l_dtl_rec_nc := p_dtl_rec;
1893: -- Get the next sequence NUMBER to insert a record into the table
1894: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
1895: INSERT INTO ben_ext_rslt_dtl
1896: (EXT_RSLT_DTL_ID
1897: ,EXT_RSLT_ID
1898: ,BUSINESS_GROUP_ID
1899: ,EXT_RCD_ID

Line 2103: (p_dtl_rec IN ben_ext_rslt_dtl%ROWTYPE

2099: -- =============================================================================
2100: -- ~Upd_Rslt_Dtl : Updates the primary assignment record in results detail table
2101: -- =============================================================================
2102: PROCEDURE Upd_Rslt_Dtl
2103: (p_dtl_rec IN ben_ext_rslt_dtl%ROWTYPE
2104: ,p_val_tab IN ValTabTyp ) IS
2105:
2106: l_proc_name VARCHAR2(150):= g_proc_name||'upd_rslt_dtl';
2107:

Line 2109: UPDATE ben_ext_rslt_dtl

2105:
2106: l_proc_name VARCHAR2(150):= g_proc_name||'upd_rslt_dtl';
2107:
2108: BEGIN -- Upd_Rslt_Dtl
2109: UPDATE ben_ext_rslt_dtl
2110: SET VAL_01 = p_val_tab(1)
2111: ,VAL_02 = p_val_tab(2)
2112: ,VAL_03 = p_val_tab(3)
2113: ,VAL_04 = p_val_tab(4)

Line 2640: (p_rslt_rec IN ben_ext_rslt_dtl%ROWTYPE

2636: -- =============================================================================
2637: -- Copy_Rec_Values :
2638: -- =============================================================================
2639: PROCEDURE Copy_Rec_Values
2640: (p_rslt_rec IN ben_ext_rslt_dtl%ROWTYPE
2641: ,p_val_tab IN OUT NOCOPY ValTabTyp) IS
2642:
2643: l_proc_name VARCHAR2(150) := g_proc_name ||'Copy_Rec_Values ';
2644: BEGIN

Line 2797: ,p_rslt_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE

2793: (p_assignment_id IN per_all_assignments.assignment_id%TYPE
2794: ,p_organization_id IN per_all_assignments.organization_id%TYPE
2795: ,p_effective_date IN DATE
2796: ,p_ext_dtl_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
2797: ,p_rslt_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
2798: ,p_asgaction_no IN NUMBER
2799: ,p_error_message OUT NOCOPY VARCHAR2) IS
2800:
2801: CURSOR csr_rule_ele

Line 2853: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;

2849: l_ben_params csr_ben%ROWTYPE;
2850: l_proc_name VARCHAR2(150) := g_proc_name ||'Process_Ext_Rslt_Dtl_Rec';
2851: l_foumula_type_id ff_formulas_f.formula_id%TYPE;
2852: l_outputs Ff_Exec.outputs_t;
2853: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;
2854: l_ff_value_fmt ben_ext_rslt_dtl.val_01%TYPE;
2855: l_max_len NUMBER;
2856: l_rqd_elmt_is_present VARCHAR2(2) := 'Y';
2857: l_person_id per_all_people_f.person_id%TYPE;

Line 2854: l_ff_value_fmt ben_ext_rslt_dtl.val_01%TYPE;

2850: l_proc_name VARCHAR2(150) := g_proc_name ||'Process_Ext_Rslt_Dtl_Rec';
2851: l_foumula_type_id ff_formulas_f.formula_id%TYPE;
2852: l_outputs Ff_Exec.outputs_t;
2853: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;
2854: l_ff_value_fmt ben_ext_rslt_dtl.val_01%TYPE;
2855: l_max_len NUMBER;
2856: l_rqd_elmt_is_present VARCHAR2(2) := 'Y';
2857: l_person_id per_all_people_f.person_id%TYPE;
2858: --

Line 3740: DELETE ben_ext_rslt_dtl

3736: ,c_ext_dtl_rcd_id => g_ext_dtl_rcd_id
3737: );
3738: FETCH csr_rslt_dtl INTO l_main_rec;
3739: CLOSE csr_rslt_dtl;
3740: DELETE ben_ext_rslt_dtl
3741: WHERE ext_rslt_dtl_id = l_main_rec.ext_rslt_dtl_id
3742: AND person_id = l_person_id;
3743: END IF;
3744:

Line 5286: (p_business_group_id ben_ext_rslt_dtl.business_group_id%TYPE

5282: -- ~ Del_Service_Detail_Recs : Delete all the records created as part
5283: -- ~ of hidden record as they are not required.
5284: -- ====================================================================
5285: FUNCTION Del_Service_Detail_Recs
5286: (p_business_group_id ben_ext_rslt_dtl.business_group_id%TYPE
5287: )RETURN NUMBER IS
5288:
5289: CURSOR csr_err (c_bg_id IN NUMBER
5290: ,c_ext_rslt_id IN NUMBER) IS

Line 5314: FROM ben_ext_rslt_dtl

5310: -- Loop through each detail record for the extract
5311: LOOP
5312: -- Delete all hidden detail records for the all persons
5313: DELETE
5314: FROM ben_ext_rslt_dtl
5315: WHERE ext_rcd_id = csr_rcd_rec.ext_rcd_id
5316: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
5317: AND business_group_id = p_business_group_id;
5318: END LOOP;

Line 5337: FROM ben_ext_rslt_dtl dtl

5333: ,p_benefit_action_id => l_ben_params.benefit_action_id
5334: ,p_flag_thread => 'Y');
5335:
5336: DELETE
5337: FROM ben_ext_rslt_dtl dtl
5338: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
5339: AND dtl.person_id = err_rec.person_id
5340: AND dtl.business_group_id = p_business_group_id;
5341: END LOOP;