3077: COPY_CHILD_MODELS IN VARCHAR2 DEFAULT '0')
3078:
3079: AS
3080:
3081: lOrg_Id CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;
3082: lTop_Id CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;
3083: lCopy_Child_Models PLS_INTEGER;
3084:
3085: v_link_status VARCHAR2(1);
3078:
3079: AS
3080:
3081: lOrg_Id CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;
3082: lTop_Id CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;
3083: lCopy_Child_Models PLS_INTEGER;
3084:
3085: v_link_status VARCHAR2(1);
3086: v_code VARCHAR2(1);
3185: BEGIN
3186: retcode:=0;
3187: errbuf:='';
3188:
3189: UPDATE cz_xfr_project_bills
3190: SET deleted_flag=Decode(iImportEnabled, 'Y', '0', 'N', '1', iImportEnabled)
3191: WHERE model_ps_node_id = iModel_Id;
3192:
3193: COMMIT;