APPS.EGO_ITEM_BULKLOAD_PKG dependencies on EGO_VARCHAR_TBL_TYPE

Line 842: x_item_num_tbl IN OUT NOCOPY EGO_VARCHAR_TBL_TYPE) IS

838: ------------------------------------------------------------------------------
839: PROCEDURE Get_Seq_Gen_Item_Nums(p_resultfmt_usage_id IN NUMBER,
840: p_item_catalog_group_id IN NUMBER,
841: p_item_num_colname IN VARCHAR2,
842: x_item_num_tbl IN OUT NOCOPY EGO_VARCHAR_TBL_TYPE) IS
843:
844:
845: --------------------------------------------------------------------
846: --Fetch the Org IDs in EBI, for which Item Number column is NULL

Line 865: l_item_num_tbl EGO_VARCHAR_TBL_TYPE;

861: l_org_id_cursor INTEGER;
862: l_org_id_exec INTEGER;
863: l_org_id_rows_cnt NUMBER;
864:
865: l_item_num_tbl EGO_VARCHAR_TBL_TYPE;
866: l_exists VARCHAR2(1);
867: l_can_itemnum_gen BOOLEAN;
868: l_itemgen_rownum NUMBER;
869: l_new_itemgen_sql VARCHAR2(1000);

Line 1224: -- l_gen_item_num_tbl EGO_VARCHAR_TBL_TYPE;

1220:
1221: ---------------------------------------------------------------------
1222: -- This is to store the Sequence Generated Item Numbers.
1223: ---------------------------------------------------------------------
1224: -- l_gen_item_num_tbl EGO_VARCHAR_TBL_TYPE;
1225: -- l_gen_itemnum_indx NUMBER;
1226:
1227: l_temp NUMBER(10) := 1;
1228: l_count NUMBER := 0;

Line 7153: l_ss_ref_table EGO_VARCHAR_TBL_TYPE;

7149: l_cc_id_table num_tbl_type;
7150: l_trans_id_table num_tbl_type;
7151: l_org_id_table DBMS_SQL.VARCHAR2_TABLE;
7152: l_ss_id_table num_tbl_type;
7153: l_ss_ref_table EGO_VARCHAR_TBL_TYPE;
7154: l_item_num_table EGO_VARCHAR_TBL_TYPE;
7155: l_old_item_num_table EGO_VARCHAR_TBL_TYPE; --Added R12C
7156: l_sql VARCHAR2(10000);
7157: l_cc_rows_processed NUMBER;

Line 7154: l_item_num_table EGO_VARCHAR_TBL_TYPE;

7150: l_trans_id_table num_tbl_type;
7151: l_org_id_table DBMS_SQL.VARCHAR2_TABLE;
7152: l_ss_id_table num_tbl_type;
7153: l_ss_ref_table EGO_VARCHAR_TBL_TYPE;
7154: l_item_num_table EGO_VARCHAR_TBL_TYPE;
7155: l_old_item_num_table EGO_VARCHAR_TBL_TYPE; --Added R12C
7156: l_sql VARCHAR2(10000);
7157: l_cc_rows_processed NUMBER;
7158: l_item_rows_processed NUMBER;

Line 7155: l_old_item_num_table EGO_VARCHAR_TBL_TYPE; --Added R12C

7151: l_org_id_table DBMS_SQL.VARCHAR2_TABLE;
7152: l_ss_id_table num_tbl_type;
7153: l_ss_ref_table EGO_VARCHAR_TBL_TYPE;
7154: l_item_num_table EGO_VARCHAR_TBL_TYPE;
7155: l_old_item_num_table EGO_VARCHAR_TBL_TYPE; --Added R12C
7156: l_sql VARCHAR2(10000);
7157: l_cc_rows_processed NUMBER;
7158: l_item_rows_processed NUMBER;
7159: l_xset_id NUMBER;