DBA Data[Home] [Help]

APPS.CZ_IMP_PR_KRS dependencies on CZ_ITEM_MASTERS

Line 40: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS',inXFR_GROUP);

36: nInsertCount PLS_INTEGER:=0; /*Inserts */
37: nUpdateCount PLS_INTEGER:=0; /*Updates */
38: nFailed PLS_INTEGER:=0; /*Failed records */
39: nDups PLS_INTEGER:=0; /*Duplicate records */
40: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS',inXFR_GROUP);
41: x_usesurr_pricegroup PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PRICE_GROUPS',inXFR_GROUP);
42:
43: thisRowId ROWID;
44:

Line 78: FROM CZ_ITEM_MASTERS

74:
75: DECLARE
76: CURSOR c_onl_itemmaster_itemid IS
77: SELECT ITEM_ID
78: FROM CZ_ITEM_MASTERS
79: WHERE ORIG_SYS_REF=sFSKITEMMASTER;
80: BEGIN
81: OPEN c_onl_itemmaster_itemid;
82: nOnlFSKItemId:=NULL;