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

Line 8: From ben_ext_rslt_dtl dtl

4: Cursor csr_rslt_dtl(c_person_id In Number
5: ,c_ext_rslt_id In Number
6: ,c_ext_dtl_rcd_id in Number ) Is
7: Select *
8: From ben_ext_rslt_dtl dtl
9: Where dtl.ext_rslt_id = c_ext_rslt_id
10: And dtl.person_id = c_person_id
11: And dtl.ext_rcd_id = c_ext_dtl_rcd_id;
12:

Line 1302: Delete from ben_ext_rslt_dtl where ext_rslt_dtl_id = l_main_rec.ext_rslt_dtl_id;

1298: End Loop; -- While l_curr_sec_asg_id Is Not Null
1299: g_all_sec_asgs.DELETE;
1300: End If;
1301: If g_primary_asg(p_assignment_id).assignment_type <> 'E' Then
1302: Delete from ben_ext_rslt_dtl where ext_rslt_dtl_id = l_main_rec.ext_rslt_dtl_id;
1303: End If;
1304: g_primary_asg.DELETE;
1305: g_payroll_names.DELETE;
1306: hr_utility.set_location('Leaving: '||l_proc_name, 130);

Line 1407: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;

1403: l_foumula_type_id ff_formulas_f.formula_id%TYPE;
1404: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1405: l_organization_id per_all_assignments_f.organization_id%TYPE;
1406: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1407: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;
1408: l_ff_value_fmt ben_ext_rslt_dtl.val_01%TYPE;
1409: l_effective_date date;
1410: l_outputs ff_exec.outputs_t;
1411: -- Rowtype Variable Declaration

Line 1408: l_ff_value_fmt ben_ext_rslt_dtl.val_01%TYPE;

1404: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1405: l_organization_id per_all_assignments_f.organization_id%TYPE;
1406: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1407: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;
1408: l_ff_value_fmt ben_ext_rslt_dtl.val_01%TYPE;
1409: l_effective_date date;
1410: l_outputs ff_exec.outputs_t;
1411: -- Rowtype Variable Declaration
1412: l_main_rec csr_rslt_dtl%ROWTYPE;

Line 1542: ,p_data_element_value In ben_ext_rslt_dtl.val_01%TYPE

