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 257: x_usesurr_property PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PROPERTIES',inXFR_GROUP);

253: iItemId tItemId;
254: iPropertyId tPropertyId;
255:
256: x_usesurr_itempropertyvalue PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_PROPERTY_VALUES',inXFR_GROUP);
257: x_usesurr_property PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PROPERTIES',inXFR_GROUP);
258: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS',inXFR_GROUP);
259:
260: -- passing records
261: CURSOR C1 (x_usersurr_itemmaster PLS_INTEGER, x_usesurr_property PLS_INTEGER) IS

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

260: -- passing records
261: CURSOR C1 (x_usersurr_itemmaster PLS_INTEGER, x_usesurr_property PLS_INTEGER) IS
262: SELECT a.fsk_itemmaster_2_1,a.fsk_itemmaster_2_ext, a.fsk_property_1_1, a.fsk_property_1_ext,
263: b.item_id, c.property_id, a.orig_sys_ref
264: FROM cz_imp_item_property_value a, cz_item_masters b, cz_properties c
265: WHERE b.orig_sys_ref=DECODE(x_usesurr_itemmaster,1,a.fsk_itemmaster_2_ext,a.fsk_itemmaster_2_1)
266: AND c.orig_sys_ref=DECODE(x_usesurr_property,1,a.fsk_property_1_ext,a.fsk_property_1_1)
267: AND b.deleted_flag = '0'
268: AND c.deleted_flag = '0'

Line 279: AND NOT EXISTS (SELECT NULL FROM cz_properties

275: a.orig_sys_ref, b.item_id
276: FROM cz_imp_item_property_value a, cz_item_masters b
277: WHERE b.orig_sys_ref=DECODE(x_usesurr_itemmaster,1,a.fsk_itemmaster_2_ext,a.fsk_itemmaster_2_1)
278: AND b.deleted_flag = '0'
279: AND NOT EXISTS (SELECT NULL FROM cz_properties
280: WHERE orig_sys_ref = DECODE(x_usesurr_property,1,a.fsk_property_1_ext,a.fsk_property_1_1)
281: AND deleted_flag = '0')
282: AND a.rec_status IS NULL
283: AND a.run_id=inRUN_ID;

Line 289: FROM cz_imp_item_property_value a, cz_properties b

285: -- invalid fsk_itemmaster
286: CURSOR C3 (x_usersurr_itemmaster PLS_INTEGER, x_usesurr_property PLS_INTEGER) IS
287: SELECT a.fsk_itemmaster_2_1,a.fsk_itemmaster_2_ext, a.fsk_property_1_1, a.fsk_property_1_ext,
288: a.orig_sys_ref, b.property_id
289: FROM cz_imp_item_property_value a, cz_properties b
290: WHERE b.orig_sys_ref=DECODE(x_usesurr_property,1,a.fsk_property_1_ext,a.fsk_property_1_1)
291: AND b.deleted_flag = '0'
292: AND NOT EXISTS (SELECT NULL FROM cz_item_masters
293: WHERE orig_sys_ref = DECODE(x_usesurr_itemmaster,1,a.fsk_itemmaster_2_ext,a.fsk_itemmaster_2_1)

Line 305: AND NOT EXISTS (SELECT NULL FROM cz_properties

301: FROM cz_imp_item_property_value a
302: WHERE NOT EXISTS (SELECT NULL FROM cz_item_masters
303: WHERE orig_sys_ref = DECODE(x_usesurr_itemmaster,1,a.fsk_itemmaster_2_ext,a.fsk_itemmaster_2_1)
304: AND deleted_flag = '0')
305: AND NOT EXISTS (SELECT NULL FROM cz_properties
306: WHERE orig_sys_ref = DECODE(x_usesurr_property,1,a.fsk_property_1_ext,a.fsk_property_1_1)
307: AND deleted_flag = '0')
308: AND a.rec_status IS NULL
309: AND a.run_id=inRUN_ID;

Line 502: (SELECT NULL FROM cz_properties

498: (SELECT NULL FROM cz_imp_item_master
499: WHERE item_id = iv.item_id
500: AND run_id = inRUN_ID)
501: AND EXISTS
502: (SELECT NULL FROM cz_properties
503: WHERE orig_sys_ref IS NOT NULL
504: AND deleted_flag = '0'
505: AND property_id = iv.property_id);
506: COMMIT;

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

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;
710: BEGIN
711:

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

739: CLOSE c_onl_itemtype_itemtypeid;
740: END;
741: DECLARE
742: CURSOR c_onl_property_propertyid IS
743: SELECT PROPERTY_ID FROM CZ_PROPERTIES WHERE ORIG_SYS_REF=sFSKPROPERTY;
744: BEGIN
745: OPEN c_onl_property_propertyid;
746: nOnlPropertyId:=NULL;
747: FETCH c_onl_property_propertyid INTO nOnlPropertyId;

Line 839: AND PROPERTY_ID IN (SELECT PROPERTY_ID FROM CZ_PROPERTIES

835: AND PROPERTY_ID NOT IN (SELECT PROPERTY_ID FROM CZ_IMP_ITEM_TYPE_PROPERTY
836: WHERE RUN_ID = inRUN_ID
837: AND ITEM_TYPE_ID = CZ_ITEM_TYPE_PROPERTIES.ITEM_TYPE_ID
838: AND DELETED_FLAG = '0')
839: AND PROPERTY_ID IN (SELECT PROPERTY_ID FROM CZ_PROPERTIES
840: WHERE ORIG_SYS_REF IS NOT NULL
841: AND DELETED_FLAG = '0')
842: AND ORIG_SYS_REF IS NOT NULL
843: AND DELETED_FLAG = '0';

Line 912: l_data_type CZ_PROPERTIES.DATA_TYPE%TYPE;

908:
909: v_settings_id VARCHAR2(40);
910: v_section_name VARCHAR2(30);
911:
912: l_data_type CZ_PROPERTIES.DATA_TYPE%TYPE;
913:
914: BEGIN
915:
916: v_settings_id := 'OracleSequenceIncr';

Line 948: SELECT PROPERTY_ID, data_type FROM CZ_PROPERTIES WHERE ORIG_SYS_REF=sImpName;

944: EXIT WHEN NOT x_imp_property_f;
945: /* Check if this is an insert or update */
946: DECLARE
947: CURSOR c_onl_property_propertyid IS
948: SELECT PROPERTY_ID, data_type FROM CZ_PROPERTIES WHERE ORIG_SYS_REF=sImpName;
949: BEGIN
950: OPEN c_onl_property_propertyid ;
951: nPropertyId:=NULL;
952: l_data_type := NULL;

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

978: ELSE
979: BEGIN
980: DECLARE
981: CURSOR c_onl_property_propertyname IS
982: SELECT NAME FROM CZ_PROPERTIES WHERE NAME=sImpName AND ORIG_SYS_REF IS NULL AND DELETED_FLAG=0;
983: BEGIN
984: OPEN c_onl_property_propertyname;
985: FETCH c_onl_property_propertyname INTO nPropertyName;
986: x_onl_property_propertyname_f:=c_onl_property_propertyname%FOUND;

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

998: nInsertCount:=nInsertCount+1;
999: nAllocateCounter:=nAllocateCounter+1;
1000: IF(nAllocateCounter=nAllocateBlock)THEN
1001: nAllocateCounter:=0;
1002: SELECT CZ_PROPERTIES_S.NEXTVAL INTO nNextValue FROM DUAL;
1003: END IF;
1004: END IF;
1005: END;
1006: END IF;