APPS.WIP_FLOW_UTILITIES dependencies on WIP_FLOW_SCHEDULES

Line 409: from wip_flow_schedules wfs,

405: status type, as the schedule has to
406: be open */
407:
408: select 1 into x_success
409: from wip_flow_schedules wfs,
410: mtl_transactions_interface mti
411: where wfs.wip_entity_id = p_txn_src_id
412: and wfs.organization_id = p_organization_id
413: and trunc(wfs.scheduled_completion_date,WIP_CONSTANTS.DATE_FMT) =

Line 989: -- Error creating the wip flow schedules

985: exception
986:
987: when others then
988:
989: -- Error creating the wip flow schedules
990: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_CREATION');
991: fnd_message.set_token('ENTITY1',to_char(p_header_id));
992: x_message := fnd_message.get ;
993:

Line 1117: Insert into wip_flow_schedules(

1113: and organization_id = p_organization_id;
1114:
1115:
1116: /* Create the New Flow Schedule */
1117: Insert into wip_flow_schedules(
1118: WIP_ENTITY_ID,
1119: ORGANIZATION_ID,
1120: LAST_UPDATE_DATE,
1121: LAST_UPDATED_BY,

Line 1292: delete wip_flow_schedules

1288: FOR del_rec in del_flow(p_header_id) LOOP
1289:
1290: BEGIN
1291:
1292: delete wip_flow_schedules
1293: where wip_entity_id = del_rec.transaction_source_id
1294: and organization_id = del_rec.organization_id ;
1295:
1296: update mtl_transactions_interface

Line 1304: -- Error deleting the wip flow schedules

1300: exception
1301:
1302: when others then
1303:
1304: -- Error deleting the wip flow schedules
1305: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_DELETION');
1306: fnd_message.set_token('ENTITY1',
1307: to_char(del_rec.transaction_interface_id) );
1308: x_message := fnd_message.get ;

Line 1329: -- Error deleting the wip flow schedules

1325: exception
1326:
1327: when others then
1328:
1329: -- Error deleting the wip flow schedules
1330: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_DELETION');
1331: fnd_message.set_token('ENTITY1',
1332: to_char(p_header_id) );
1333: x_message := fnd_message.get ;

Line 1359: delete wip_flow_schedules

1355:
1356: procedure Delete_Flow_Schedule( p_wip_entity_id in number ) is
1357: begin
1358:
1359: delete wip_flow_schedules
1360: where wip_entity_id = p_wip_entity_id ;
1361:
1362: exception
1363: when others then

Line 1430: Update wip_flow_schedules

1426: -- Set the DATE_CLOSED and STATUS based on :
1427: -- 1. NVL(p_schedule_flag,'N') = 'Y'
1428: -- 2. Status_Change() returns value
1429:
1430: Update wip_flow_schedules
1431: set QUANTITY_COMPLETED = Nvl(QUANTITY_COMPLETED,0)+(p_quantity_completed * -1), -- CFM Scrap
1432: QUANTITY_SCRAPPED = Nvl(QUANTITY_SCRAPPED,0)+(p_quantity_scrapped * -1), -- CFM Scrap
1433: TRANSACTED_FLAG = 'Y',
1434: DATE_CLOSED =

Line 1731: from wip_flow_schedules

1727: AND process_flag <> 3 ;
1728:
1729:
1730: select 1 into l_unsched
1731: from wip_flow_schedules
1732: where wip_entity_id = p_wip_entity_id
1733: and scheduled_flag <> 1;
1734:
1735: if(l_unsched = 1) then

Line 1745: -- Error Deleting the wip flow schedules

1741: exception
1742: when no_data_found then
1743: return 1;
1744: when others then
1745: -- Error Deleting the wip flow schedules
1746: fnd_message.set_name('WIP', 'WIP_FLOW_CLEANUP_ERROR');
1747: p_err_mesg := fnd_message.get ;
1748: return 0;
1749: