APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on BEN_EXT_THREAD

Line 2592: AND ext_dfn_id = ben_ext_thread.g_ext_dfn_id --ENH2

2588: ,last_update_date = SYSDATE
2589: ,last_update_login = fnd_global.login_id
2590: ,object_version_number = (object_version_number + 1)
2591: WHERE record_type = 'X'
2592: AND ext_dfn_id = ben_ext_thread.g_ext_dfn_id --ENH2
2593: AND lea_number = g_lea_number; --ENH1
2594:
2595: END IF;
2596:

Line 11035: AND emd.ext_dfn_id = ben_ext_thread.g_ext_dfn_id --ENH3

11031: SELECT *
11032: FROM pqp_ext_cross_person_records emd
11033: WHERE emd.record_type = 'X'
11034: AND emd.national_identifier = p_national_identifier
11035: AND emd.ext_dfn_id = ben_ext_thread.g_ext_dfn_id --ENH3
11036: AND emd.lea_number = g_lea_number --ENH3
11037: FOR UPDATE OF processing_status NOWAIT;
11038:
11039:

Line 11123: ,ben_ext_thread.g_ext_dfn_id --ENH3

11119: ,object_version_number
11120: )
11121: VALUES
11122: ('X'
11123: ,ben_ext_thread.g_ext_dfn_id --ENH3
11124: ,pqp_gb_tp_pension_extracts.g_lea_number --ENH3
11125: ,p_business_group_id
11126: ,p_person_id
11127: ,p_national_identifier

Line 16183: debug('ben_ext_thread.g_ext_rslt_id :'||to_char(ben_ext_thread.g_ext_rslt_id),10);

16179: BEGIN -- create_new_lines
16180:
16181: debug_enter(l_proc_name);
16182:
16183: debug('ben_ext_thread.g_ext_rslt_id :'||to_char(ben_ext_thread.g_ext_rslt_id),10);
16184: debug('g_ext_dtl_rcd_id :'||to_char(g_ext_dtl_rcd_id),20);
16185: debug('person id :'||to_char(g_ext_asg_details(p_assignment_id).person_id),30);
16186: debug('assignment id :'||to_char(p_assignment_id),40);
16187:

Line 16191: ,p_ext_rslt_id => ben_ext_thread.g_ext_rslt_id

16187:
16188: -- Get the main detail record
16189: OPEN csr_rslt_dtl
16190: (p_person_id => g_ext_asg_details(p_assignment_id).person_id
16191: ,p_ext_rslt_id => ben_ext_thread.g_ext_rslt_id
16192: );
16193: FETCH csr_rslt_dtl INTO l_main_rec;
16194: IF csr_rslt_dtl%NOTFOUND THEN
16195: debug('No Data Found in csr_rslt_dtl', 50);

Line 16714: FOR l_cur_rec IN csr_rslt_dtl_sort(g_ext_asg_details(p_assignment_id).person_id,ben_ext_thread.g_ext_rslt_id)

16710:
16711:
16712: --check if flag l_mark_for_delete is true, then shift the records up by one and delete the last record
16713: IF (l_mark_for_delete) THEN
16714: FOR l_cur_rec IN csr_rslt_dtl_sort(g_ext_asg_details(p_assignment_id).person_id,ben_ext_thread.g_ext_rslt_id)
16715: LOOP
16716: debug('Processing Record:'||l_cur_rec.val_26);
16717: IF (l_cur_rec.val_26 <> 1) THEN
16718: copy_rec_val(l_cur_rec,l_prev_rec);

Line 17080: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id

17076: CLOSE csr_ext_rcd_id;
17077:
17078: DELETE
17079: FROM ben_ext_rslt_dtl dtl
17080: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id
17081: AND dtl.ext_rcd_id = l_ext_dtl_rcd_id
17082: AND dtl.val_01 = 'DELETE';
17083:
17084: debug('Number of Dummy Records Deleted :'||to_char(SQL%ROWCOUNT));