APPS.CZ_IMP_IM_KRS dependencies on CZ_ITEM_TYPES

Line 32: SELECT 'F' FROM CZ_ITEM_TYPES

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

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

58: nInsertCount PLS_INTEGER:=0; /*Inserts */
59: nUpdateCount PLS_INTEGER:=0; /*Updates */
60: nDups PLS_INTEGER:=0; /*Dupl records */
61:
62: x_usesurr_itemtype PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPES',inXFR_GROUP);
63: nAllocateBlock PLS_INTEGER:=1;
64: nAllocateCounter PLS_INTEGER;
65: nNextValue NUMBER;
66:

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

138: /* Make sure that Item_Type_Id exists for this item in ITEM_TYPE table */
139: /* The following if is necessary because DECODE does not take BOOLEAN vars */
140: DECLARE
141: CURSOR c_onl_itemtype_itemtypeid IS
142: SELECT ITEM_TYPE_ID FROM CZ_ITEM_TYPES WHERE ORIG_SYS_REF=sFSKITEMTYPE;
143: BEGIN
144: nOnlItemTypeId := nDfltItemTypeId;
145: IF(sFSKITEMTYPE IS NOT NULL)THEN
146: OPEN c_onl_itemtype_itemtypeid;

Line 594: SELECT ITEM_TYPE_ID FROM CZ_ITEM_TYPES WHERE ORIG_SYS_REF=sImpName;

590:
591: /* Check if this is an insert or update */
592: DECLARE
593: CURSOR c_onl_itemtype_itemtypeid IS
594: SELECT ITEM_TYPE_ID FROM CZ_ITEM_TYPES WHERE ORIG_SYS_REF=sImpName;
595: BEGIN
596: OPEN c_onl_itemtype_itemtypeid ;
597: nItemTypeId:=NULL;
598: FETCH c_onl_itemtype_itemtypeid INTO nItemTypeId;

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

626: nInsertCount:=nInsertCount+1;
627: nAllocateCounter:=nAllocateCounter+1;
628: IF(nAllocateCounter=nAllocateBlock)THEN
629: nAllocateCounter:=0;
630: SELECT CZ_ITEM_TYPES_S.NEXTVAL INTO nNextValue FROM DUAL;
631: END IF;
632: END IF;
633: END;
634: END IF;

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

701: nUpdateCount PLS_INTEGER:=0; /*Updates */
702: nDups PLS_INTEGER:=0; /*Duplicate records */
703: x_usesurr_itemtypeprop PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPE_PROPERTIES',inXFR_GROUP);
704: /*Use surrogates */
705: x_usesurr_itemtype PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPES',inXFR_GROUP);
706: /*Use surrogates */
707: x_usesurr_property PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PROPERTIES',inXFR_GROUP);
708: /*Use surrogates */
709: thisRowId ROWID;

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

729: x_imp_itemtypeprop_f:=c_imp_itemtypeprop%FOUND;
730: EXIT WHEN NOT x_imp_itemtypeprop_f;
731: DECLARE
732: CURSOR c_onl_itemtype_itemtypeid IS
733: SELECT ITEM_TYPE_ID FROM CZ_ITEM_TYPES WHERE ORIG_SYS_REF=sFSKITEMTYPE;
734: BEGIN
735: OPEN c_onl_itemtype_itemtypeid;
736: nOnlItemTypeId:=NULL;
737: FETCH c_onl_itemtype_itemtypeid INTO nOnlItemTypeId;

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

844:
845: UPDATE CZ_ITEM_PROPERTY_VALUES
846: SET DELETED_FLAG = '1'
847: WHERE ITEM_ID IN (SELECT IM.ITEM_ID
848: FROM CZ_ITEM_MASTERS IM, CZ_ITEM_TYPES IT,CZ_ITEM_TYPE_PROPERTIES ITP
849: WHERE IM.ITEM_TYPE_ID = IT.ITEM_TYPE_ID
850: AND IT.ITEM_TYPE_ID = ITP.ITEM_TYPE_ID
851: AND ITP.DELETED_FLAG = '1'
852: AND CZ_ITEM_PROPERTY_VALUES.PROPERTY_ID = ITP.PROPERTY_ID);