1538: -- ~ Update_Record_Values :
1539: -- ================================================================================
1540: Procedure Update_Record_Values ( p_ext_rcd_id In ben_ext_rcd.ext_rcd_id%TYPE
1541: ,p_ext_data_element_name In ben_ext_data_elmt.name%TYPE
1542: ,p_data_element_value In ben_ext_rslt_dtl.val_01%TYPE
1543: ,p_data_ele_seqnum In Number
1544: ,p_ext_dtl_rec In out nocopy ben_ext_rslt_dtl%ROWTYPE
1545: ) Is
1546: Cursor csr_seqnum ( c_ext_rcd_id In ben_ext_rcd.ext_rcd_id%TYPE

Line 1544: ,p_ext_dtl_rec In out nocopy ben_ext_rslt_dtl%ROWTYPE

1540: Procedure Update_Record_Values ( p_ext_rcd_id In ben_ext_rcd.ext_rcd_id%TYPE
1541: ,p_ext_data_element_name In ben_ext_data_elmt.name%TYPE
1542: ,p_data_element_value In ben_ext_rslt_dtl.val_01%TYPE
1543: ,p_data_ele_seqnum In Number
1544: ,p_ext_dtl_rec In out nocopy ben_ext_rslt_dtl%ROWTYPE
1545: ) Is
1546: Cursor csr_seqnum ( c_ext_rcd_id In ben_ext_rcd.ext_rcd_id%TYPE
1547: ,c_ext_data_element_name In ben_ext_data_elmt.name%TYPE
1548: ) Is

Line 1562: l_ext_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;

1558:
1559: l_seqnum_rec csr_seqnum%ROWTYPE;
1560: l_proc_name varchar2(150):= g_proc_name||'Update_Record_Values';
1561: -- nocopy changes
1562: l_ext_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;
1563: Begin
1564:
1565: hr_utility.set_location('Entering :'||l_proc_name, 5);
1566: -- nocopy changes

Line 1753: Procedure Ins_Rslt_Dtl(p_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE) Is

1749:
1750: -- ================================================================================
1751: -- ~ Ins_Rslt_Dtl : Inserts a record into the results detail record.
1752: -- ================================================================================
1753: Procedure Ins_Rslt_Dtl(p_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE) Is
1754:
1755: l_proc_name Varchar2(150) := g_proc_name||'Ins_Rslt_Dtl';
1756: l_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;
1757:

Line 1756: l_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;

1752: -- ================================================================================
1753: Procedure Ins_Rslt_Dtl(p_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE) Is
1754:
1755: l_proc_name Varchar2(150) := g_proc_name||'Ins_Rslt_Dtl';
1756: l_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;
1757:
1758: BEGIN -- ins_rslt_dtl
1759: hr_utility.set_location('Entering :'||l_proc_name, 5);
1760:

Line 1764: hr_utility.set_location('.....Fetching seq. ben_ext_rslt_dtl_s.NEXTVAL' , 10);

1760:
1761: -- nocopy changes
1762: l_dtl_rec_nc := p_dtl_rec;
1763:
1764: hr_utility.set_location('.....Fetching seq. ben_ext_rslt_dtl_s.NEXTVAL' , 10);
1765:
1766: -- Get the next sequence number to insert a record into the table
1767: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
1768:

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

1763:
1764: hr_utility.set_location('.....Fetching seq. ben_ext_rslt_dtl_s.NEXTVAL' , 10);
1765:
1766: -- Get the next sequence number to insert a record into the table
1767: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
1768:
1769: hr_utility.set_location('.....Inserting into ben_ext_rslt_dtl table...' , 15);
1770:
1771: INSERT INTO ben_ext_rslt_dtl

Line 1769: hr_utility.set_location('.....Inserting into ben_ext_rslt_dtl table...' , 15);

1765:
1766: -- Get the next sequence number to insert a record into the table
1767: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
1768:
1769: hr_utility.set_location('.....Inserting into ben_ext_rslt_dtl table...' , 15);
1770:
1771: INSERT INTO ben_ext_rslt_dtl
1772: (EXT_RSLT_DTL_ID
1773: ,EXT_RSLT_ID

Line 1771: INSERT INTO ben_ext_rslt_dtl

1767: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
1768:
1769: hr_utility.set_location('.....Inserting into ben_ext_rslt_dtl table...' , 15);
1770:
1771: INSERT INTO ben_ext_rslt_dtl
1772: (EXT_RSLT_DTL_ID
1773: ,EXT_RSLT_ID
1774: ,BUSINESS_GROUP_ID
1775: ,EXT_RCD_ID

Line 1979: Procedure Upd_Rslt_Dtl(p_dtl_rec IN ben_ext_rslt_dtl%ROWTYPE ) Is

1975:
1976: -- ================================================================================
1977: -- ~ Upd_Rslt_Dtl : Updates the primary assignment record in results detail table
1978: -- ================================================================================
1979: Procedure Upd_Rslt_Dtl(p_dtl_rec IN ben_ext_rslt_dtl%ROWTYPE ) Is
1980:
1981: l_proc_name varchar2(150):= g_proc_name||'upd_rslt_dtl';
1982:
1983: Begin -- Upd_Rslt_Dtl

Line 1984: UPDATE ben_ext_rslt_dtl

1980:
1981: l_proc_name varchar2(150):= g_proc_name||'upd_rslt_dtl';
1982:
1983: Begin -- Upd_Rslt_Dtl
1984: UPDATE ben_ext_rslt_dtl
1985: SET VAL_01 = p_dtl_rec.VAL_01
1986: ,VAL_02 = p_dtl_rec.VAL_02
1987: ,VAL_03 = p_dtl_rec.VAL_03
1988: ,VAL_04 = p_dtl_rec.VAL_04

Line 2075: Function Del_Service_Detail_Recs (p_business_group_id ben_ext_rslt_dtl.business_group_id%TYPE

2071: -- ====================================================================
2072: -- ~ Del_Service_Detail_Recs : Delete all the records created as part
2073: -- ~ of hidden record as they are not required.
2074: -- ====================================================================
2075: Function Del_Service_Detail_Recs (p_business_group_id ben_ext_rslt_dtl.business_group_id%TYPE
2076: )Return Number Is
2077:
2078: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
2079: l_ext_main_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

Line 2093: hr_utility.set_location('.....Deleting temp records from ben_ext_rslt_dtl...',15);

2089:
2090: Fetch csr_ext_rcd_id INTO l_ext_dtl_rcd_id;
2091: Close csr_ext_rcd_id;
2092:
2093: hr_utility.set_location('.....Deleting temp records from ben_ext_rslt_dtl...',15);
2094:
2095: Delete
2096: From ben_ext_rslt_dtl dtl
2097: Where dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id

Line 2096: From ben_ext_rslt_dtl dtl

2092:
2093: hr_utility.set_location('.....Deleting temp records from ben_ext_rslt_dtl...',15);
2094:
2095: Delete
2096: From ben_ext_rslt_dtl dtl
2097: Where dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id
2098: And dtl.ext_rcd_id = l_ext_dtl_rcd_id
2099: And business_group_id = p_business_group_id
2100: And dtl.val_01 In ( 'SEC_ASSIGN_FOUND','SEC_ASSIGN_NOTFOUND' );