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_XFR_PROJECT_BILLS

Line 82: SELECT p.model_ps_node_id FROM cz_xfr_project_bills p, cz_devl_projects d

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'

Line 1426: fnd_stats.gather_table_stats('CZ', 'CZ_XFR_PROJECT_BILLS');

1422: IF(genStatisticsCz = 1)THEN
1423:
1424: fnd_stats.gather_table_stats('CZ', 'CZ_IMP_PS_NODES');
1425: fnd_stats.gather_table_stats('CZ', 'CZ_PS_NODES');
1426: fnd_stats.gather_table_stats('CZ', 'CZ_XFR_PROJECT_BILLS');
1427: END IF;
1428:
1429: --AT: The calculation of maximum_selected is moved here as we do reading into memory in batches and cannot
1430: --calculate this inside the cycle which is possibly incomplete.

Line 1488: FROM CZ_XFR_PROJECT_BILLS P,CZ_PS_NODES B

1484:
1485: DECLARE
1486: CURSOR c_onl_ps_node IS
1487: SELECT B.ORIG_SYS_REF, B.COMPONENT_SEQUENCE_PATH, B.ps_node_id, B.ps_node_type
1488: FROM CZ_XFR_PROJECT_BILLS P,CZ_PS_NODES B
1489: WHERE B.DEVL_PROJECT_ID=P.model_ps_node_id
1490: AND P.organization_id = nORg_ID
1491: AND P.top_item_id = nTop_ID
1492: AND P.explosion_type = sExpl_type

Line 3213: SELECT CZ_XFR_PROJECT_BILLS_S.NEXTVAL INTO nModelId FROM DUAL;

3209: BEGIN
3210:
3211: IF(inCopyRootModel = '1')THEN
3212:
3213: SELECT CZ_XFR_PROJECT_BILLS_S.NEXTVAL INTO nModelId FROM DUAL;
3214:
3215: INSERT INTO CZ_XFR_PROJECT_BILLS
3216: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3217: source_server)

Line 3215: INSERT INTO CZ_XFR_PROJECT_BILLS

3211: IF(inCopyRootModel = '1')THEN
3212:
3213: SELECT CZ_XFR_PROJECT_BILLS_S.NEXTVAL INTO nModelId FROM DUAL;
3214:
3215: INSERT INTO CZ_XFR_PROJECT_BILLS
3216: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3217: source_server)
3218: SELECT inOrgId,inTopId,inExplType,'0',nModelId,inCopyChildModels,inServerId
3219: FROM DUAL;

Line 3229: FROM cz_xfr_project_bills p, cz_devl_projects d

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'

Line 3243: UPDATE cz_xfr_project_bills SET

3239: END;
3240:
3241: IF(nModelId IS NOT NULL)THEN
3242:
3243: UPDATE cz_xfr_project_bills SET
3244: deleted_flag = '0',
3245: copy_addl_child_models = inCopyChildModels,
3246: source_server = inServerId
3247: WHERE model_ps_node_id = nModelId;

Line 3251: SELECT CZ_XFR_PROJECT_BILLS_S.NEXTVAL INTO nModelId FROM DUAL;

3247: WHERE model_ps_node_id = nModelId;
3248:
3249: ELSE
3250:
3251: SELECT CZ_XFR_PROJECT_BILLS_S.NEXTVAL INTO nModelId FROM DUAL;
3252:
3253: INSERT INTO CZ_XFR_PROJECT_BILLS
3254: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3255: source_server)

Line 3253: INSERT INTO CZ_XFR_PROJECT_BILLS

3249: ELSE
3250:
3251: SELECT CZ_XFR_PROJECT_BILLS_S.NEXTVAL INTO nModelId FROM DUAL;
3252:
3253: INSERT INTO CZ_XFR_PROJECT_BILLS
3254: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3255: source_server)
3256: SELECT inOrgId,inTopId,inExplType,'0',nModelId,inCopyChildModels,inServerId
3257: FROM DUAL;

Line 3265: INSERT INTO CZ_XFR_PROJECT_BILLS

3261: ELSE
3262:
3263: nModelId := inRefreshModelId;
3264:
3265: INSERT INTO CZ_XFR_PROJECT_BILLS
3266: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3267: source_server)
3268: SELECT inOrgId,inTopId,inExplType,'0',inRefreshModelId,inCopyChildModels,inServerId
3269: FROM DUAL WHERE NOT EXISTS

Line 3270: (SELECT NULL FROM CZ_XFR_PROJECT_BILLS WHERE model_ps_node_id = inRefreshModelId);

