APPS.CZ_ORAAPPS_INTEGRATE dependencies on CZ_XFR_PROJECT_BILLS

Line 1624: 'FROM CZ_XFR_PROJECT_BILLS P, ' ||

1620: 'SELECT distinct T.DESCRIPTION, T.LANGUAGE, T.SOURCE_LANG, ' ||
1621: 'B.COMPONENT_SEQUENCE_ID,B.COMMON_COMPONENT_SEQUENCE_ID, ' ||
1622: 'P.TOP_ITEM_ID, P.EXPLOSION_TYPE, P.ORGANIZATION_ID, ' ||
1623: 'B.COMPONENT_ITEM_ID, B.BILL_SEQUENCE_ID, B.COMPONENT_CODE ' ||
1624: 'FROM CZ_XFR_PROJECT_BILLS P, ' ||
1625: 'BOM_EXPLOSIONS' || v_fndnam_link_name || ' B, ' ||
1626: 'BOM_BILL_OF_MATERIALS' || v_fndnam_link_name || ' BBM, ' ||
1627: 'MTL_SYSTEM_ITEMS_TL' || v_fndnam_link_name || ' T ' ||
1628: 'WHERE P.ORGANIZATION_ID=BBM.ORGANIZATION_ID ' ||

Line 1649: 'FROM CZ_XFR_PROJECT_BILLS P, ' ||

1645: 'SELECT distinct T.DESCRIPTION, F.LANGUAGE_CODE, F.LANGUAGE_CODE AS SOURCE_LANG, ' ||
1646: 'B.COMPONENT_SEQUENCE_ID,B.COMMON_COMPONENT_SEQUENCE_ID, ' ||
1647: 'P.TOP_ITEM_ID, P.EXPLOSION_TYPE, P.ORGANIZATION_ID, ' ||
1648: 'B.COMPONENT_ITEM_ID, B.BILL_SEQUENCE_ID, B.COMPONENT_CODE ' ||
1649: 'FROM CZ_XFR_PROJECT_BILLS P, ' ||
1650: 'BOM_EXPLOSIONS'|| v_fndnam_link_name || ' B, ' ||
1651: 'BOM_BILL_OF_MATERIALS'|| v_fndnam_link_name || ' BBM, ' ||
1652: 'MTL_SYSTEM_ITEMS'|| v_fndnam_link_name || ' T, ' ||
1653: 'FND_LANGUAGES'|| v_fndnam_link_name || ' F ' ||

Line 3079: lOrg_Id CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;

3075: COPY_CHILD_MODELS IN VARCHAR2 DEFAULT '0')
3076:
3077: AS
3078:
3079: lOrg_Id CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;
3080: lTop_Id CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;
3081: lCopy_Child_Models PLS_INTEGER;
3082:
3083: v_link_status VARCHAR2(1);

Line 3080: lTop_Id CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;

3076:
3077: AS
3078:
3079: lOrg_Id CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID%TYPE;
3080: lTop_Id CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID%TYPE;
3081: lCopy_Child_Models PLS_INTEGER;
3082:
3083: v_link_status VARCHAR2(1);
3084: v_code VARCHAR2(1);

Line 3187: UPDATE cz_xfr_project_bills

3183: BEGIN
3184: retcode:=0;
3185: errbuf:='';
3186:
3187: UPDATE cz_xfr_project_bills
3188: SET deleted_flag=Decode(iImportEnabled, 'Y', '0', 'N', '1', iImportEnabled)
3189: WHERE model_ps_node_id = iModel_Id;
3190:
3191: COMMIT;