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_PENSION_EXTRACTS dependencies on BEN_EXT_THREAD

Line 39: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id

35: rcd.rcd_type_cd
36: FROM ben_ext_rcd rcd
37: ,ben_ext_rcd_in_file rin
38: ,ben_ext_dfn dfn
39: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
40: AND rin.ext_file_id = dfn.ext_file_id
41: AND rin.ext_rcd_id = rcd.ext_rcd_id
42: ORDER BY rin.seq_num;
43:

Line 52: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract executing currently

48: SELECT rcd.ext_rcd_id
49: FROM ben_ext_rcd rcd
50: ,ben_ext_rcd_in_file rin
51: ,ben_ext_dfn dfn
52: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract executing currently
53: AND rin.ext_file_id = dfn.ext_file_id
54: AND rin.ext_rcd_id = rcd.ext_rcd_id
55: AND rin.seq_num = c_seq;
56:

Line 258: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract

254: SELECT rcd.ext_rcd_id
255: FROM ben_ext_rcd rcd
256: ,ben_ext_rcd_in_file rin
257: ,ben_ext_dfn dfn
258: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract
259: AND rin.ext_file_id = dfn.ext_file_id
260: AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden
261: AND rin.ext_rcd_id = rcd.ext_rcd_id
262: AND rcd.rcd_type_cd = c_rcd_type_cd; -- D=Detail,H=Header,F=Footer

Line 272: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id

268: SELECT rcd.ext_rcd_id
269: FROM ben_ext_rcd rcd
270: ,ben_ext_rcd_in_file rin
271: ,ben_ext_dfn dfn
272: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
273: AND rin.ext_file_id = dfn.ext_file_id
274: AND rin.ext_rcd_id = rcd.ext_rcd_id
275: AND rcd.rcd_type_cd = c_rcd_type_cd
276: ORDER BY rin.seq_num;

Line 1346: Ben_Ext_Thread.process

1342: IF g_debug THEN
1343: Hr_Utility.set_location('..Calling Benefit Ext Process'||l_proc_name, 6);
1344: END IF;
1345:
1346: Ben_Ext_Thread.process
1347: (errbuf => l_errbuff,
1348: retcode => l_retcode,
1349: p_benefit_action_id => NULL,
1350: p_ext_dfn_id => p_ext_dfn_id,

Line 2001: ,p_param1_value => To_Char(Nvl(Ben_Ext_Thread.g_ext_dfn_id, -1))

1997: ,p_organization_id => l_org_id
1998: ,p_business_group_id => l_bgid
1999: ,p_jurisdiction_code => NULL
2000: ,p_param1 => 'EXT_DFN_ID'
2001: ,p_param1_value => To_Char(Nvl(Ben_Ext_Thread.g_ext_dfn_id, -1))
2002: ,p_param2 => 'EXT_RSLT_ID'
2003: ,p_param2_value => To_Char(Nvl(Ben_Ext_Thread.g_ext_rslt_id, -1))
2004: );
2005: l_ff_value := l_outputs(l_outputs.FIRST).VALUE;

Line 2003: ,p_param2_value => To_Char(Nvl(Ben_Ext_Thread.g_ext_rslt_id, -1))

1999: ,p_jurisdiction_code => NULL
2000: ,p_param1 => 'EXT_DFN_ID'
2001: ,p_param1_value => To_Char(Nvl(Ben_Ext_Thread.g_ext_dfn_id, -1))
2002: ,p_param2 => 'EXT_RSLT_ID'
2003: ,p_param2_value => To_Char(Nvl(Ben_Ext_Thread.g_ext_rslt_id, -1))
2004: );
2005: l_ff_value := l_outputs(l_outputs.FIRST).VALUE;
2006: BEGIN
2007: IF i.frmt_mask_lookup_cd IS NOT NULL AND

Line 5782: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id

5778: rcd.rcd_type_cd
5779: FROM ben_ext_rcd rcd
5780: ,ben_ext_rcd_in_file rin
5781: ,ben_ext_dfn dfn
5782: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
5783: AND rin.ext_file_id = dfn.ext_file_id
5784: AND rin.ext_rcd_id = rcd.ext_rcd_id
5785: ORDER BY rin.seq_num;
5786:

Line 5899: l_ext_rslt_id := Ben_Ext_Thread.g_ext_rslt_id;

