456: -- p_data_level IN VARCHAR2,
457: -- p_mod_value VARCHAR2
458: --IN OUT:
459: --OUT:
460: --p_attr_display_name po_tbl_varchar100
461: --Notes:
462: --Testing:
463: --End of Comments
464: ------------------------------------------------------------------------
607: -- p_par_draft_id NUMBER,
608: -- p_po_header_id NUMBER,
609: --IN OUT:
610: --OUT:
611: --p_attr_display_name po_tbl_varchar100
612: --Notes:
613: --Testing:
614: --End of Comments
615: ------------------------------------------------------------------------
619: (
620: p_attr_group_type IN VARCHAR2,
621: p_par_draft_id NUMBER,
622: p_po_header_id NUMBER,
623: p_attr_display_name OUT NOCOPY po_tbl_varchar100) IS
624:
625: d_api_name CONSTANT VARCHAR2(30) := 'form_attr_display_name';
626: d_module CONSTANT VARCHAR2(100) := g_pkg_name || d_api_name || '.';
627: d_position NUMBER ;
685: d_api_name CONSTANT VARCHAR2(30) := 'POPULATE_UDA_DATA_IN_INTERFACE';
686: d_module CONSTANT VARCHAR2(100) := g_pkg_name || d_api_name || '.';
687: d_position NUMBER ;
688:
689: l_attr_grp_tbl po_tbl_varchar100;
690: l_distinct_attr_grp_name_tbl po_tbl_varchar100;
691: l_attr_name_tbl po_tbl_varchar100;
692: l_mod_value_tbl po_tbl_varchar4000;
693: l_data_level VARCHAR2(150);
686: d_module CONSTANT VARCHAR2(100) := g_pkg_name || d_api_name || '.';
687: d_position NUMBER ;
688:
689: l_attr_grp_tbl po_tbl_varchar100;
690: l_distinct_attr_grp_name_tbl po_tbl_varchar100;
691: l_attr_name_tbl po_tbl_varchar100;
692: l_mod_value_tbl po_tbl_varchar4000;
693: l_data_level VARCHAR2(150);
694: l_attr_value_num NUMBER;
687: d_position NUMBER ;
688:
689: l_attr_grp_tbl po_tbl_varchar100;
690: l_distinct_attr_grp_name_tbl po_tbl_varchar100;
691: l_attr_name_tbl po_tbl_varchar100;
692: l_mod_value_tbl po_tbl_varchar4000;
693: l_data_level VARCHAR2(150);
694: l_attr_value_num NUMBER;
695: l_attr_group_type VARCHAR2(40);
700: l_data_type_code VARCHAR2(30);
701: l_attr_value_str VARCHAR2(1000);
702: l_attr_value_date DATE;
703: l_process_status NUMBER := 1;
704: l_address_type_tbl po_tbl_varchar100 ;
705: l_row_identifier_add NUMBER;
706: l_value_set VARCHAR2(60);
707: l_attr_grp_name VARCHAR2(60);
708: l_row_identifier NUMBER;