DBA Data[Home] [Help]

APPS.BEN_EXT_XML_WRITE dependencies on BEN_EXT_DATA_ELMT

Line 1559: from ben_ext_data_elmt_in_rcd rcd ,

1555: elm.data_elmt_typ_cd,
1556: elm.max_length_num,
1557: elm.frmt_mask_cd,
1558: elm.just_cd
1559: from ben_ext_data_elmt_in_rcd rcd ,
1560: ben_ext_data_elmt elm
1561: where rcd.ext_rcd_id = c_ext_rcd_id
1562: and elm.ext_data_elmt_id = rcd.ext_data_elmt_id
1563: and nvl(rcd.hide_flag,'N') = 'N'

Line 1560: ben_ext_data_elmt elm

1556: elm.max_length_num,
1557: elm.frmt_mask_cd,
1558: elm.just_cd
1559: from ben_ext_data_elmt_in_rcd rcd ,
1560: ben_ext_data_elmt elm
1561: where rcd.ext_rcd_id = c_ext_rcd_id
1562: and elm.ext_data_elmt_id = rcd.ext_data_elmt_id
1563: and nvl(rcd.hide_flag,'N') = 'N'
1564: order by rcd.seq_num;

Line 1574: l_elm_xml_tag_name ben_ext_data_elmt.xml_tag_name%type ;

1570: where lookup_type = 'BEN_EXT_XML_TAGS' ;
1571:
1572:
1573:
1574: l_elm_xml_tag_name ben_ext_data_elmt.xml_tag_name%type ;
1575: l_elm_name ben_ext_data_elmt.name%type ;
1576: l_elmt_seq_num ben_ext_data_elmt_in_rcd.seq_num%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 ;

Line 1575: l_elm_name ben_ext_data_elmt.name%type ;

1571:
1572:
1573:
1574: l_elm_xml_tag_name ben_ext_data_elmt.xml_tag_name%type ;
1575: l_elm_name ben_ext_data_elmt.name%type ;
1576: l_elmt_seq_num ben_ext_data_elmt_in_rcd.seq_num%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 ;

Line 1576: l_elmt_seq_num ben_ext_data_elmt_in_rcd.seq_num%type ;

1572:
1573:
1574: l_elm_xml_tag_name ben_ext_data_elmt.xml_tag_name%type ;
1575: l_elm_name ben_ext_data_elmt.name%type ;
1576: l_elmt_seq_num ben_ext_data_elmt_in_rcd.seq_num%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 ;

Line 1577: l_elm_typ_cd ben_ext_data_elmt.data_elmt_typ_cd%type ;

1573:
1574: l_elm_xml_tag_name ben_ext_data_elmt.xml_tag_name%type ;
1575: l_elm_name ben_ext_data_elmt.name%type ;
1576: l_elmt_seq_num ben_ext_data_elmt_in_rcd.seq_num%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 ;

Line 1578: l_elm_max_length ben_ext_data_elmt.max_length_num%type ;

1574: l_elm_xml_tag_name ben_ext_data_elmt.xml_tag_name%type ;
1575: l_elm_name ben_ext_data_elmt.name%type ;
1576: l_elmt_seq_num ben_ext_data_elmt_in_rcd.seq_num%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 ;

Line 1579: l_elm_frmt_mask ben_ext_data_elmt.frmt_mask_cd%type ;

1575: l_elm_name ben_ext_data_elmt.name%type ;
1576: l_elmt_seq_num ben_ext_data_elmt_in_rcd.seq_num%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 ;

Line 1580: l_elm_just_cd ben_ext_data_elmt.just_cd%type ;

1576: l_elmt_seq_num ben_ext_data_elmt_in_rcd.seq_num%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 ;

Line 1587: l_elmt_defa_tag ben_ext_data_elmt.xml_tag_name%type ;

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 ;
1589: l_rcdset_defa_tag ben_ext_data_elmt.xml_tag_name%type ;
1590: l_file_defa_tag ben_ext_data_elmt.xml_tag_name%type ;
1591: l_dfn_defa_tag ben_ext_data_elmt.xml_tag_name%type ;

Line 1588: l_rcd_defa_tag ben_ext_data_elmt.xml_tag_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 ;
1589: l_rcdset_defa_tag ben_ext_data_elmt.xml_tag_name%type ;
1590: l_file_defa_tag ben_ext_data_elmt.xml_tag_name%type ;
1591: l_dfn_defa_tag ben_ext_data_elmt.xml_tag_name%type ;
1592: l_xdo_template_id number ;

Line 1589: l_rcdset_defa_tag ben_ext_data_elmt.xml_tag_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 ;
1589: l_rcdset_defa_tag ben_ext_data_elmt.xml_tag_name%type ;
1590: l_file_defa_tag ben_ext_data_elmt.xml_tag_name%type ;
1591: l_dfn_defa_tag ben_ext_data_elmt.xml_tag_name%type ;
1592: l_xdo_template_id number ;
1593: l_cm_display_flag varchar2(30) ;

Line 1590: l_file_defa_tag ben_ext_data_elmt.xml_tag_name%type ;

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 ;
1589: l_rcdset_defa_tag ben_ext_data_elmt.xml_tag_name%type ;
1590: l_file_defa_tag ben_ext_data_elmt.xml_tag_name%type ;
1591: l_dfn_defa_tag ben_ext_data_elmt.xml_tag_name%type ;
1592: l_xdo_template_id number ;
1593: l_cm_display_flag varchar2(30) ;
1594: --

Line 1591: l_dfn_defa_tag ben_ext_data_elmt.xml_tag_name%type ;

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 ;
1589: l_rcdset_defa_tag ben_ext_data_elmt.xml_tag_name%type ;
1590: l_file_defa_tag ben_ext_data_elmt.xml_tag_name%type ;
1591: l_dfn_defa_tag ben_ext_data_elmt.xml_tag_name%type ;
1592: l_xdo_template_id number ;
1593: l_cm_display_flag varchar2(30) ;
1594: --
1595: l_old_person_id number := -1 ;