5895: BEGIN
5896:
5897: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
5898: i := p_business_group_id;
5899: l_ext_rslt_id := Ben_Ext_Thread.g_ext_rslt_id;
5900: l_ext_dfn_id := Ben_Ext_Thread.g_ext_dfn_id;
5901:
5902: IF NOT g_extract_params.EXISTS(i) THEN
5903: Hr_Utility.set_location('..Exract Params PL/SQL not populated ', 7);

Line 5900: l_ext_dfn_id := Ben_Ext_Thread.g_ext_dfn_id;

5896:
5897: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
5898: i := p_business_group_id;
5899: l_ext_rslt_id := Ben_Ext_Thread.g_ext_rslt_id;
5900: l_ext_dfn_id := Ben_Ext_Thread.g_ext_dfn_id;
5901:
5902: IF NOT g_extract_params.EXISTS(i) THEN
5903: Hr_Utility.set_location('..Exract Params PL/SQL not populated ', 7);
5904: -- Get the extract type, Changes extract or Full Profile

Line 6384: Ben_Ext_Thread.g_err_num := p_error_NUMBER;

6380: Nvl(Ben_Ext_Person.g_elmt_name
6381: ,Ben_Ext_Fmt.g_elmt_name)||'. '||
6382: p_error_text;
6383: ELSE
6384: Ben_Ext_Thread.g_err_num := p_error_NUMBER;
6385: Ben_Ext_Thread.g_err_name := p_error_text;
6386: l_error_text :=
6387: Ben_Ext_Fmt.get_error_msg(To_Number(Substr(p_error_text, 5, 5)),
6388: p_error_text,Nvl(Ben_Ext_Person.g_elmt_name,Ben_Ext_Fmt.g_elmt_name) );

Line 6385: Ben_Ext_Thread.g_err_name := p_error_text;

6381: ,Ben_Ext_Fmt.g_elmt_name)||'. '||
6382: p_error_text;
6383: ELSE
6384: Ben_Ext_Thread.g_err_num := p_error_NUMBER;
6385: Ben_Ext_Thread.g_err_name := p_error_text;
6386: l_error_text :=
6387: Ben_Ext_Fmt.get_error_msg(To_Number(Substr(p_error_text, 5, 5)),
6388: p_error_text,Nvl(Ben_Ext_Person.g_elmt_name,Ben_Ext_Fmt.g_elmt_name) );
6389:

Line 6440: l_ext_rslt_id := Ben_Ext_Thread.g_ext_rslt_id;

6436: l_ext_rslt_id Number;
6437:
6438: BEGIN
6439:
6440: l_ext_rslt_id := Ben_Ext_Thread.g_ext_rslt_id;
6441: RETURN l_ext_rslt_id;
6442:
6443: EXCEPTION
6444: WHEN e_extract_process_not_running THEN

Line 12782: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

12778: CLOSE c_get_rcd_id;
12779:
12780: --first fetch the data from the result detail record
12781: OPEN csr_rslt_dtl(c_person_id => g_person_id
12782: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
12783: ,c_ext_dtl_rcd_id => l_rcd_id
12784: );
12785:
12786: FETCH csr_rslt_dtl INTO l_main_rec;

Line 12916: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

12912: FETCH c_get_rcd_id INTO l_rcd_id;
12913: CLOSE c_get_rcd_id;
12914:
12915: OPEN csr_rslt_dtl(c_person_id => g_person_id
12916: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
12917: ,c_ext_dtl_rcd_id => l_rcd_id);
12918: FETCH csr_rslt_dtl INTO l_main_rec;
12919: CLOSE csr_rslt_dtl;
12920:

Line 13101: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

13097: FETCH c_get_rcd_id INTO l_rcd_id;
13098: CLOSE c_get_rcd_id;
13099:
13100: OPEN csr_rslt_dtl(c_person_id => g_person_id
13101: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
13102: ,c_ext_dtl_rcd_id => l_rcd_id);
13103: FETCH csr_rslt_dtl INTO l_main_rec;
13104: CLOSE csr_rslt_dtl;
13105:

Line 13224: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

13220: FETCH c_get_rcd_id INTO l_rcd_id;
13221: CLOSE c_get_rcd_id;
13222:
13223: OPEN csr_rslt_dtl(c_person_id => g_person_id
13224: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
13225: ,c_ext_dtl_rcd_id => l_rcd_id
13226: );
13227: FETCH csr_rslt_dtl INTO l_main_rec;
13228: CLOSE csr_rslt_dtl;

Line 13296: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

13292: FETCH c_get_rcd_id INTO l_rcd_id;
13293: CLOSE c_get_rcd_id;
13294:
13295: OPEN csr_rslt_dtl(c_person_id => g_person_id
13296: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
13297: ,c_ext_dtl_rcd_id => l_rcd_id
13298: );
13299:
13300: FETCH csr_rslt_dtl INTO l_main_rec;

