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_DEVL_PROJECTS

Line 96: nDevlProjectId cz_devl_projects.devl_project_id%TYPE;

92: nCurStmt VARCHAR2(400);
93:
94: xERROR BOOLEAN:=FALSE;
95: nChildFound BOOLEAN:=FALSE;
96: nDevlProjectId cz_devl_projects.devl_project_id%TYPE;
97:
98: BEGIN
99:
100: --LA 9595142 Changed the cursor sql to use import enabled flag

Line 101: nCurStmt := 'SELECT p.model_ps_node_id FROM cz_xfr_project_bills p, cz_devl_projects d '

97:
98: BEGIN
99:
100: --LA 9595142 Changed the cursor sql to use import enabled flag
101: nCurStmt := 'SELECT p.model_ps_node_id FROM cz_xfr_project_bills p, cz_devl_projects d '
102: || ' WHERE p.organization_id = :1 '
103: || ' AND p.top_item_id = :2 '
104: || ' AND p.explosion_type = :3 '
105: || ' AND d.deleted_flag = ''0'' '

Line 568: x_usesurr_devlproject PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_DEVL_PROJECTS', 'IMPORT');

564: n_SortWidth NUMBER := cz_imp_ps_node.n_SortWidth;
565: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS', 'IMPORT');
566: x_usesurr_intltext PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_LOCALIZED_TEXTS', 'IMPORT');
567: x_usesurr_psnode PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PS_NODES', 'IMPORT');
568: x_usesurr_devlproject PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_DEVL_PROJECTS', 'IMPORT');
569: x_error BOOLEAN:=FALSE;
570:
571: ComponentSequenceId tComponentSequenceId;
572: ComponentCode tComponentCode;

Line 2976: ELSIF(lower_table_name='cz_devl_projects') THEN

2972: end_time := dbms_utility.get_time();
2973: d_str := inRun_Id || ' Extract intl text (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2974: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2975: end if;
2976: ELSIF(lower_table_name='cz_devl_projects') THEN
2977: if (CZ_IMP_ALL.get_time) then
2978: st_time := dbms_utility.get_time();
2979: end if;
2980: EXTR_DEVL_PROJECT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);

Line 3092: ELSIF(lower_table_name='cz_devl_projects') THEN

3088: end_time := dbms_utility.get_time();
3089: d_str := inRun_Id || ' Populate intl text :' || (end_time-st_time)/100.00;
3090: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3091: end if;
3092: ELSIF(lower_table_name='cz_devl_projects') THEN
3093: if (CZ_IMP_ALL.get_time) then
3094: st_time := dbms_utility.get_time();
3095: end if;
3096: CZ_IMP_PS_NODE.MAIN_DEVL_PROJECT(inRun_ID, commit_size, max_err,

Line 3292: childDevlProjectId cz_devl_projects.devl_project_id%TYPE;

3288: bom_explode_st number;
3289: bom_explode_end number;
3290: d_str varchar2(255);
3291:
3292: childDevlProjectId cz_devl_projects.devl_project_id%TYPE;
3293: l_lang VARCHAR2(4);
3294:
3295: --LA 9595142
3296: l_curr_ref_id NUMBER;

Line 3313: SELECT d.devl_project_id INTO xModelId FROM cz_devl_projects d

3309: PROCEDURE getImpEnabledModelId (inDevlPrjOSR IN VARCHAR2,
3310: inRunId IN PLS_INTEGER,
3311: xModelId IN OUT NOCOPY NUMBER ) IS
3312: BEGIN
3313: SELECT d.devl_project_id INTO xModelId FROM cz_devl_projects d
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

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 3432: FROM cz_xfr_project_bills p, cz_devl_projects d

3428: checkImpEnabled(inExplType || ':' || inOrgId || ':' || inTopId, inTopId, inRunId, -999,nModelId, -1);
3429: ELSE
3430: BEGIN
3431: SELECT p.model_ps_node_id INTO nModelId
3432: FROM cz_xfr_project_bills p, cz_devl_projects d
3433: WHERE p.organization_id = inOrgId
3434: AND p.top_item_id = inTopId
3435: AND p.explosion_type = inExplType
3436: AND d.deleted_flag = '0'

Line 3457: FROM CZ_DEVL_PROJECTS d

3453: INSERT INTO CZ_XFR_PROJECT_BILLS
3454: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3455: source_server)
3456: SELECT inOrgId,inTopId,inExplType,'0',d.devl_project_id,inCopyChildModels,inServerId
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'

Line 3771: 'CZ_ITEM_MASTERS','CZ_ITEM_PROPERTY_VALUES','CZ_LOCALIZED_TEXTS','CZ_DEVL_PROJECTS')

