[Home] [Help]
78: inExplType IN VARCHAR2)
79: RETURN BOOLEAN IS
80:
81: CURSOR c_childModel IS
82: SELECT p.model_ps_node_id FROM cz_xfr_project_bills p, cz_devl_projects d
83: WHERE p.organization_id = inOrgId
84: AND p.top_item_id = inTopId
85: AND p.explosion_type = inExplType
86: AND d.deleted_flag = '0'
88: AND p.model_ps_node_id = d.devl_project_id;
89:
90: xERROR BOOLEAN:=FALSE;
91: nChildFound BOOLEAN:=FALSE;
92: nDevlProjectId cz_devl_projects.devl_project_id%TYPE;
93:
94: BEGIN
95:
96: OPEN c_childModel;
540: n_SortWidth NUMBER := cz_imp_ps_node.n_SortWidth;
541: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS', 'IMPORT');
542: x_usesurr_intltext PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_LOCALIZED_TEXTS', 'IMPORT');
543: x_usesurr_psnode PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PS_NODES', 'IMPORT');
544: x_usesurr_devlproject PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_DEVL_PROJECTS', 'IMPORT');
545: x_error BOOLEAN:=FALSE;
546:
547: ComponentSequenceId tComponentSequenceId;
548: ComponentCode tComponentCode;
2902: end_time := dbms_utility.get_time();
2903: d_str := inRun_Id || ' Extract intl text (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2904: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2905: end if;
2906: ELSIF(lower_table_name='cz_devl_projects') THEN
2907: if (CZ_IMP_ALL.get_time) then
2908: st_time := dbms_utility.get_time();
2909: end if;
2910: EXTR_DEVL_PROJECT(inRun_ID,nOrg_ID,nTop_ID,sExpl_type,nModelId);
3017: end_time := dbms_utility.get_time();
3018: d_str := inRun_Id || ' Populate intl text :' || (end_time-st_time)/100.00;
3019: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3020: end if;
3021: ELSIF(lower_table_name='cz_devl_projects') THEN
3022: if (CZ_IMP_ALL.get_time) then
3023: st_time := dbms_utility.get_time();
3024: end if;
3025: CZ_IMP_PS_NODE.MAIN_DEVL_PROJECT(inRun_ID, commit_size, max_err,
3203: bom_explode_st number;
3204: bom_explode_end number;
3205: d_str varchar2(255);
3206:
3207: childDevlProjectId cz_devl_projects.devl_project_id%TYPE;
3208: l_lang VARCHAR2(4);
3209: BEGIN
3210:
3211: IF(inCopyRootModel = '1')THEN
3225: nModelId := NULL;
3226:
3227: BEGIN
3228: SELECT p.model_ps_node_id INTO nModelId
3229: FROM cz_xfr_project_bills p, cz_devl_projects d
3230: WHERE p.organization_id = inOrgId
3231: AND p.top_item_id = inTopId
3232: AND p.explosion_type = inExplType
3233: AND d.deleted_flag = '0'
3460: CURSOR C_EXTRACTION_ORDER IS
3461: SELECT DST_TABLE FROM CZ_XFR_TABLES
3462: WHERE XFR_GROUP='EXTRACT' AND DISABLED='0'
3463: AND DST_TABLE IN ('CZ_ITEM_TYPES','CZ_PROPERTIES','CZ_ITEM_TYPE_PROPERTIES',
3464: 'CZ_ITEM_MASTERS','CZ_ITEM_PROPERTY_VALUES','CZ_LOCALIZED_TEXTS','CZ_DEVL_PROJECTS')
3465: ORDER BY ORDER_SEQ;
3466: CURSOR C_IMPORT_ORDER IS
3467: SELECT DST_TABLE FROM CZ_XFR_TABLES
3468: WHERE XFR_GROUP='IMPORT' AND DISABLED='0'
3466: CURSOR C_IMPORT_ORDER IS
3467: SELECT DST_TABLE FROM CZ_XFR_TABLES
3468: WHERE XFR_GROUP='IMPORT' AND DISABLED='0'
3469: AND DST_TABLE IN ('CZ_ITEM_TYPES','CZ_PROPERTIES','CZ_ITEM_TYPE_PROPERTIES',
3470: 'CZ_ITEM_MASTERS','CZ_ITEM_PROPERTY_VALUES','CZ_LOCALIZED_TEXTS','CZ_DEVL_PROJECTS',
3471: 'CZ_PS_NODES')
3472: ORDER BY ORDER_SEQ;
3473: CURSOR C_BILL_OF_MATERIAL IS
3474: SELECT 'F' FROM CZ_EXV_BILL_OF_MATERIALS
3494:
3495: IF (REFRESH_MODEL_ID IS NULL OR REFRESH_MODEL_ID=-1) THEN
3496: BEGIN
3497: SELECT NVL(d.config_engine_type,'L') INTO g_CONFIG_ENGINE_TYPE
3498: FROM cz_xfr_project_bills p, cz_devl_projects d
3499: WHERE p.organization_id = nOrg_ID
3500: AND p.top_item_id = nTop_ID
3501: AND p.explosion_type = sExpl_type
3502: AND d.deleted_flag = '0'
3506: WHEN NO_DATA_FOUND THEN
3507: g_CONFIG_ENGINE_TYPE := FND_PROFILE.VALUE('CZ_CONFIG_ENGINE_NEW_MODELS');
3508: END;
3509: ELSE
3510: SELECT NVL(config_engine_type,'L') INTO g_CONFIG_ENGINE_TYPE FROM CZ_DEVL_PROJECTS
3511: WHERE devl_project_id=REFRESH_MODEL_ID;
3512: END IF;
3513:
3514: CZ_ADMIN.SPX_SYNC_IMPORTSESSIONS;
3675: dRev_date, dDateFormat, REFRESH_MODEL_ID, COPY_ROOT_MODEL, COPY_CHILD_MODELS,
3676: genStatisticsBom);
3677: processed_expls_tbl.DELETE;
3678: ----------deep-lock the model if it exists
3679: FOR j IN (SELECT devl_project_id FROM cz_devl_projects
3680: WHERE devl_project_id = nModelId AND deleted_flag='0')
3681: LOOP
3682: cz_security_pvt.lock_model(
3683: p_api_version => 1.0,
3805:
3806: FOR model IN (SELECT DISTINCT component_id FROM cz_model_ref_expls WHERE model_id = nModelId
3807: AND deleted_flag = '0' AND (ps_node_type IN (263, 264) OR parent_expl_node_id IS NULL))LOOP
3808:
3809: FOR j IN (SELECT devl_project_id FROM cz_devl_projects
3810: WHERE devl_project_id = model.component_id AND deleted_flag='0')
3811: LOOP
3812: l_compare_detailed_types := TRUE;
3813: l_current_date := SYSDATE;
3939: END IF;
3940: END LOOP;
3941:
3942: IF l_update_model_timestamp THEN
3943: UPDATE cz_devl_projects set ui_timestamp_struct_update = SYSDATE
3944: WHERE devl_project_id = model.devl_project_id;
3945: END IF;
3946: END LOOP;
3947: END IF;