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.

[Home] [Help]

APPS.CZ_IMP_SINGLE dependencies on CZ_XFR_PROJECT_BILLS

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 1480: fnd_stats.gather_table_stats('CZ', 'CZ_XFR_PROJECT_BILLS');

1476: x_error:=cz_utils.log_report('Gather Stats : Start' ,1,'EXTRACTION',11299,inRun_Id);
1477: fnd_stats.gather_table_stats('CZ', 'CZ_IMP_PS_NODES');
1478: --bug 9496782 comment out following call
1479: -- fnd_stats.gather_table_stats('CZ', 'CZ_PS_NODES');
1480: fnd_stats.gather_table_stats('CZ', 'CZ_XFR_PROJECT_BILLS');
1481: x_error:=cz_utils.log_report('Gather Stats : End',1,'EXTRACTION',11299,inRun_Id);
1482:
1483: if (CZ_IMP_ALL.get_time) then
1484: end_time := dbms_utility.get_time();

Line 1550: FROM CZ_XFR_PROJECT_BILLS P,CZ_PS_NODES B

1546:
1547: DECLARE
1548: CURSOR c_onl_ps_node IS
1549: SELECT B.ORIG_SYS_REF, B.COMPONENT_SEQUENCE_PATH, B.ps_node_id, B.ps_node_type
1550: FROM CZ_XFR_PROJECT_BILLS P,CZ_PS_NODES B
1551: WHERE B.DEVL_PROJECT_ID=P.model_ps_node_id
1552: AND P.organization_id = nORg_ID
1553: AND P.top_item_id = nTop_ID
1554: AND P.explosion_type = sExpl_type

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

3408:
3409:
3410: IF(inCopyRootModel = '1')THEN
3411:
3412: SELECT CZ_XFR_PROJECT_BILLS_S.NEXTVAL INTO nModelId FROM DUAL;
3413:
3414: INSERT INTO CZ_XFR_PROJECT_BILLS
3415: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3416: source_server)

Line 3414: INSERT INTO CZ_XFR_PROJECT_BILLS

3410: IF(inCopyRootModel = '1')THEN
3411:
3412: SELECT CZ_XFR_PROJECT_BILLS_S.NEXTVAL INTO nModelId FROM DUAL;
3413:
3414: INSERT INTO CZ_XFR_PROJECT_BILLS
3415: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3416: source_server)
3417: SELECT inOrgId,inTopId,inExplType,'0',nModelId,inCopyChildModels,inServerId
3418: FROM DUAL;

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 3450: -- If record does not exist in cz_xfr_project_bills for model that is import_enabled

3446: IF(nModelId IS NOT NULL AND nModelId > 0) THEN
3447:
3448: --LA 9595142
3449: IF (disableMultipleCopyImport = 1) THEN
3450: -- If record does not exist in cz_xfr_project_bills for model that is import_enabled
3451: -- then insert that record in cz_xfr_project_bills
3452: -- This'll be required when copy is enabled for refresh
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,

Line 3451: -- then insert that record in cz_xfr_project_bills

3447:
3448: --LA 9595142
3449: IF (disableMultipleCopyImport = 1) THEN
3450: -- If record does not exist in cz_xfr_project_bills for model that is import_enabled
3451: -- then insert that record in cz_xfr_project_bills
3452: -- This'll be required when copy is enabled for refresh
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)

Line 3453: INSERT INTO CZ_XFR_PROJECT_BILLS

3449: IF (disableMultipleCopyImport = 1) THEN
3450: -- If record does not exist in cz_xfr_project_bills for model that is import_enabled
3451: -- then insert that record in cz_xfr_project_bills
3452: -- This'll be required when copy is enabled for refresh
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

Line 3463: (SELECT NULL FROM CZ_XFR_PROJECT_BILLS WHERE model_ps_node_id = d.devl_project_id);

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:
3466: UPDATE cz_xfr_project_bills SET
3467: deleted_flag = '0',

Line 3466: UPDATE cz_xfr_project_bills SET

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:
3466: UPDATE cz_xfr_project_bills SET
3467: deleted_flag = '0',
3468: copy_addl_child_models = inCopyChildModels,
3469: source_server = inServerId
3470: WHERE model_ps_node_id = nModelId;

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

3470: WHERE model_ps_node_id = nModelId;
3471:
3472: ELSE
3473:
3474: SELECT CZ_XFR_PROJECT_BILLS_S.NEXTVAL INTO nModelId FROM DUAL;
3475:
3476: INSERT INTO CZ_XFR_PROJECT_BILLS
3477: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3478: source_server)

Line 3476: INSERT INTO CZ_XFR_PROJECT_BILLS

3472: ELSE
3473:
3474: SELECT CZ_XFR_PROJECT_BILLS_S.NEXTVAL INTO nModelId FROM DUAL;
3475:
3476: INSERT INTO CZ_XFR_PROJECT_BILLS
3477: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3478: source_server)
3479: SELECT inOrgId,inTopId,inExplType,'0',nModelId,inCopyChildModels,inServerId
3480: FROM DUAL;