3767: CURSOR C_EXTRACTION_ORDER IS
3768: SELECT DST_TABLE FROM CZ_XFR_TABLES
3769: WHERE XFR_GROUP='EXTRACT' AND DISABLED='0'
3770: AND DST_TABLE IN ('CZ_ITEM_TYPES','CZ_PROPERTIES','CZ_ITEM_TYPE_PROPERTIES',
3771: 'CZ_ITEM_MASTERS','CZ_ITEM_PROPERTY_VALUES','CZ_LOCALIZED_TEXTS','CZ_DEVL_PROJECTS')
3772: ORDER BY ORDER_SEQ;
3773: CURSOR C_IMPORT_ORDER IS
3774: SELECT DST_TABLE FROM CZ_XFR_TABLES
3775: WHERE XFR_GROUP='IMPORT' AND DISABLED='0'

Line 3777: 'CZ_ITEM_MASTERS','CZ_ITEM_PROPERTY_VALUES','CZ_LOCALIZED_TEXTS','CZ_DEVL_PROJECTS',

3773: CURSOR C_IMPORT_ORDER IS
3774: SELECT DST_TABLE FROM CZ_XFR_TABLES
3775: WHERE XFR_GROUP='IMPORT' AND DISABLED='0'
3776: AND DST_TABLE IN ('CZ_ITEM_TYPES','CZ_PROPERTIES','CZ_ITEM_TYPE_PROPERTIES',
3777: 'CZ_ITEM_MASTERS','CZ_ITEM_PROPERTY_VALUES','CZ_LOCALIZED_TEXTS','CZ_DEVL_PROJECTS',
3778: 'CZ_PS_NODES')
3779: ORDER BY ORDER_SEQ;
3780: CURSOR C_BILL_OF_MATERIAL IS
3781: SELECT 'F' FROM CZ_EXV_BILL_OF_MATERIALS

Line 3811: FROM cz_xfr_project_bills p, cz_devl_projects d

3807:
3808: IF (REFRESH_MODEL_ID IS NULL OR REFRESH_MODEL_ID=-1) THEN
3809: BEGIN
3810: SELECT NVL(d.config_engine_type,'L') INTO g_CONFIG_ENGINE_TYPE
3811: FROM cz_xfr_project_bills p, cz_devl_projects d
3812: WHERE p.organization_id = nOrg_ID
3813: AND p.top_item_id = nTop_ID
3814: AND p.explosion_type = sExpl_type
3815: AND d.deleted_flag = '0'

Line 3823: SELECT NVL(config_engine_type,'L') INTO g_CONFIG_ENGINE_TYPE FROM CZ_DEVL_PROJECTS

3819: WHEN NO_DATA_FOUND THEN
3820: g_CONFIG_ENGINE_TYPE := FND_PROFILE.VALUE('CZ_CONFIG_ENGINE_NEW_MODELS');
3821: END;
3822: ELSE
3823: SELECT NVL(config_engine_type,'L') INTO g_CONFIG_ENGINE_TYPE FROM CZ_DEVL_PROJECTS
3824: WHERE devl_project_id=REFRESH_MODEL_ID;
3825: END IF;
3826:
3827: CZ_ADMIN.SPX_SYNC_IMPORTSESSIONS;

Line 4012: FOR j IN (SELECT devl_project_id FROM cz_devl_projects

4008: import_enabled_tbl.DELETE;
4009:
4010:
4011: ----------deep-lock the model if it exists
4012: FOR j IN (SELECT devl_project_id FROM cz_devl_projects
4013: WHERE devl_project_id = nModelId AND deleted_flag='0')
4014: LOOP
4015: cz_security_pvt.lock_model(
4016: p_api_version => 1.0,

Line 4159: FOR j IN (SELECT devl_project_id FROM cz_devl_projects

4155:
4156: FOR model IN (SELECT DISTINCT component_id FROM cz_model_ref_expls WHERE model_id = nModelId
4157: AND deleted_flag = '0' AND (ps_node_type IN (263, 264) OR parent_expl_node_id IS NULL))LOOP
4158:
4159: FOR j IN (SELECT devl_project_id FROM cz_devl_projects
4160: WHERE devl_project_id = model.component_id AND deleted_flag='0')
4161: LOOP
4162: l_compare_detailed_types := TRUE;
4163: l_current_date := SYSDATE;

Line 4335: UPDATE cz_devl_projects set ui_timestamp_struct_update = SYSDATE

4331: END IF;
4332: END LOOP;
4333:
4334: IF l_update_model_timestamp THEN
4335: UPDATE cz_devl_projects set ui_timestamp_struct_update = SYSDATE
4336: WHERE devl_project_id = model.devl_project_id;
4337: END IF;
4338: END LOOP;
4339: END IF;