Line 13434: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

13430: CLOSE c_get_rcd_id;
13431:
13432: --first fetch the data from the result detail record
13433: OPEN csr_rslt_dtl(c_person_id => g_person_id
13434: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
13435: ,c_ext_dtl_rcd_id => l_rcd_id
13436: );
13437:
13438: FETCH csr_rslt_dtl INTO l_main_rec;

Line 13500: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

13496: FETCH c_get_rcd_id INTO l_rcd_id;
13497: CLOSE c_get_rcd_id;
13498:
13499: OPEN csr_rslt_dtl(c_person_id => g_person_id
13500: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
13501: ,c_ext_dtl_rcd_id => l_rcd_id
13502: );
13503: FETCH csr_rslt_dtl INTO l_main_rec;
13504: CLOSE csr_rslt_dtl;

Line 13561: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

13557: CLOSE c_get_rcd_id;
13558:
13559: --first fetch the data from the result detail record
13560: OPEN csr_rslt_dtl(c_person_id => g_person_id
13561: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
13562: ,c_ext_dtl_rcd_id => l_rcd_id
13563: );
13564:
13565: FETCH csr_rslt_dtl INTO l_main_rec;

Line 13636: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

13632: FETCH c_get_rcd_id INTO l_rcd_id;
13633: CLOSE c_get_rcd_id;
13634:
13635: OPEN csr_rslt_dtl(c_person_id => g_person_id
13636: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
13637: ,c_ext_dtl_rcd_id => l_rcd_id
13638: );
13639: FETCH csr_rslt_dtl INTO l_main_rec;
13640: CLOSE csr_rslt_dtl;

Line 13674: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

13670: FETCH c_get_rcd_id INTO l_rcd_id;
13671: CLOSE c_get_rcd_id;
13672:
13673: OPEN csr_rslt_dtl(c_person_id => g_person_id
13674: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
13675: ,c_ext_dtl_rcd_id => l_rcd_id
13676: );
13677: FETCH csr_rslt_dtl INTO l_main_rec;
13678: CLOSE csr_rslt_dtl;

Line 14764: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

14760: '21','22','30','31','40','41','41h') THEN
14761: l_record_num := g_ext_rcds(l_ext_rcd_id).record_number;
14762: OPEN csr_rslt_dtl
14763: (c_person_id => p_person_id
14764: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
14765: ,c_ext_dtl_rcd_id => l_ext_rcd_id
14766: );
14767: FETCH csr_rslt_dtl INTO l_main_rec;
14768:

Line 14777: l_main_rec.ext_rslt_id := ben_ext_thread.g_ext_rslt_id;

14773: FETCH cur_per_info INTO l_national_ident,l_last_name,l_prefix,l_dob;
14774: CLOSE cur_per_info;
14775:
14776: l_main_rec := NULL;
14777: l_main_rec.ext_rslt_id := ben_ext_thread.g_ext_rslt_id;
14778: l_main_rec.business_group_id := p_business_group_id;
14779: l_main_rec.ext_rcd_id := l_ext_rcd_id;
14780: l_main_rec.person_id := p_person_id;
14781: l_main_rec.val_01 := l_record_num;

Line 14931: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

14927: -- Loop through each detail record for the extract
14928: LOOP
14929: OPEN csr_rslt_dtl
14930: (c_person_id => l_person_id
14931: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
14932: ,c_ext_dtl_rcd_id => csr_rcd_rec.ext_rcd_id
14933: );
14934: FETCH csr_rslt_dtl INTO l_main_rec;
14935: WHILE csr_rslt_dtl%FOUND

Line 14955: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

14951: -- Loop through each detail record for the extract
14952: LOOP
14953: OPEN csr_rslt_dtl
14954: (c_person_id => l_person_id
14955: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
14956: ,c_ext_dtl_rcd_id => csr_rcd_rec.ext_rcd_id
14957: );
14958: FETCH csr_rslt_dtl INTO l_main_rec;
14959: WHILE csr_rslt_dtl%FOUND

Line 16621: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id

16617: ,c_recordid_2 IN NUMBER
16618: ,c_emr_id IN NUMBER ) IS
16619: SELECT Count(dtl.ext_rslt_dtl_id)
16620: FROM ben_ext_rslt_dtl dtl
16621: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id
16622: AND ext_rcd_id NOT IN(c_recordid_1,c_recordid_2)
16623: AND val_25 = c_emr_id;
16624:
16625: l_proc_name VARCHAR2(150) := g_proc_name ||'.Get_All_Records_Count';

