[Home] [Help]
48: gIHRfqRequiredFlagTbl DBMS_SQL.VARCHAR2_TABLE;
49: gIHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;
50: gIHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;
51: --Bug6599217
52: gIHLongDescriptionTbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;
53: gIHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
54: gIHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
55: gIHOrderTypeLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
56: gIHSupplierTbl DBMS_SQL.VARCHAR2_TABLE;
105: gUHRfqRequiredFlagTbl DBMS_SQL.VARCHAR2_TABLE;
106: gUHNegotiatedByPreparerFlagTbl DBMS_SQL.VARCHAR2_TABLE;
107: gUHDescriptionTbl DBMS_SQL.VARCHAR2_TABLE;
108: --Bug6599217
109: gUHLongDescriptionTbl ICX_CAT_POPULATE_MI_PVT.VARCHAR4_TABLE;
110: gUHOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
111: gUHMasterOrganizationIdTbl DBMS_SQL.NUMBER_TABLE;
112:
113: gUHOrderTypeLookupCodeTbl DBMS_SQL.VARCHAR2_TABLE;
1984: -- For master items the description will be in the ctx index as part of sequence between 101 and 4999.
1985: -- i.e. in sequence 101
1986: -- There will not be any category attribute row between 5001 and 9999
1987: -- ICX_CAT_UTIL_PVT.g_ItemCatgChange_const will be set to true only from master items
1988: -- category change API i.e. in ICX_CAT_POPULATE_MI_PVT.populateItemCatgChange
1989: -- For category change of a master item we dont want to re-populate the base and local attributes of
1990: -- master item. So here we check for ICX_CAT_UTIL_PVT.g_ItemCatgChange_const
1991: -- (Note: Master items will not have any local attributes populated)
1992: -- Local and Base attributes does not need to repopulated (for blankets and global blankets)
2974: ICX_CAT_POPULATE_REQTMPL_PVT.buildCtxSqlForRTs(l_special_ctx_sql_tbl, l_regular_ctx_sql_tbl);
2975:
2976: ELSIF (p_current_cursor = ICX_CAT_UTIL_PVT.g_MasterItemCsr_const) THEN
2977: l_err_loc := 900;
2978: ICX_CAT_POPULATE_MI_PVT.buildCtxSqlForMIs(l_special_ctx_sql_tbl, l_regular_ctx_sql_tbl);
2979: END IF;
2980: END IF;
2981:
2982: l_err_loc := 1050;