Line 3493: INSERT INTO CZ_XFR_PROJECT_BILLS

3489: IF (disableMultipleCopyImport = 1) THEN
3490: checkImpEnabled(inExplType || ':' || inOrgId || ':' || inTopId, inTopId, inRunId, inRefreshModelId,nModelId, -1);
3491: END IF;
3492:
3493: INSERT INTO CZ_XFR_PROJECT_BILLS
3494: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3495: source_server)
3496: SELECT inOrgId,inTopId,inExplType,'0',inRefreshModelId,inCopyChildModels,inServerId
3497: FROM DUAL WHERE NOT EXISTS

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

3494: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3495: source_server)
3496: SELECT inOrgId,inTopId,inExplType,'0',inRefreshModelId,inCopyChildModels,inServerId
3497: FROM DUAL WHERE NOT EXISTS
3498: (SELECT NULL FROM CZ_XFR_PROJECT_BILLS WHERE model_ps_node_id = inRefreshModelId);
3499:
3500: UPDATE cz_xfr_project_bills SET
3501: deleted_flag = '0',
3502: copy_addl_child_models = inCopyChildModels,

Line 3500: UPDATE cz_xfr_project_bills SET

3496: SELECT inOrgId,inTopId,inExplType,'0',inRefreshModelId,inCopyChildModels,inServerId
3497: FROM DUAL WHERE NOT EXISTS
3498: (SELECT NULL FROM CZ_XFR_PROJECT_BILLS WHERE model_ps_node_id = inRefreshModelId);
3499:
3500: UPDATE cz_xfr_project_bills SET
3501: deleted_flag = '0',
3502: copy_addl_child_models = inCopyChildModels,
3503: source_server = inServerId
3504: WHERE model_ps_node_id = inRefreshModelId;

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 3989: NOUPDATE_SOURCE_BILL_DELETED:=CZ_UTILS.GET_NOUPDATE_FLAG('CZ_XFR_PROJECT_BILLS','SOURCE_BILL_DELETED', 'IMPORT');

3985: disableMultipleCopyImport := 0;
3986: END;
3987:
3988:
3989: NOUPDATE_SOURCE_BILL_DELETED:=CZ_UTILS.GET_NOUPDATE_FLAG('CZ_XFR_PROJECT_BILLS','SOURCE_BILL_DELETED', 'IMPORT');
3990: BEGIN
3991: OPEN C_BILL_OF_MATERIAL;
3992: FETCH C_BILL_OF_MATERIAL INTO cFound;
3993: IF(C_BILL_OF_MATERIAL%FOUND)THEN

Line 4041: UPDATE CZ_XFR_PROJECT_BILLS SET

4037: end if;
4038:
4039: IF(CZ_ORAAPPS_INTEGRATE.mRETCODE = 2)THEN RETURN; END IF;
4040:
4041: UPDATE CZ_XFR_PROJECT_BILLS SET
4042: SOURCE_BILL_DELETED=DECODE(NOUPDATE_SOURCE_BILL_DELETED,0,'0',SOURCE_BILL_DELETED)
4043: WHERE ORGANIZATION_ID=nOrg_ID AND TOP_ITEM_ID=nTop_ID AND EXPLOSION_TYPE=sExpl_type;
4044: ELSE
4045: UPDATE CZ_XFR_PROJECT_BILLS SET

Line 4045: UPDATE CZ_XFR_PROJECT_BILLS SET

4041: UPDATE CZ_XFR_PROJECT_BILLS SET
4042: SOURCE_BILL_DELETED=DECODE(NOUPDATE_SOURCE_BILL_DELETED,0,'0',SOURCE_BILL_DELETED)
4043: WHERE ORGANIZATION_ID=nOrg_ID AND TOP_ITEM_ID=nTop_ID AND EXPLOSION_TYPE=sExpl_type;
4044: ELSE
4045: UPDATE CZ_XFR_PROJECT_BILLS SET
4046: SOURCE_BILL_DELETED=DECODE(NOUPDATE_SOURCE_BILL_DELETED,0,'1',SOURCE_BILL_DELETED)
4047: WHERE ORGANIZATION_ID=nOrg_ID AND TOP_ITEM_ID=nTop_ID AND EXPLOSION_TYPE=sExpl_type;
4048: END IF;
4049: CLOSE C_BILL_OF_MATERIAL;

Line 4238: FROM cz_xfr_project_bills

4234: --only once for the very root project. For every run_id there is exactly one record in the table for
4235: --the root project (this is not necessarily true for the child models).
4236: BEGIN
4237: SELECT model_ps_node_id INTO nModelId
4238: FROM cz_xfr_project_bills
4239: WHERE organization_id = nOrg_ID
4240: AND top_item_id = nTop_ID
4241: AND explosion_type = sExpl_type
4242: AND last_import_run_id = genRun_ID;