3266: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3267: source_server)
3268: SELECT inOrgId,inTopId,inExplType,'0',inRefreshModelId,inCopyChildModels,inServerId
3269: FROM DUAL WHERE NOT EXISTS
3270: (SELECT NULL FROM CZ_XFR_PROJECT_BILLS WHERE model_ps_node_id = inRefreshModelId);
3271:
3272: UPDATE cz_xfr_project_bills SET
3273: deleted_flag = '0',
3274: copy_addl_child_models = inCopyChildModels,

Line 3272: UPDATE cz_xfr_project_bills SET

3268: SELECT inOrgId,inTopId,inExplType,'0',inRefreshModelId,inCopyChildModels,inServerId
3269: FROM DUAL WHERE NOT EXISTS
3270: (SELECT NULL FROM CZ_XFR_PROJECT_BILLS WHERE model_ps_node_id = inRefreshModelId);
3271:
3272: UPDATE cz_xfr_project_bills SET
3273: deleted_flag = '0',
3274: copy_addl_child_models = inCopyChildModels,
3275: source_server = inServerId
3276: WHERE model_ps_node_id = inRefreshModelId;

Line 3498: FROM cz_xfr_project_bills p, cz_devl_projects d

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'

Line 3662: NOUPDATE_SOURCE_BILL_DELETED:=CZ_UTILS.GET_NOUPDATE_FLAG('CZ_XFR_PROJECT_BILLS','SOURCE_BILL_DELETED', 'IMPORT');

3658: WHEN OTHERS THEN
3659: xERROR:=cz_utils.log_report(SQLERRM,1,'SINGLEBILL:COMMITSIZE',11276,x_run_id);
3660: END;
3661:
3662: NOUPDATE_SOURCE_BILL_DELETED:=CZ_UTILS.GET_NOUPDATE_FLAG('CZ_XFR_PROJECT_BILLS','SOURCE_BILL_DELETED', 'IMPORT');
3663: BEGIN
3664: OPEN C_BILL_OF_MATERIAL;
3665: FETCH C_BILL_OF_MATERIAL INTO cFound;
3666: IF(C_BILL_OF_MATERIAL%FOUND)THEN

Line 3708: UPDATE CZ_XFR_PROJECT_BILLS SET

3704: end if;
3705:
3706: IF(CZ_ORAAPPS_INTEGRATE.mRETCODE = 2)THEN RETURN; END IF;
3707:
3708: UPDATE CZ_XFR_PROJECT_BILLS SET
3709: SOURCE_BILL_DELETED=DECODE(NOUPDATE_SOURCE_BILL_DELETED,0,'0',SOURCE_BILL_DELETED)
3710: WHERE ORGANIZATION_ID=nOrg_ID AND TOP_ITEM_ID=nTop_ID AND EXPLOSION_TYPE=sExpl_type;
3711: ELSE
3712: UPDATE CZ_XFR_PROJECT_BILLS SET

Line 3712: UPDATE CZ_XFR_PROJECT_BILLS SET

3708: UPDATE CZ_XFR_PROJECT_BILLS SET
3709: SOURCE_BILL_DELETED=DECODE(NOUPDATE_SOURCE_BILL_DELETED,0,'0',SOURCE_BILL_DELETED)
3710: WHERE ORGANIZATION_ID=nOrg_ID AND TOP_ITEM_ID=nTop_ID AND EXPLOSION_TYPE=sExpl_type;
3711: ELSE
3712: UPDATE CZ_XFR_PROJECT_BILLS SET
3713: SOURCE_BILL_DELETED=DECODE(NOUPDATE_SOURCE_BILL_DELETED,0,'1',SOURCE_BILL_DELETED)
3714: WHERE ORGANIZATION_ID=nOrg_ID AND TOP_ITEM_ID=nTop_ID AND EXPLOSION_TYPE=sExpl_type;
3715: END IF;
3716: CLOSE C_BILL_OF_MATERIAL;

Line 3888: FROM cz_xfr_project_bills

3884: --only once for the very root project. For every run_id there is exactly one record in the table for
3885: --the root project (this is not necessarily true for the child models).
3886: BEGIN
3887: SELECT model_ps_node_id INTO nModelId
3888: FROM cz_xfr_project_bills
3889: WHERE organization_id = nOrg_ID
3890: AND top_item_id = nTop_ID
3891: AND explosion_type = sExpl_type
3892: AND last_import_run_id = genRun_ID;