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.BEN_EXT_XML_WRITE dependencies on BEN_EXT_RSLT

Line 13: This process reads records from the ben_ext_rslt_dtl table and writes them

9: +==============================================================================+
10: Name:
11: Extract XML Write Process.
12: Purpose:
13: This process reads records from the ben_ext_rslt_dtl table and writes them
14: to a xml output file.
15: History:
16: Date Who Version What?
17: ---- --- ------- -----

Line 61: g_prev_grop_val ben_ext_rslt_dtl.group_val_01%type ;

57: g_rcd_tag_tbl BEN_EXT_XML_WRITE.g_table ;
58: g_elmt_tag_tbl BEN_EXT_XML_WRITE.g_table ;
59: g_low_lvl_tbl BEN_EXT_XML_WRITE.g_table ;
60: g_iana_char_set varchar2(500) ;
61: g_prev_grop_val ben_ext_rslt_dtl.group_val_01%type ;
62: --
63: -----------------------------------------------------------------------------
64:
65:

Line 231: l_output_name ben_ext_rslt.output_name%type ;

227: file_handle utl_file.file_type;
228: l_var varchar2(4000) ;
229: l_proc varchar2(72) := g_package||'write_style_sheet';
230: l_max_ext_line_size Number := 32767 ;
231: l_output_name ben_ext_rslt.output_name%type ;
232:
233: Begin
234: --
235: hr_Utility.set_location('Entering'||l_proc, 5);

Line 334: l_output_name ben_ext_rslt.output_name%type ;

330: file_handle utl_file.file_type;
331: l_var varchar2(4000) ;
332: l_proc varchar2(72) := g_package||'write_schema';
333: l_max_ext_line_size Number := 32767 ;
334: l_output_name ben_ext_rslt.output_name%type ;
335:
336: Begin
337: --
338: hr_Utility.set_location('Entering'||l_proc, 5);

Line 489: l_pdf_output_name ben_ext_rslt.output_name%type ;

485:
486: l_proc varchar2(72) := g_package||'write_xdo_pdf';
487:
488:
489: l_pdf_output_name ben_ext_rslt.output_name%type ;
490: l_input_name ben_ext_rslt.output_name%type ;
491: l_extn_name varchar2(50) ;
492: l_template_cd xdo_templates_b.template_code%type ;
493: l_application_id number ;

Line 490: l_input_name ben_ext_rslt.output_name%type ;

486: l_proc varchar2(72) := g_package||'write_xdo_pdf';
487:
488:
489: l_pdf_output_name ben_ext_rslt.output_name%type ;
490: l_input_name ben_ext_rslt.output_name%type ;
491: l_extn_name varchar2(50) ;
492: l_template_cd xdo_templates_b.template_code%type ;
493: l_application_id number ;
494: l_APPLICATION_SHORT_NAME xdo_templates_b.APPLICATION_SHORT_NAME%type ;

Line 1496: from ben_ext_rslt_dtl xrd,

1492: xrd.val_299,
1493: xrd.val_300,
1494: xrf.seq_num,
1495: xrd.group_val_01
1496: from ben_ext_rslt_dtl xrd,
1497: ben_ext_rslt xrs,
1498: ben_ext_dfn xdf,
1499: ben_ext_rcd_in_file xrf
1500: where xrd.ext_rslt_id = p_ext_rslt_id

Line 1497: ben_ext_rslt xrs,

1493: xrd.val_300,
1494: xrf.seq_num,
1495: xrd.group_val_01
1496: from ben_ext_rslt_dtl xrd,
1497: ben_ext_rslt xrs,
1498: ben_ext_dfn xdf,
1499: ben_ext_rcd_in_file xrf
1500: where xrd.ext_rslt_id = p_ext_rslt_id
1501: and xrd.ext_rslt_id = xrs.ext_rslt_id

Line 1527: ben_Ext_rslt xrs,

1523: xrs.run_end_dt,
1524: xfi.xml_tag_name file_xml_tag_name ,
1525: nvl( xrs.xdo_template_id, xdf.xdo_template_id ) xdo_template_id
1526: from ben_Ext_dfn xdf,
1527: ben_Ext_rslt xrs,
1528: ben_ext_file xfi
1529: where xrs.ext_rslt_id = p_ext_rslt_id
1530: and xrs.ext_dfn_id = xdf.ext_dfn_id
1531: and xdf.ext_file_id = xfi.ext_file_id ;

Line 1581: l_elm_val ben_ext_rslt_dtl.val_01%type ;

1577: l_elm_typ_cd ben_ext_data_elmt.data_elmt_typ_cd%type ;
1578: l_elm_max_length ben_ext_data_elmt.max_length_num%type ;
1579: l_elm_frmt_mask ben_ext_data_elmt.frmt_mask_cd%type ;
1580: l_elm_just_cd ben_ext_data_elmt.just_cd%type ;
1581: l_elm_val ben_ext_rslt_dtl.val_01%type ;
1582: l_rec_num number := 0 ;
1583: l_output_name ben_ext_rslt.output_name%type ;
1584: l_file_name ben_ext_rslt.output_name%type ;
1585: l_var varchar2(4000) ;

Line 1583: l_output_name ben_ext_rslt.output_name%type ;

1579: l_elm_frmt_mask ben_ext_data_elmt.frmt_mask_cd%type ;
1580: l_elm_just_cd ben_ext_data_elmt.just_cd%type ;
1581: l_elm_val ben_ext_rslt_dtl.val_01%type ;
1582: l_rec_num number := 0 ;
1583: l_output_name ben_ext_rslt.output_name%type ;
1584: l_file_name ben_ext_rslt.output_name%type ;
1585: l_var varchar2(4000) ;
1586: l_new_rec number := -1 ;
1587: l_elmt_defa_tag ben_ext_data_elmt.xml_tag_name%type ;

Line 1584: l_file_name ben_ext_rslt.output_name%type ;

1580: l_elm_just_cd ben_ext_data_elmt.just_cd%type ;
1581: l_elm_val ben_ext_rslt_dtl.val_01%type ;
1582: l_rec_num number := 0 ;
1583: l_output_name ben_ext_rslt.output_name%type ;
1584: l_file_name ben_ext_rslt.output_name%type ;
1585: l_var varchar2(4000) ;
1586: l_new_rec number := -1 ;
1587: l_elmt_defa_tag ben_ext_data_elmt.xml_tag_name%type ;
1588: l_rcd_defa_tag ben_ext_data_elmt.xml_tag_name%type ;

Line 1611: l_pdf_output_name ben_ext_rslt.output_name%type ;

1607: --
1608: l_proc varchar2(72) := g_package||'main';
1609: l_max_ext_line_size Number := 32767 ;
1610: -- pdf cahnges
1611: l_pdf_output_name ben_ext_rslt.output_name%type ;
1612: l_extn_name varchar2(50) ;
1613: l_prv_low_lvl_cd varchar2(5) ;
1614: l_low_lvl_name varchar2(250) ;
1615: l_low_lvl_cd varchar2(250) ;