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_NL_PGGM_PENSION_EXTRACTS dependencies on BEN_EXT_RCD

Line 25: FROM ben_ext_rcd rcd

21: rin.seq_num,
22: rin.hide_flag,
23: rcd.ext_rcd_id,
24: rcd.rcd_type_cd
25: FROM ben_ext_rcd rcd
26: ,ben_ext_rcd_in_file rin
27: ,ben_ext_dfn dfn
28: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
29: AND rin.ext_file_id = dfn.ext_file_id

Line 26: ,ben_ext_rcd_in_file rin

22: rin.hide_flag,
23: rcd.ext_rcd_id,
24: rcd.rcd_type_cd
25: FROM ben_ext_rcd rcd
26: ,ben_ext_rcd_in_file rin
27: ,ben_ext_dfn dfn
28: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
29: AND rin.ext_file_id = dfn.ext_file_id
30: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 128: FROM ben_ext_rcd rcd

124: -- Cursor to get the extract record id's for record sequence number
125: -- =============================================================================
126: CURSOR c_get_rcd_id(c_seq IN Number) IS
127: SELECT rcd.ext_rcd_id
128: FROM ben_ext_rcd rcd
129: ,ben_ext_rcd_in_file rin
130: ,ben_ext_dfn dfn
131: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract executing currently
132: AND rin.ext_file_id = dfn.ext_file_id

Line 129: ,ben_ext_rcd_in_file rin

125: -- =============================================================================
126: CURSOR c_get_rcd_id(c_seq IN Number) IS
127: SELECT rcd.ext_rcd_id
128: FROM ben_ext_rcd rcd
129: ,ben_ext_rcd_in_file rin
130: ,ben_ext_dfn dfn
131: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract executing currently
132: AND rin.ext_file_id = dfn.ext_file_id
133: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 143: FROM ben_ext_rcd rcd

139: CURSOR csr_ext_rcd_id (c_hide_flag IN Varchar2
140: ,c_rcd_type_cd IN Varchar2
141: ) IS
142: SELECT rcd.ext_rcd_id
143: FROM ben_ext_rcd rcd
144: ,ben_ext_rcd_in_file rin
145: ,ben_ext_dfn dfn
146: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract
147: AND rin.ext_file_id = dfn.ext_file_id

Line 144: ,ben_ext_rcd_in_file rin

140: ,c_rcd_type_cd IN Varchar2
141: ) IS
142: SELECT rcd.ext_rcd_id
143: FROM ben_ext_rcd rcd
144: ,ben_ext_rcd_in_file rin
145: ,ben_ext_dfn dfn
146: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract
147: AND rin.ext_file_id = dfn.ext_file_id
148: AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden

Line 157: FROM ben_ext_rcd rcd

153: -- Cursor to get the extract record id for hidden and Not hidden records
154: -- =============================================================================
155: CURSOR csr_ext_rcd_id_hidden(c_rcd_type_cd IN Varchar2) IS
156: SELECT rcd.ext_rcd_id
157: FROM ben_ext_rcd rcd
158: ,ben_ext_rcd_in_file rin
159: ,ben_ext_dfn dfn
160: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
161: AND rin.ext_file_id = dfn.ext_file_id

Line 158: ,ben_ext_rcd_in_file rin

154: -- =============================================================================
155: CURSOR csr_ext_rcd_id_hidden(c_rcd_type_cd IN Varchar2) IS
156: SELECT rcd.ext_rcd_id
157: FROM ben_ext_rcd rcd
158: ,ben_ext_rcd_in_file rin
159: ,ben_ext_dfn dfn
160: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
161: AND rin.ext_file_id = dfn.ext_file_id
162: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 495: (p_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE

491: -- ============================================================================
492: -- ~ Update_Record_Values :
493: -- ============================================================================
494: PROCEDURE Update_Record_Values
495: (p_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
496: ,p_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
497: ,p_data_element_value IN ben_ext_rslt_dtl.val_01%TYPE
498: ,p_data_ele_seqnum IN Number
499: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE

Line 501: CURSOR csr_seqnum (c_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE

497: ,p_data_element_value IN ben_ext_rslt_dtl.val_01%TYPE
498: ,p_data_ele_seqnum IN Number
499: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
500: ) IS
501: CURSOR csr_seqnum (c_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
502: ,c_ext_data_element_name IN ben_ext_data_elmt.NAME%TYPE
503: ) IS
504: SELECT der.ext_data_elmt_id,
505: der.seq_num,

Line 1246: ,p_ext_dtl_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE

1242: PROCEDURE Process_Ext_Rslt_Dtl_Rec
1243: (p_assignment_id IN per_all_assignments.assignment_id%TYPE
1244: ,p_organization_id IN per_all_assignments.organization_id%TYPE DEFAULT NULL
1245: ,p_effective_date IN Date
1246: ,p_ext_dtl_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE
1247: ,p_rslt_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE
1248: ,p_asgaction_no IN Number DEFAULT NULL
1249: ,p_error_message OUT NOCOPY Varchar2) IS
1250:

Line 1473: l_ext_rcd_id ben_ext_rcd.ext_rcd_id %TYPE;

1469: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1470: l_main_rec csr_rslt_dtl%ROWTYPE;
1471: l_new_rec csr_rslt_dtl%ROWTYPE;
1472: l_effective_date Date;
1473: l_ext_rcd_id ben_ext_rcd.ext_rcd_id %TYPE;
1474: l_record_num Varchar2(20);
1475: l_return_value Varchar2(2);
1476: l_conc_reqest_id NUMBER;
1477: l_ext_rslt_id NUMBER;

Line 1987: FROM ben_ext_rcd rcd

1983: rin.seq_num,
1984: rin.hide_flag,
1985: rcd.ext_rcd_id,
1986: rcd.rcd_type_cd
1987: FROM ben_ext_rcd rcd
1988: ,ben_ext_rcd_in_file rin
1989: ,ben_ext_dfn dfn
1990: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
1991: AND rin.ext_file_id = dfn.ext_file_id

Line 1988: ,ben_ext_rcd_in_file rin

1984: rin.hide_flag,
1985: rcd.ext_rcd_id,
1986: rcd.rcd_type_cd
1987: FROM ben_ext_rcd rcd
1988: ,ben_ext_rcd_in_file rin
1989: ,ben_ext_dfn dfn
1990: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
1991: AND rin.ext_file_id = dfn.ext_file_id
1992: AND rin.ext_rcd_id = rcd.ext_rcd_id

Line 7773: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

7769: WHERE ext_rslt_id=Ben_Ext_Thread.g_ext_rslt_id
7770: AND val_31=c_org_id;
7771:
7772:
7773: l_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
7774: l_rcd_id NUMBER;
7775: l_rcd_id_060 NUMBER;
7776: l_rcd_id_080 NUMBER;
7777: l_rcd_id_081 NUMBER;

Line 7779: l_ext_main_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

7775: l_rcd_id_060 NUMBER;
7776: l_rcd_id_080 NUMBER;
7777: l_rcd_id_081 NUMBER;
7778:
7779: l_ext_main_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
7780: l_proc_name Varchar2(150):= g_proc_name||'Sort_Post_Process';
7781: l_return_value Number := 0; --0= Sucess, -1=Error;
7782: l_tmp_person_id Number;
7783: l_tmp_org_id Number;