Line 16663: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

16659: ,c_recordid_3 IN Number
16660: ,c_emr_id IN Number ) IS
16661: SELECT Count(dtl.ext_rslt_dtl_id)
16662: FROM ben_ext_rslt_dtl dtl
16663: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
16664: AND ext_rcd_id IN(c_recordid_1,c_recordid_2,c_recordid_3)
16665: AND val_25=c_emr_id;
16666:
16667: l_proc_name Varchar2(150) := g_proc_name ||'.Get_Trailer_Record_Count';

Line 16746: WHERE ext_rslt_id=Ben_Ext_Thread.g_ext_rslt_id

16742: -- Cursor to get the person existence flag
16743: CURSOR csr_get_person_exist(c_org_id IN Number) IS
16744: SELECT 'x'
16745: FROM ben_ext_rslt_dtl
16746: WHERE ext_rslt_id=Ben_Ext_Thread.g_ext_rslt_id
16747: AND val_25=c_org_id;
16748:
16749: --
16750: -- Cursor to get the record id for Rec 05

Line 16757: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id

16753: SELECT rcd.ext_rcd_id,rin.seq_num
16754: FROM ben_ext_rcd rcd
16755: ,ben_ext_rcd_in_file rin
16756: ,ben_ext_dfn dfn
16757: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id
16758: AND rin.ext_file_id = dfn.ext_file_id
16759: AND rin.ext_rcd_id = rcd.ext_rcd_id
16760: AND rin.seq_num = 5;
16761:

Line 16768: WHERE ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

16764: --
16765: CURSOR csr_rec05_del (p_ext_rcd_id IN NUMBER) IS
16766: SELECT ext_rslt_dtl_id
16767: FROM ben_ext_rslt_dtl
16768: WHERE ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
16769: AND ext_rcd_id = p_ext_rcd_id
16770: AND val_05 = '00000000'
16771: AND val_06 = '00000000'
16772: AND val_07 = '00000000'

Line 16887: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

16883: LOOP
16884: -- Delete all detail records for the record
16885: DELETE ben_ext_rslt_dtl
16886: WHERE ext_rcd_id = csr_rcd_rec.ext_rcd_id
16887: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
16888: AND business_group_id = p_business_group_id;
16889: END LOOP; -- FOR csr_rcd_rec
16890:
16891: --

Line 16906: (c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id )

16902:
16903: -- All orgs,fill up the temp. table with the org ids in order of
16904: --the sort value
16905: FOR val IN csr_get_rslt1
16906: (c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id )
16907: LOOP
16908: hr_utility.set_location('val 26 : '||val.val_26,10);
16909: IF g_org_list.EXISTS(val.val_25) THEN
16910: IF NOT g_ord_details1.EXISTS(val.val_25) THEN

