eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_IMP_IM_KRS dependencies on CZ_PROPERTIES

Line 308: x_usesurr_property PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PROPERTIES',inXFR_GROUP);

304: iPropertyId tPropertyId;
305:
306:
307: x_usesurr_itempropertyvalue PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_PROPERTY_VALUES',inXFR_GROUP);
308: x_usesurr_property PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PROPERTIES',inXFR_GROUP);
309: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS',inXFR_GROUP);
310:
311: -- passing records
312: CURSOR C1 (x_usersurr_itemmaster PLS_INTEGER, x_usesurr_property PLS_INTEGER) IS

Line 315: FROM cz_imp_item_property_value a, cz_item_masters b, cz_properties c

311: -- passing records
312: CURSOR C1 (x_usersurr_itemmaster PLS_INTEGER, x_usesurr_property PLS_INTEGER) IS
313: SELECT a.fsk_itemmaster_2_1,a.fsk_itemmaster_2_ext, a.fsk_property_1_1, a.fsk_property_1_ext,
314: b.item_id, c.property_id, a.orig_sys_ref
315: FROM cz_imp_item_property_value a, cz_item_masters b, cz_properties c
316: WHERE b.orig_sys_ref=DECODE(x_usesurr_itemmaster,1,a.fsk_itemmaster_2_ext,a.fsk_itemmaster_2_1)
317: AND c.orig_sys_ref=DECODE(x_usesurr_property,1,a.fsk_property_1_ext,a.fsk_property_1_1)
318: AND b.deleted_flag = '0'
319: AND c.deleted_flag = '0'

