DBA Data[Home] [Help]

APPS.PO_UDA_IMPORT_PKG dependencies on PO_TBL_NUMBER

Line 644: l_attr_group_table PO_TBL_NUMBER;

640: )
641: IS
642: d_progress NUMBER := 0;
643: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;
644: l_attr_group_table PO_TBL_NUMBER;
645: l_context_object_index NUMBER;
646: l_attr_group_id_index NUMBER;
647: l_pk_col_index NUMBER;
648: l_attr_group_id NUMBER;

Line 715: l_attr_group_table := PO_TBL_NUMBER();

711: PO_UDA_DEFAULTING_PKG.DEBUG('x_attributes_row_table is as follows', d_progress);
712: PO_UDA_DEFAULTING_PKG.DEBUG(x_attributes_row_table, d_progress);
713: d_progress := 20;
714:
715: l_attr_group_table := PO_TBL_NUMBER();
716: d_progress := 30;
717: IF (x_po_uda_usage_object_array IS NOT NULL AND x_po_uda_usage_object_array.COUNT > 0) THEN
718: d_progress := 40;
719: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array.COUNT :' || x_po_uda_usage_object_array.COUNT, d_progress);

Line 2210: l_uda_pk1_tbl po_tbl_number ;

2206:
2207: d_api_name VARCHAR2(50) := 'TRANSFER_UDA_DATA';
2208: d_pkg_name CONSTANT VARCHAR2(30) := PO_LOG.get_package_base('PO_UDA_IMPORT_PKG');
2209: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2210: l_uda_pk1_tbl po_tbl_number ;
2211: l_uda_pk2_tbl po_tbl_number ;
2212: l_attr_group_type_tbl po_tbl_varchar40 ;
2213: l_attr_group_id_tbl po_tbl_number;
2214: l_po_lines_tbl po_tbl_number;

Line 2211: l_uda_pk2_tbl po_tbl_number ;

2207: d_api_name VARCHAR2(50) := 'TRANSFER_UDA_DATA';
2208: d_pkg_name CONSTANT VARCHAR2(30) := PO_LOG.get_package_base('PO_UDA_IMPORT_PKG');
2209: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2210: l_uda_pk1_tbl po_tbl_number ;
2211: l_uda_pk2_tbl po_tbl_number ;
2212: l_attr_group_type_tbl po_tbl_varchar40 ;
2213: l_attr_group_id_tbl po_tbl_number;
2214: l_po_lines_tbl po_tbl_number;
2215: l_template_id_tbl po_tbl_number;

Line 2213: l_attr_group_id_tbl po_tbl_number;

2209: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2210: l_uda_pk1_tbl po_tbl_number ;
2211: l_uda_pk2_tbl po_tbl_number ;
2212: l_attr_group_type_tbl po_tbl_varchar40 ;
2213: l_attr_group_id_tbl po_tbl_number;
2214: l_po_lines_tbl po_tbl_number;
2215: l_template_id_tbl po_tbl_number;
2216: l_draft_id_tbl po_tbl_number;
2217: x_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;

Line 2214: l_po_lines_tbl po_tbl_number;

2210: l_uda_pk1_tbl po_tbl_number ;
2211: l_uda_pk2_tbl po_tbl_number ;
2212: l_attr_group_type_tbl po_tbl_varchar40 ;
2213: l_attr_group_id_tbl po_tbl_number;
2214: l_po_lines_tbl po_tbl_number;
2215: l_template_id_tbl po_tbl_number;
2216: l_draft_id_tbl po_tbl_number;
2217: x_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;
2218: x_external_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;-- := new EGO_COL_NAME_VALUE_PAIR_TABLE();

Line 2215: l_template_id_tbl po_tbl_number;

2211: l_uda_pk2_tbl po_tbl_number ;
2212: l_attr_group_type_tbl po_tbl_varchar40 ;
2213: l_attr_group_id_tbl po_tbl_number;
2214: l_po_lines_tbl po_tbl_number;
2215: l_template_id_tbl po_tbl_number;
2216: l_draft_id_tbl po_tbl_number;
2217: x_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;
2218: x_external_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;-- := new EGO_COL_NAME_VALUE_PAIR_TABLE();
2219: x_return_status VARCHAR2(100) := null;

Line 2216: l_draft_id_tbl po_tbl_number;

2212: l_attr_group_type_tbl po_tbl_varchar40 ;
2213: l_attr_group_id_tbl po_tbl_number;
2214: l_po_lines_tbl po_tbl_number;
2215: l_template_id_tbl po_tbl_number;
2216: l_draft_id_tbl po_tbl_number;
2217: x_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;
2218: x_external_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;-- := new EGO_COL_NAME_VALUE_PAIR_TABLE();
2219: x_return_status VARCHAR2(100) := null;
2220: x_msg_data VARCHAR2(100) := null;

Line 3356: l_pk1_value_tbl po_tbl_number;

3352:
3353: l_is_valid VARCHAR2(1) :='Y';
3354: l_attr_grp_name_tbl po_tbl_varchar100;
3355: l_attr_group_typ_tbl po_tbl_varchar30;
3356: l_pk1_value_tbl po_tbl_number;
3357: d_api_name CONSTANT VARCHAR2(30) := 'validate_uda_req_attributes';
3358: d_pkg_name CONSTANT VARCHAR2(30) := PO_LOG.get_package_base('PO_UDA_IMPORT_PKG');
3359: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name || '.';
3360: d_position NUMBER;