APPS.CZ_IMP_IM_KRS dependencies on CZ_ITEM_TYPES

Line 34: SELECT 'F' FROM CZ_ITEM_TYPES

30: WHERE SECTION_NAME=v_section_name
31: AND SETTING_ID=v_settings_id;
32:
33: CURSOR C_ITEM_TYPE(nItemTypeId PLS_INTEGER) IS
34: SELECT 'F' FROM CZ_ITEM_TYPES
35: WHERE ITEM_TYPE_ID=nItemTypeId;
36:
37: /* cursor's data found indicator */
38: x_imp_itemmaster_itemid_f BOOLEAN:=FALSE;

Line 87: x_usesurr_itemtype PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPES',inXFR_GROUP);

83: nInsertCount PLS_INTEGER:=0; /*Inserts */
84: nUpdateCount PLS_INTEGER:=0; /*Updates */
85: nDups PLS_INTEGER:=0; /*Dupl records */
86: nNoChangeCount PLS_INTEGER:=0; /*Nochange in Record*/
87: x_usesurr_itemtype PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPES',inXFR_GROUP);
88: nAllocateBlock PLS_INTEGER:=1;
89: dispositionflag PLS_INTEGER:=0;
90: nAllocateCounter PLS_INTEGER;
91: nNextValue NUMBER;

Line 168: SELECT ITEM_TYPE_ID FROM CZ_ITEM_TYPES WHERE ORIG_SYS_REF=sFSKITEMTYPE;

164: /* Make sure that Item_Type_Id exists for this item in ITEM_TYPE table */
165: /* The following if is necessary because DECODE does not take BOOLEAN vars */
166: DECLARE
167: CURSOR c_onl_itemtype_itemtypeid IS
168: SELECT ITEM_TYPE_ID FROM CZ_ITEM_TYPES WHERE ORIG_SYS_REF=sFSKITEMTYPE;
169: BEGIN
170: nOnlItemTypeId := nDfltItemTypeId;
171: IF(sFSKITEMTYPE IS NOT NULL)THEN
172: OPEN c_onl_itemtype_itemtypeid;

Line 679: FROM CZ_ITEM_TYPES

675: /* Check if this is an insert or update */
676: DECLARE
677: CURSOR c_onl_itemtype_itemtypeid IS
678: SELECT ITEM_TYPE_ID,DESC_TEXT,NAME,DELETED_FLAG,SRC_APPLICATION_ID,ORIG_SYS_REF
679: FROM CZ_ITEM_TYPES
680: WHERE ORIG_SYS_REF=sImpName;
681: BEGIN
682: OPEN c_onl_itemtype_itemtypeid ;
683: nItemTypeId:=NULL;

Line 731: SELECT CZ_ITEM_TYPES_S.NEXTVAL INTO nNextValue FROM DUAL;

727: nAllocateCounter:=nAllocateCounter+1;
728:
729: IF(nAllocateCounter=nAllocateBlock)THEN
730: nAllocateCounter:=0;
731: SELECT CZ_ITEM_TYPES_S.NEXTVAL INTO nNextValue FROM DUAL;
732: END IF;
733: END IF;
734: END;
735: END IF;

Line 809: x_usesurr_itemtype PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPES',inXFR_GROUP);

805: nUpdateCount PLS_INTEGER:=0; /*Updates */
806: nDups PLS_INTEGER:=0; /*Duplicate records */
807: x_usesurr_itemtypeprop PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPE_PROPERTIES',inXFR_GROUP);
808: /*Use surrogates */
809: x_usesurr_itemtype PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPES',inXFR_GROUP);
810: /*Use surrogates */
811: x_usesurr_property PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PROPERTIES',inXFR_GROUP);
812: /*Use surrogates */
813: thisRowId ROWID;

Line 837: SELECT ITEM_TYPE_ID FROM CZ_ITEM_TYPES WHERE ORIG_SYS_REF=sFSKITEMTYPE;

833: x_imp_itemtypeprop_f:=c_imp_itemtypeprop%FOUND;
834: EXIT WHEN NOT x_imp_itemtypeprop_f;
835: DECLARE
836: CURSOR c_onl_itemtype_itemtypeid IS
837: SELECT ITEM_TYPE_ID FROM CZ_ITEM_TYPES WHERE ORIG_SYS_REF=sFSKITEMTYPE;
838: BEGIN
839: OPEN c_onl_itemtype_itemtypeid;
840: nOnlItemTypeId:=NULL;
841: FETCH c_onl_itemtype_itemtypeid INTO nOnlItemTypeId;

Line 952: FROM CZ_ITEM_MASTERS IM, CZ_ITEM_TYPES IT,CZ_ITEM_TYPE_PROPERTIES ITP

948:
949: UPDATE CZ_ITEM_PROPERTY_VALUES
950: SET DELETED_FLAG = '1'
951: WHERE ITEM_ID IN (SELECT IM.ITEM_ID
952: FROM CZ_ITEM_MASTERS IM, CZ_ITEM_TYPES IT,CZ_ITEM_TYPE_PROPERTIES ITP
953: WHERE IM.ITEM_TYPE_ID = IT.ITEM_TYPE_ID
954: AND IT.ITEM_TYPE_ID = ITP.ITEM_TYPE_ID
955: AND ITP.DELETED_FLAG = '1'
956: AND CZ_ITEM_PROPERTY_VALUES.PROPERTY_ID = ITP.PROPERTY_ID);