Line 331: AND NOT EXISTS (SELECT NULL FROM cz_properties

327: a.orig_sys_ref, b.item_id
328: FROM cz_imp_item_property_value a, cz_item_masters b
329: WHERE b.orig_sys_ref=DECODE(x_usesurr_itemmaster,1,a.fsk_itemmaster_2_ext,a.fsk_itemmaster_2_1)
330: AND b.deleted_flag = '0'
331: AND NOT EXISTS (SELECT NULL FROM cz_properties
332: WHERE orig_sys_ref = DECODE(x_usesurr_property,1,a.fsk_property_1_ext,a.fsk_property_1_1)
333: AND deleted_flag = '0')
334: AND a.rec_status IS NULL
335: AND a.run_id=inRUN_ID;

Line 341: FROM cz_imp_item_property_value a, cz_properties b

337: -- invalid fsk_itemmaster
338: CURSOR C3 (x_usersurr_itemmaster PLS_INTEGER, x_usesurr_property PLS_INTEGER) IS
339: SELECT a.fsk_itemmaster_2_1,a.fsk_itemmaster_2_ext, a.fsk_property_1_1, a.fsk_property_1_ext,
340: a.orig_sys_ref, b.property_id
341: FROM cz_imp_item_property_value a, cz_properties b
342: WHERE b.orig_sys_ref=DECODE(x_usesurr_property,1,a.fsk_property_1_ext,a.fsk_property_1_1)
343: AND b.deleted_flag = '0'
344: AND NOT EXISTS (SELECT NULL FROM cz_item_masters
345: WHERE orig_sys_ref = DECODE(x_usesurr_itemmaster,1,a.fsk_itemmaster_2_ext,a.fsk_itemmaster_2_1)

Line 357: AND NOT EXISTS (SELECT NULL FROM cz_properties

353: FROM cz_imp_item_property_value a
354: WHERE NOT EXISTS (SELECT NULL FROM cz_item_masters
355: WHERE orig_sys_ref = DECODE(x_usesurr_itemmaster,1,a.fsk_itemmaster_2_ext,a.fsk_itemmaster_2_1)
356: AND deleted_flag = '0')
357: AND NOT EXISTS (SELECT NULL FROM cz_properties
358: WHERE orig_sys_ref = DECODE(x_usesurr_property,1,a.fsk_property_1_ext,a.fsk_property_1_1)
359: AND deleted_flag = '0')
360: AND a.rec_status IS NULL
361: AND a.run_id=inRUN_ID;

Line 571: (SELECT NULL FROM cz_properties

567: (SELECT NULL FROM cz_imp_item_master
568: WHERE item_id = iv.item_id
569: AND run_id = inRUN_ID)
570: AND EXISTS
571: (SELECT NULL FROM cz_properties
572: WHERE orig_sys_ref IS NOT NULL
573: AND deleted_flag = '0'
574: AND property_id = iv.property_id);
575: COMMIT;

Line 811: x_usesurr_property PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PROPERTIES',inXFR_GROUP);

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;
814: BEGIN
815:

Line 847: SELECT PROPERTY_ID FROM CZ_PROPERTIES WHERE ORIG_SYS_REF=sFSKPROPERTY;

843: CLOSE c_onl_itemtype_itemtypeid;
844: END;
845: DECLARE
846: CURSOR c_onl_property_propertyid IS
847: SELECT PROPERTY_ID FROM CZ_PROPERTIES WHERE ORIG_SYS_REF=sFSKPROPERTY;
848: BEGIN
849: OPEN c_onl_property_propertyid;
850: nOnlPropertyId:=NULL;
851: FETCH c_onl_property_propertyid INTO nOnlPropertyId;

Line 943: AND PROPERTY_ID IN (SELECT PROPERTY_ID FROM CZ_PROPERTIES

939: AND PROPERTY_ID NOT IN (SELECT PROPERTY_ID FROM CZ_IMP_ITEM_TYPE_PROPERTY
940: WHERE RUN_ID = inRUN_ID
941: AND ITEM_TYPE_ID = CZ_ITEM_TYPE_PROPERTIES.ITEM_TYPE_ID
942: AND DELETED_FLAG = '0')
943: AND PROPERTY_ID IN (SELECT PROPERTY_ID FROM CZ_PROPERTIES
944: WHERE ORIG_SYS_REF IS NOT NULL
945: AND DELETED_FLAG = '0')
946: AND ORIG_SYS_REF IS NOT NULL
947: AND DELETED_FLAG = '0';

Line 1039: l_data_type CZ_PROPERTIES.DATA_TYPE%TYPE;

1035:
1036: v_settings_id VARCHAR2(40);
1037: v_section_name VARCHAR2(30);
1038:
1039: l_data_type CZ_PROPERTIES.DATA_TYPE%TYPE;
1040:
1041: BEGIN
1042:
1043: v_settings_id := 'OracleSequenceIncr';

Line 1075: SELECT PROPERTY_ID, data_type,PROPERTY_UNIT,DESC_TEXT,NAME,DEF_VALUE,DELETED_FLAG,ORIG_SYS_REF,DEF_NUM_VALUE FROM CZ_PROPERTIES WHERE ORIG_SYS_REF=sImpName;

1071: EXIT WHEN NOT x_imp_property_f;
1072: /* Check if this is an insert or update */
1073: DECLARE
1074: CURSOR c_onl_property_propertyid IS
1075: SELECT PROPERTY_ID, data_type,PROPERTY_UNIT,DESC_TEXT,NAME,DEF_VALUE,DELETED_FLAG,ORIG_SYS_REF,DEF_NUM_VALUE FROM CZ_PROPERTIES WHERE ORIG_SYS_REF=sImpName;
1076: BEGIN
1077: OPEN c_onl_property_propertyid ;
1078: nPropertyId:=NULL;
1079: l_data_type := NULL;

Line 1129: SELECT NAME FROM CZ_PROPERTIES WHERE NAME=sImpName AND ORIG_SYS_REF IS NULL AND DELETED_FLAG=0;

1125:
1126: BEGIN
1127: DECLARE
1128: CURSOR c_onl_property_propertyname IS
1129: SELECT NAME FROM CZ_PROPERTIES WHERE NAME=sImpName AND ORIG_SYS_REF IS NULL AND DELETED_FLAG=0;
1130: BEGIN
1131: OPEN c_onl_property_propertyname;
1132: FETCH c_onl_property_propertyname INTO nPropertyName;
1133: x_onl_property_propertyname_f:=c_onl_property_propertyname%FOUND;

Line 1149: SELECT CZ_PROPERTIES_S.NEXTVAL INTO nNextValue FROM DUAL;

1145: nInsertCount:=nInsertCount+1;
1146: nAllocateCounter:=nAllocateCounter+1;
1147: IF(nAllocateCounter=nAllocateBlock)THEN
1148: nAllocateCounter:=0;
1149: SELECT CZ_PROPERTIES_S.NEXTVAL INTO nNextValue FROM DUAL;
1150: END IF;
1151: END IF;
1152: END;
1153: END IF;