Line 16936: OPEN csr_get_trailer_rslt(c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

16932: --create our own trailer records for each org based on these
16933: FOR csr_rcd_rec IN csr_ext_rcd_id(c_hide_flag => 'N'
16934: ,c_rcd_type_cd => 'T')-- T-Trailer
16935: LOOP
16936: OPEN csr_get_trailer_rslt(c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
16937: ,c_ext_dtl_rcd_id => csr_rcd_rec.ext_rcd_id);
16938: FETCH csr_get_trailer_rslt INTO l_trailer_main_rec;
16939: CLOSE csr_get_trailer_rslt;
16940: IF g_rcd_dtls(94).ext_rcd_id = csr_rcd_rec.ext_rcd_id THEN

Line 16959: OPEN csr_get_header_rslt(c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

16955: --header record created by benefits needs to be deleted later
16956: FOR csr_rcd_rec IN csr_ext_rcd_id(c_hide_flag => 'N'
16957: ,c_rcd_type_cd => 'H')-- H-Header
16958: LOOP
16959: OPEN csr_get_header_rslt(c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
16960: ,c_ext_dtl_rcd_id => csr_rcd_rec.ext_rcd_id);
16961: FETCH csr_get_header_rslt INTO l_header_main_rec;
16962: CLOSE csr_get_header_rslt;
16963: IF g_rcd_dtls(00).ext_rcd_id = csr_rcd_rec.ext_rcd_id THEN

Line 16979: OPEN csr_get_header_rslt(c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

16975: --Loop through Header records
16976: FOR csr_rcd_rec IN csr_ext_rcd_id(c_hide_flag => 'N'
16977: ,c_rcd_type_cd => 'H')-- H-Header
16978: LOOP
16979: OPEN csr_get_header_rslt(c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
16980: ,c_ext_dtl_rcd_id => csr_rcd_rec.ext_rcd_id);
16981: FETCH csr_get_header_rslt INTO l_header_main_rec;
16982: CLOSE csr_get_header_rslt;
16983: l_header_new_rec := l_header_main_rec;

Line 17041: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id )

17037:
17038: /* --9278285 Cursor Modified, picking all employee records in correct order and storing.
17039: FOR val IN csr_get_rslt
17040: (c_org_id => g_employer_child_list(l_group_org_index).gre_org_id
17041: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id )
17042: */
17043: --9278285
17044: FOR val IN csr_get_rslt
17045: (c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id )

Line 17045: (c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id )

17041: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id )
17042: */
17043: --9278285
17044: FOR val IN csr_get_rslt
17045: (c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id )
17046: --9278285
17047: LOOP
17048: --Hr_Utility.set_location('val'||val.EXT_RSLT_DTL_ID ,26);
17049: -- Get the individual row using sortid key

Line 17053: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

17049: -- Get the individual row using sortid key
17050: -- So we will get only one record related data per person
17051: FOR ind_dtl IN csr_rslt_dtl_sort
17052: (c_val_26 => val.val_26
17053: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
17054: )
17055: LOOP
17056: l_main_rec := ind_dtl;
17057: l_main_rec.object_version_NUMBER := Nvl(l_main_rec.object_version_NUMBER,0) + 1;

Line 17269: OPEN csr_get_trailer_rslt(c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id

17265: FOR csr_rcd_rec IN csr_ext_rcd_id(c_hide_flag => 'N'
17266: ,c_rcd_type_cd => 'T')-- T-Trailer
17267: LOOP
17268: l_insert_trailer := 1;
17269: OPEN csr_get_trailer_rslt(c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
17270: ,c_ext_dtl_rcd_id => csr_rcd_rec.ext_rcd_id);
17271: FETCH csr_get_trailer_rslt INTO l_trailer_main_rec;
17272: CLOSE csr_get_trailer_rslt;
17273: l_trailer_new_rec := l_trailer_main_rec;

Line 17449: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

17445: END IF;
17446:
17447: DELETE
17448: FROM ben_ext_rslt_dtl dtl
17449: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
17450: AND dtl.ext_rcd_id = csr_rcd_rec.ext_rcd_id
17451: AND dtl.ext_rslt_dtl_id = l_ext_rslt_dtl_id
17452: AND business_group_id = p_business_group_id;
17453:

Line 17465: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

17461: END IF;
17462:
17463: DELETE
17464: FROM ben_ext_rslt_dtl dtl
17465: WHERE dtl.ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id
17466: AND dtl.ext_rcd_id = csr_rcd_rec.ext_rcd_id
17467: AND dtl.ext_rslt_dtl_id = l_ext_rslt_dtl_id
17468: AND business_group_id = p_business_group_id;
17469:

Line 17493: WHERE EXT_RSLT_ID = Ben_Ext_Thread.g_ext_rslt_id

17489: VAL_08 = translate(VAL_08,l_SOURCE,l_DEST),
17490: VAL_09 = translate(VAL_09,l_SOURCE,l_DEST),
17491: VAL_12 = translate(VAL_12,l_SOURCE,l_DEST),
17492: VAL_13 = translate(VAL_13,l_SOURCE,l_DEST)
17493: WHERE EXT_RSLT_ID = Ben_Ext_Thread.g_ext_rslt_id
17494: AND VAL_01 = '02'
17495: AND BUSINESS_GROUP_ID = p_business_group_id;
17496:
17497: UPDATE ben_ext_rslt_dtl

Line 17502: WHERE EXT_RSLT_ID = Ben_Ext_Thread.g_ext_rslt_id

17498: SET VAL_07 = translate(VAL_07,l_SOURCE,l_DEST),
17499: VAL_11 = translate(VAL_11,l_SOURCE,l_DEST),
17500: VAL_13 = translate(VAL_13,l_SOURCE,l_DEST),
17501: VAL_14 = translate(VAL_14,l_SOURCE,l_DEST)
17502: WHERE EXT_RSLT_ID = Ben_Ext_Thread.g_ext_rslt_id
17503: AND VAL_01 = '04'
17504: AND BUSINESS_GROUP_ID = p_business_group_id;
17505:
17506: END IF;