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_RSLT_DTL

Line 220: FROM ben_ext_rslt_dtl dtl

216: CURSOR csr_rslt_dtl(c_person_id IN Number
217: ,c_ext_rslt_id IN Number
218: ,c_ext_dtl_rcd_id IN Number ) IS
219: SELECT *
220: FROM ben_ext_rslt_dtl dtl
221: WHERE dtl.ext_rslt_id = c_ext_rslt_id
222: AND dtl.person_id = c_person_id
223: AND dtl.ext_rcd_id = c_ext_dtl_rcd_id;
224: -- =============================================================================

Line 497: ,p_data_element_value IN ben_ext_rslt_dtl.val_01%TYPE

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
500: ) IS
501: CURSOR csr_seqnum (c_ext_rcd_id IN ben_ext_rcd.ext_rcd_id%TYPE

Line 499: ,p_ext_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE

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
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

Line 516: l_ext_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;

512: ORDER BY seq_num;
513:
514: l_seqnum_rec csr_seqnum%ROWTYPE;
515: l_proc_name Varchar2(150):= g_proc_name||'Update_Record_Values';
516: l_ext_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;
517: BEGIN
518:
519: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
520: -- nocopy changes

Line 702: PROCEDURE Ins_Rslt_Dtl(p_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE) IS

698:
699: -- ============================================================================
700: -- ~ Ins_Rslt_Dtl : Inserts a record into the results detail record.
701: -- ============================================================================
702: PROCEDURE Ins_Rslt_Dtl(p_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE) IS
703:
704: l_proc_name Varchar2(150) := g_proc_name||'Ins_Rslt_Dtl';
705: l_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;
706:

Line 705: l_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;

701: -- ============================================================================
702: PROCEDURE Ins_Rslt_Dtl(p_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE) IS
703:
704: l_proc_name Varchar2(150) := g_proc_name||'Ins_Rslt_Dtl';
705: l_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;
706:
707: BEGIN -- ins_rslt_dtl
708: --hr_utility.trace_on(null,'rk');
709: Hr_Utility.set_location('Entering :'||l_proc_name, 5);

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

709: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
710: -- nocopy changes
711: l_dtl_rec_nc := p_dtl_rec;
712: -- Get the next sequence NUMBER to insert a record into the table
713: SELECT ben_ext_rslt_dtl_s .NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
714: hr_utility.set_location(p_dtl_rec.EXT_RSLT_DTL_ID,10);
715: hr_utility.set_location(p_dtl_rec.EXT_RSLT_ID,10);
716: hr_utility.set_location(p_dtl_rec.BUSINESS_GROUP_ID,10);
717: hr_utility.set_location(p_dtl_rec.EXT_RCD_ID,10);

Line 809: INSERT INTO ben_ext_rslt_dtl

805: hr_utility.set_location(p_dtl_rec.SCND_SORT_VAL,10);
806: hr_utility.set_location(p_dtl_rec.THRD_SORT_VAL,10);
807: hr_utility.set_location(p_dtl_rec.TRANS_SEQ_NUM,10);
808: hr_utility.set_location(p_dtl_rec.RCRD_SEQ_NUM,10);
809: INSERT INTO ben_ext_rslt_dtl
810: (EXT_RSLT_DTL_ID
811: ,EXT_RSLT_ID
812: ,BUSINESS_GROUP_ID
813: ,EXT_RCD_ID

Line 1017: PROCEDURE Upd_Rslt_Dtl(p_dtl_rec IN ben_ext_rslt_dtl %ROWTYPE ) IS

1013:
1014: -- ============================================================================
1015: -- ~ Upd_Rslt_Dtl : Updates the primary assignment record in results detail table
1016: -- ============================================================================
1017: PROCEDURE Upd_Rslt_Dtl(p_dtl_rec IN ben_ext_rslt_dtl %ROWTYPE ) IS
1018:
1019: l_proc_name Varchar2(150):= g_proc_name||'upd_rslt_dtl';
1020:
1021: BEGIN -- Upd_Rslt_Dtl

Line 1022: UPDATE ben_ext_rslt_dtl

1018:
1019: l_proc_name Varchar2(150):= g_proc_name||'upd_rslt_dtl';
1020:
1021: BEGIN -- Upd_Rslt_Dtl
1022: UPDATE ben_ext_rslt_dtl
1023: SET VAL_01 = p_dtl_rec.VAL_01
1024: ,VAL_02 = p_dtl_rec.VAL_02
1025: ,VAL_03 = p_dtl_rec.VAL_03
1026: ,VAL_04 = p_dtl_rec.VAL_04

Line 1247: ,p_rslt_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE

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:
1251: CURSOR csr_rule_ele

Line 1298: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;

1294:
1295: l_proc_name Varchar2(150) := g_proc_name ||'Process_Ext_Rslt_Dtl_Rec';
1296: l_formula_type_id ff_formulas_f.formula_id%TYPE;
1297: l_outputs Ff_Exec.outputs_t;
1298: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;
1299: l_ff_value_fmt ben_ext_rslt_dtl.val_01%TYPE;
1300: l_org_id per_all_assignments_f.organization_id%TYPE;
1301: l_bgid per_all_assignments_f.business_group_id%TYPE;
1302:

Line 1299: l_ff_value_fmt ben_ext_rslt_dtl.val_01%TYPE;

1295: l_proc_name Varchar2(150) := g_proc_name ||'Process_Ext_Rslt_Dtl_Rec';
1296: l_formula_type_id ff_formulas_f.formula_id%TYPE;
1297: l_outputs Ff_Exec.outputs_t;
1298: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;
1299: l_ff_value_fmt ben_ext_rslt_dtl.val_01%TYPE;
1300: l_org_id per_all_assignments_f.organization_id%TYPE;
1301: l_bgid per_all_assignments_f.business_group_id%TYPE;
1302:
1303:

Line 1686: DELETE ben_ext_rslt_dtl

1682: FETCH csr_rslt_dtl INTO l_main_rec;
1683: WHILE csr_rslt_dtl%FOUND
1684: LOOP
1685: -- Delete for each detail record for the person
1686: DELETE ben_ext_rslt_dtl
1687: WHERE ext_rslt_dtl_id = l_main_rec.ext_rslt_dtl_id
1688: AND person_id = l_person_id;
1689: FETCH csr_rslt_dtl INTO l_main_rec;
1690:

Line 1710: DELETE ben_ext_rslt_dtl

1706: FETCH csr_rslt_dtl INTO l_main_rec;
1707: WHILE csr_rslt_dtl%FOUND
1708: LOOP
1709: -- Delete for each detail record for the person
1710: DELETE ben_ext_rslt_dtl
1711: WHERE ext_rslt_dtl_id = l_main_rec.ext_rslt_dtl_id
1712: AND person_id = l_person_id;
1713: FETCH csr_rslt_dtl INTO l_main_rec;
1714: END LOOP; -- While csr_rslt_dtl%FOUND

Line 7698: FROM ben_ext_rslt_dtl dtl

7694:
7695: CURSOR csr_get_record_count(c_record_id IN Number
7696: ,c_org_id IN Number ) IS
7697: SELECT Count(dtl.ext_rslt_dtl_id)
7698: FROM ben_ext_rslt_dtl dtl
7699: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
7700: AND ext_rcd_id IN(c_record_id);
7701: --AND val_31=c_org_id;
7702:

Line 7723: (p_business_group_id ben_ext_rslt_dtl.business_group_id%TYPE

7719: -- ================================================================================
7720: -- ~ Sort_Post_Process : Post process logic
7721: -- ================================================================================
7722: FUNCTION Sort_Post_Process
7723: (p_business_group_id ben_ext_rslt_dtl.business_group_id%TYPE
7724: )RETURN Number IS
7725:
7726: CURSOR csr_get_rslt(c_org_id IN Varchar2
7727: ,c_ext_rslt_id IN Number ) IS

Line 7729: FROM ben_ext_rslt_dtl dtl

7725:
7726: CURSOR csr_get_rslt(c_org_id IN Varchar2
7727: ,c_ext_rslt_id IN Number ) IS
7728: SELECT DISTINCT(val_32) val_32
7729: FROM ben_ext_rslt_dtl dtl
7730: WHERE dtl.ext_rslt_id = c_ext_rslt_id
7731: AND val_31= c_org_id
7732: ORDER BY val_32 ASC ;
7733:

Line 7736: FROM ben_ext_rslt_dtl dtl

7732: ORDER BY val_32 ASC ;
7733:
7734: CURSOR csr_get_rslt1(c_ext_rslt_id IN Number ) IS
7735: SELECT val_31,val_32
7736: FROM ben_ext_rslt_dtl dtl
7737: WHERE dtl.ext_rslt_id = c_ext_rslt_id
7738: ORDER BY val_32 ASC;
7739:
7740: CURSOR csr_rslt_dtl_sort(c_val_32 IN Varchar2

Line 7743: FROM ben_ext_rslt_dtl dtl

7739:
7740: CURSOR csr_rslt_dtl_sort(c_val_32 IN Varchar2
7741: ,c_ext_rslt_id IN Number ) IS
7742: SELECT *
7743: FROM ben_ext_rslt_dtl dtl
7744: WHERE dtl.ext_rslt_id = c_ext_rslt_id
7745: -- AND dtl.person_id = c_person_id
7746: AND dtl.val_32 =c_val_32;
7747:

Line 7753: FROM ben_ext_rslt_dtl dtl

7749:
7750: CURSOR csr_get_header_rslt(c_ext_rslt_id IN Number
7751: ,c_ext_dtl_rcd_id IN Number ) IS
7752: SELECT *
7753: FROM ben_ext_rslt_dtl dtl
7754: WHERE dtl.ext_rslt_id = c_ext_rslt_id
7755: AND ext_rcd_id= c_ext_dtl_rcd_id;
7756:
7757:

Line 7761: FROM ben_ext_rslt_dtl dtl

7757:
7758: CURSOR csr_get_trailer_rslt(c_ext_rslt_id IN Number
7759: ,c_ext_dtl_rcd_id IN Number ) IS
7760: SELECT *
7761: FROM ben_ext_rslt_dtl dtl
7762: WHERE dtl.ext_rslt_id = c_ext_rslt_id
7763: AND ext_rcd_id= c_ext_dtl_rcd_id;
7764:
7765: -- Cursor to get the person existence flag

Line 7768: FROM ben_ext_rslt_dtl

7764:
7765: -- Cursor to get the person existence flag
7766: CURSOR csr_get_person_exist(c_org_id IN Number) IS
7767: SELECT 'x'
7768: FROM ben_ext_rslt_dtl
7769: WHERE ext_rslt_id=Ben_Ext_Thread.g_ext_rslt_id
7770: AND val_31=c_org_id;
7771:
7772:

Line 7835: DELETE ben_ext_rslt_dtl

7831: ,c_rcd_type_cd => 'D')-- D=Detail, T=Total, H-Header
7832: -- Loop through each detail record for the extract
7833: LOOP
7834: -- Delete all detail records for the record which are hidden
7835: DELETE ben_ext_rslt_dtl
7836: WHERE ext_rcd_id = csr_rcd_rec.ext_rcd_id
7837: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
7838: AND business_group_id = p_business_group_id;
7839: END LOOP; -- FOR csr_rcd_rec

Line 7857: DELETE ben_ext_rslt_dtl

7853: FETCH c_get_rcd_id INTO l_rcd_id_081;
7854: CLOSE c_get_rcd_id;
7855:
7856: --Delete all extra records created by system extract
7857: DELETE ben_ext_rslt_dtl
7858: WHERE ext_rcd_id IN ( l_rcd_id_060,l_rcd_id_080,l_rcd_id_081 )
7859: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
7860: AND business_group_id = p_business_group_id
7861: AND val_40='Delete';

Line 8097: FROM ben_ext_rslt_dtl dtl

8093: l_ext_rslt_dtl_id := l_999_rslt_dtl_id;
8094: END IF;
8095:
8096: DELETE
8097: FROM ben_ext_rslt_dtl dtl
8098: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
8099: AND dtl.ext_rcd_id = csr_rcd_rec.ext_rcd_id
8100: AND dtl.ext_rslt_dtl_id = l_ext_rslt_dtl_id
8101: AND business_group_id = p_business_group_id;

Line 8115: FROM ben_ext_rslt_dtl dtl

8111: l_ext_rslt_dtl_id := l_000_rslt_dtl_id;
8112: END IF;
8113:
8114: DELETE
8115: FROM ben_ext_rslt_dtl dtl
8116: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
8117: AND dtl.ext_rcd_id = csr_rcd_rec.ext_rcd_id
8118: AND dtl.ext_rslt_dtl_id = l_ext_rslt_dtl_id
8119: AND business_group_id = p_business_group_id;