APPS.WIP_FLOWUTIL_PRIV dependencies on WIP_FLOW_SCHEDULES

Line 207: if(l_src_code = 'WIP_FLOW_SCHEDULES_OA' OR l_src_code = 'WIP_FLOW_SCHEDULES')

203: into l_src_code
204: from mtl_transactions_interface
205: where rowid = flow_rec.rowid;
206:
207: if(l_src_code = 'WIP_FLOW_SCHEDULES_OA' OR l_src_code = 'WIP_FLOW_SCHEDULES')
208: then l_fromUI := 1;
209: end if;
210:
211: if(l_fromUI = 0) then

Line 727: from wip_flow_schedules wfs

723: planned_quantity,
724: nvl(quantity_completed,0) as quantity_completed,
725: nvl(quantity_scrapped,0) as quantity_scrapped,
726: (planned_quantity - nvl(quantity_completed,0) - nvl(quantity_scrapped,0)) as open_quantity
727: from wip_flow_schedules wfs
728: where wfs.wip_entity_id = wipEntityId
729: ;
730:
731: cursor wip_entity_id_cursor(txn_header_id number) is

Line 739: l_wip_entity_id number := null; -- use it to retrieve wip_flow_schedules info

735: and rownum < 2
736: ;
737:
738: l_wfs_info wfs_info_cursor%ROWTYPE := null;
739: l_wip_entity_id number := null; -- use it to retrieve wip_flow_schedules info
740: begin
741:
742: if (l_logLevel <= wip_constants.trace_logging) then
743: l_params(1).paramName := 'p_txnHeaderID';

Line 1214: from wip_flow_schedules

1210:
1211: if ( l_wipEntityID is not null ) then
1212: select project_id, task_id
1213: into l_srcProjID, l_srcTaskID
1214: from wip_flow_schedules
1215: where wip_entity_id = l_wipEntityID;
1216: end if;
1217:
1218:

Line 1265: * This procedure creates an entry in wip_flow_schedules and wip_entities for

1261: null;
1262: end generateIssueLocator;
1263:
1264: /**
1265: * This procedure creates an entry in wip_flow_schedules and wip_entities for
1266: * unscheduled work orderless completion. Those entries are needed for the
1267: * following resource and material transactions.
1268: */
1269: procedure createFlowSchedule(p_txnInterfaceID in number := null,

Line 1591: insert into wip_flow_schedules(

1587: and organization_id = l_flowRec.organization_id;
1588:
1589: -- we do NOT need to insert an entry in wip_entities since there is a database
1590: -- trigger on wfs to do that
1591: insert into wip_flow_schedules(
1592: wip_entity_id,
1593: organization_id,
1594: last_update_date,
1595: last_updated_by,

Line 1859: from wip_flow_schedules

1855: select planned_quantity,
1856: quantity_completed
1857: into l_plannedQty,
1858: l_completedQty
1859: from wip_flow_schedules
1860: where wip_entity_id = l_wipEntityID;
1861:
1862: -- status change
1863: -- 0: no change, 1: reopen the schedule, 2: close the schedule

Line 1877: update wip_flow_schedules

1873: l_statusChange := 1;
1874: end if;
1875: end if;
1876:
1877: update wip_flow_schedules
1878: set quantity_completed = nvl(quantity_completed, 0) + l_cplQty,
1879: quantity_scrapped = nvl(quantity_scrapped, 0) + l_scrapQty,
1880: transacted_flag = 'Y',
1881: date_closed = decode(upper(nvl(l_flowSchedule, 'N')),