APPS.CZ_IMP_SINGLE dependencies on CZ_XFR_PROJECT_BILLS_S

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 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 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 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;