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_SINGLE dependencies on CZ_RP_ENTRIES

Line 3318: AND EXISTS (SELECT NULL FROM CZ_RP_ENTRIES WHERE deleted_flag = '0'

3314: WHERE d.orig_sys_ref = inDevlPrjOSR
3315: AND d.deleted_flag = '0'
3316: AND d.import_enabled = '1'
3317: AND NVL(d.config_engine_type,'L') = g_CONFIG_ENGINE_TYPE --LA 12548898 Engine Sync
3318: AND EXISTS (SELECT NULL FROM CZ_RP_ENTRIES WHERE deleted_flag = '0'
3319: AND object_type = 'PRJ' AND object_id = d.devl_project_id) ;
3320: EXCEPTION
3321: WHEN TOO_MANY_ROWS THEN
3322: d_str:= 'Multiple copies of the model enabled for Import : (' || inDevlPrjOSR || ')' ;

Line 3329: -- or there is no entry in either cz_rp_entries or cz_devl_projects

3325: xModelId := NULL;
3326: RAISE IMP_MODEL_NOT_ENABLED ;
3327: WHEN NO_DATA_FOUND THEN
3328: -- It could error out when model is not enabled for import
3329: -- or there is no entry in either cz_rp_entries or cz_devl_projects
3330: -- for given orig_sys_ref
3331: SELECT count(*) INTO xModelId FROM cz_devl_projects d, cz_rp_entries r
3332: WHERE d.orig_sys_ref = inDevlPrjOSR
3333: AND d.deleted_flag = '0'

Line 3331: SELECT count(*) INTO xModelId FROM cz_devl_projects d, cz_rp_entries r

3327: WHEN NO_DATA_FOUND THEN
3328: -- It could error out when model is not enabled for import
3329: -- or there is no entry in either cz_rp_entries or cz_devl_projects
3330: -- for given orig_sys_ref
3331: SELECT count(*) INTO xModelId FROM cz_devl_projects d, cz_rp_entries r
3332: WHERE d.orig_sys_ref = inDevlPrjOSR
3333: AND d.deleted_flag = '0'
3334: AND r.deleted_flag = '0'
3335: AND r.object_type = 'PRJ'

Line 3461: (SELECT NULL FROM CZ_RP_ENTRIES WHERE deleted_flag = '0' and object_type = 'PRJ'

3457: FROM CZ_DEVL_PROJECTS d
3458: WHERE d.orig_sys_ref = inExplType || ':' || inOrgId || ':' || inTopId
3459: AND NVL(d.config_engine_type,'L') = g_CONFIG_ENGINE_TYPE --LA 12548898 Engine Sync
3460: AND d.deleted_flag = '0' and d.import_enabled = '1' AND EXISTS
3461: (SELECT NULL FROM CZ_RP_ENTRIES WHERE deleted_flag = '0' and object_type = 'PRJ'
3462: AND object_id = d.devl_project_id) AND NOT EXISTS
3463: (SELECT NULL FROM CZ_XFR_PROJECT_BILLS WHERE model_ps_node_id = d.devl_project_id);
3464: END IF;
3465:

Line 3802: TYPE tNoChildOCModelName IS TABLE OF cz_rp_entries.name%TYPE INDEX BY BINARY_INTEGER;

3798: v_enabled VARCHAR2(1) := '1';
3799:
3800: -- LA 13733007 : OC with No children
3801: TYPE tNoChildOCName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
3802: TYPE tNoChildOCModelName IS TABLE OF cz_rp_entries.name%TYPE INDEX BY BINARY_INTEGER;
3803: lNoChildOCName tNoChildOCName ;
3804: lNoChildOCModelName tNoChildOCModelName;
3805:
3806: BEGIN

Line 4264: FROM cz_ps_nodes PARENT, cz_rp_entries MODEL

4260:
4261: BEGIN
4262: SELECT MODEL.NAME, PARENT.NAME
4263: BULK COLLECT INTO lNoChildOCModelName, lNoChildOCName
4264: FROM cz_ps_nodes PARENT, cz_rp_entries MODEL
4265: WHERE PARENT.deleted_flag = '0'
4266: AND MODEL.deleted_flag = '0'
4267: AND PARENT.devl_project_id = MODEL.object_id
4268: AND MODEL.object_type = 'PRJ'