APPS.EGO_ITEM_BULKLOAD_PKG dependencies on EGO_VARCHAR_TBL_TYPE

Line 805: x_item_num_tbl IN OUT NOCOPY EGO_VARCHAR_TBL_TYPE) IS

801: ------------------------------------------------------------------------------
802: PROCEDURE Get_Seq_Gen_Item_Nums(p_resultfmt_usage_id IN NUMBER,
803: p_item_catalog_group_id IN NUMBER,
804: p_item_num_colname IN VARCHAR2,
805: x_item_num_tbl IN OUT NOCOPY EGO_VARCHAR_TBL_TYPE) IS
806:
807:
808: --------------------------------------------------------------------
809: --Fetch the Org IDs in EBI, for which Item Number column is NULL

Line 828: l_item_num_tbl EGO_VARCHAR_TBL_TYPE;

824: l_org_id_cursor INTEGER;
825: l_org_id_exec INTEGER;
826: l_org_id_rows_cnt NUMBER;
827:
828: l_item_num_tbl EGO_VARCHAR_TBL_TYPE;
829: l_exists VARCHAR2(1);
830: l_can_itemnum_gen BOOLEAN;
831: l_itemgen_rownum NUMBER;
832: l_new_itemgen_sql VARCHAR2(1000);

Line 1186: -- l_gen_item_num_tbl EGO_VARCHAR_TBL_TYPE;

1182:
1183: ---------------------------------------------------------------------
1184: -- This is to store the Sequence Generated Item Numbers.
1185: ---------------------------------------------------------------------
1186: -- l_gen_item_num_tbl EGO_VARCHAR_TBL_TYPE;
1187: -- l_gen_itemnum_indx NUMBER;
1188:
1189: l_temp NUMBER(10) := 1;
1190: l_count NUMBER := 0;

Line 7000: l_ss_ref_table EGO_VARCHAR_TBL_TYPE;

6996: l_cc_id_table num_tbl_type;
6997: l_trans_id_table num_tbl_type;
6998: l_org_id_table DBMS_SQL.VARCHAR2_TABLE;
6999: l_ss_id_table num_tbl_type;
7000: l_ss_ref_table EGO_VARCHAR_TBL_TYPE;
7001: l_item_num_table EGO_VARCHAR_TBL_TYPE;
7002: l_old_item_num_table EGO_VARCHAR_TBL_TYPE; --Added R12C
7003: l_sql VARCHAR2(10000);
7004: l_cc_rows_processed NUMBER;

Line 7001: l_item_num_table EGO_VARCHAR_TBL_TYPE;

6997: l_trans_id_table num_tbl_type;
6998: l_org_id_table DBMS_SQL.VARCHAR2_TABLE;
6999: l_ss_id_table num_tbl_type;
7000: l_ss_ref_table EGO_VARCHAR_TBL_TYPE;
7001: l_item_num_table EGO_VARCHAR_TBL_TYPE;
7002: l_old_item_num_table EGO_VARCHAR_TBL_TYPE; --Added R12C
7003: l_sql VARCHAR2(10000);
7004: l_cc_rows_processed NUMBER;
7005: l_item_rows_processed NUMBER;

Line 7002: l_old_item_num_table EGO_VARCHAR_TBL_TYPE; --Added R12C

6998: l_org_id_table DBMS_SQL.VARCHAR2_TABLE;
6999: l_ss_id_table num_tbl_type;
7000: l_ss_ref_table EGO_VARCHAR_TBL_TYPE;
7001: l_item_num_table EGO_VARCHAR_TBL_TYPE;
7002: l_old_item_num_table EGO_VARCHAR_TBL_TYPE; --Added R12C
7003: l_sql VARCHAR2(10000);
7004: l_cc_rows_processed NUMBER;
7005: l_item_rows_processed NUMBER;
7006: l_xset_id NUMBER;