APPS.CZ_IMP_SINGLE dependencies on CZ_XFR_PROJECT_BILLS_S

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