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_IMP_PROPERTY

Line 314: WHERE run_id=inRUN_ID AND EXISTS(SELECT NULL FROM cz_imp_property

310:
311: -- invalid fsk_localizedtext_3_1
312: CURSOR C5(x_usesurr_itempropertyvalue PLS_INTEGER) IS
313: SELECT orig_sys_ref FROM cz_imp_item_property_value a
314: WHERE run_id=inRUN_ID AND EXISTS(SELECT NULL FROM cz_imp_property
315: WHERE run_id=inRUN_ID AND property_id=a.property_id AND
316: data_type=8 AND deleted_flag='0')
317: AND NOT EXISTS (SELECT NULL FROM cz_imp_localized_texts
318: WHERE run_id=inRUN_ID AND orig_sys_ref = DECODE(x_usesurr_itempropertyvalue,0,a.FSK_LOCALIZEDTEXT_3_1,a.FSK_LOCALIZEDTEXT_3_EXT)

Line 368: AND EXISTS(SELECT NULL FROM cz_imp_property

364: disposition='M',
365: rec_status='PASS'
366: WHERE run_id=inRUN_ID
367: AND orig_sys_ref=iOrigSysRef(i)
368: AND EXISTS(SELECT NULL FROM cz_imp_property
369: WHERE run_id=inRUN_ID AND property_id=iPropertyId(i) AND
370: data_type=8 AND deleted_flag='0')
371: AND EXISTS (SELECT NULL FROM cz_imp_localized_texts
372: WHERE run_id=inRUN_ID AND orig_sys_ref = a.FSK_LOCALIZEDTEXT_3_1

Line 880: SELECT ORIG_SYS_REF, ROWID FROM CZ_IMP_PROPERTY

876: ) IS
877: BEGIN
878: DECLARE
879: CURSOR c_imp_property IS
880: SELECT ORIG_SYS_REF, ROWID FROM CZ_IMP_PROPERTY
881: WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID
882: ORDER BY 1,ROWID;
883: /* cursor's data found indicator*/
884: sImpName CZ_IMP_PROPERTY.NAME%TYPE;

Line 884: sImpName CZ_IMP_PROPERTY.NAME%TYPE;

880: SELECT ORIG_SYS_REF, ROWID FROM CZ_IMP_PROPERTY
881: WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID
882: ORDER BY 1,ROWID;
883: /* cursor's data found indicator*/
884: sImpName CZ_IMP_PROPERTY.NAME%TYPE;
885: nPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;
886: nPropertyName CZ_IMP_PROPERTY.NAME%TYPE;
887: sLastFSK CZ_IMP_PROPERTY.NAME%TYPE;
888: sThisFSK CZ_IMP_PROPERTY.NAME%TYPE;

Line 885: nPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;

881: WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID
882: ORDER BY 1,ROWID;
883: /* cursor's data found indicator*/
884: sImpName CZ_IMP_PROPERTY.NAME%TYPE;
885: nPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;
886: nPropertyName CZ_IMP_PROPERTY.NAME%TYPE;
887: sLastFSK CZ_IMP_PROPERTY.NAME%TYPE;
888: sThisFSK CZ_IMP_PROPERTY.NAME%TYPE;
889: sRecStatus CZ_IMP_PROPERTY.REC_STATUS%TYPE;

Line 886: nPropertyName CZ_IMP_PROPERTY.NAME%TYPE;

882: ORDER BY 1,ROWID;
883: /* cursor's data found indicator*/
884: sImpName CZ_IMP_PROPERTY.NAME%TYPE;
885: nPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;
886: nPropertyName CZ_IMP_PROPERTY.NAME%TYPE;
887: sLastFSK CZ_IMP_PROPERTY.NAME%TYPE;
888: sThisFSK CZ_IMP_PROPERTY.NAME%TYPE;
889: sRecStatus CZ_IMP_PROPERTY.REC_STATUS%TYPE;
890: sDisposition CZ_IMP_PROPERTY.DISPOSITION%TYPE;

Line 887: sLastFSK CZ_IMP_PROPERTY.NAME%TYPE;

883: /* cursor's data found indicator*/
884: sImpName CZ_IMP_PROPERTY.NAME%TYPE;
885: nPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;
886: nPropertyName CZ_IMP_PROPERTY.NAME%TYPE;
887: sLastFSK CZ_IMP_PROPERTY.NAME%TYPE;
888: sThisFSK CZ_IMP_PROPERTY.NAME%TYPE;
889: sRecStatus CZ_IMP_PROPERTY.REC_STATUS%TYPE;
890: sDisposition CZ_IMP_PROPERTY.DISPOSITION%TYPE;
891: /* Column Vars */

Line 888: sThisFSK CZ_IMP_PROPERTY.NAME%TYPE;

884: sImpName CZ_IMP_PROPERTY.NAME%TYPE;
885: nPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;
886: nPropertyName CZ_IMP_PROPERTY.NAME%TYPE;
887: sLastFSK CZ_IMP_PROPERTY.NAME%TYPE;
888: sThisFSK CZ_IMP_PROPERTY.NAME%TYPE;
889: sRecStatus CZ_IMP_PROPERTY.REC_STATUS%TYPE;
890: sDisposition CZ_IMP_PROPERTY.DISPOSITION%TYPE;
891: /* Column Vars */
892: x_imp_property_f BOOLEAN:=FALSE;

Line 889: sRecStatus CZ_IMP_PROPERTY.REC_STATUS%TYPE;

885: nPropertyId CZ_IMP_PROPERTY.PROPERTY_ID%TYPE;
886: nPropertyName CZ_IMP_PROPERTY.NAME%TYPE;
887: sLastFSK CZ_IMP_PROPERTY.NAME%TYPE;
888: sThisFSK CZ_IMP_PROPERTY.NAME%TYPE;
889: sRecStatus CZ_IMP_PROPERTY.REC_STATUS%TYPE;
890: sDisposition CZ_IMP_PROPERTY.DISPOSITION%TYPE;
891: /* Column Vars */
892: x_imp_property_f BOOLEAN:=FALSE;
893: x_onl_property_propertyid_f BOOLEAN:=FALSE;

Line 890: sDisposition CZ_IMP_PROPERTY.DISPOSITION%TYPE;

886: nPropertyName CZ_IMP_PROPERTY.NAME%TYPE;
887: sLastFSK CZ_IMP_PROPERTY.NAME%TYPE;
888: sThisFSK CZ_IMP_PROPERTY.NAME%TYPE;
889: sRecStatus CZ_IMP_PROPERTY.REC_STATUS%TYPE;
890: sDisposition CZ_IMP_PROPERTY.DISPOSITION%TYPE;
891: /* Column Vars */
892: x_imp_property_f BOOLEAN:=FALSE;
893: x_onl_property_propertyid_f BOOLEAN:=FALSE;
894: x_onl_property_propertyname_f BOOLEAN:=FALSE;

Line 993: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_PROPERTY_EXISTS','NAME',nPropertyName),1,'CZ_IMP_IM_KRS.KRS_PROPERTY',11276,inRun_Id);

989: IF( x_onl_property_propertyname_f)THEN
990: sRecStatus:='DUPL';
991: sDisposition:='R';
992: nDups:=nDups+1;
993: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_PROPERTY_EXISTS','NAME',nPropertyName),1,'CZ_IMP_IM_KRS.KRS_PROPERTY',11276,inRun_Id);
994: CZ_IMP_ALL.setReturnCode(cz_imp_all.CONCURRENT_WARNING,CZ_UTILS.GET_TEXT('CZ_IMP_PROPERTY_EXISTS','NAME',nPropertyName));
995: ELSE
996: /*Insert */
997: sDisposition:='I';

Line 994: CZ_IMP_ALL.setReturnCode(cz_imp_all.CONCURRENT_WARNING,CZ_UTILS.GET_TEXT('CZ_IMP_PROPERTY_EXISTS','NAME',nPropertyName));

990: sRecStatus:='DUPL';
991: sDisposition:='R';
992: nDups:=nDups+1;
993: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_PROPERTY_EXISTS','NAME',nPropertyName),1,'CZ_IMP_IM_KRS.KRS_PROPERTY',11276,inRun_Id);
994: CZ_IMP_ALL.setReturnCode(cz_imp_all.CONCURRENT_WARNING,CZ_UTILS.GET_TEXT('CZ_IMP_PROPERTY_EXISTS','NAME',nPropertyName));
995: ELSE
996: /*Insert */
997: sDisposition:='I';
998: nInsertCount:=nInsertCount+1;

Line 1009: UPDATE CZ_IMP_PROPERTY SET

1005: END;
1006: END IF;
1007: END;
1008: END IF;
1009: UPDATE CZ_IMP_PROPERTY SET
1010: PROPERTY_ID=DECODE(sDISPOSITION,'R',PROPERTY_ID,'I',nNextValue+nAllocateCounter,nPropertyId),
1011: --
1012: --Bug #5162016 - use an existing but never before used field to store the on-line property data type.
1013: --For new properties this field will stay null.