APPS.WIP_FLOWUTIL_PRIV dependencies on WIP_FLOW_SCHEDULES

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

212: into l_src_code
213: from mtl_transactions_interface
214: where rowid = flow_rec.rowid;
215:
216: if(l_src_code = 'WIP_FLOW_SCHEDULES_OA' OR l_src_code = 'WIP_FLOW_SCHEDULES')
217: then l_fromUI := 1;
218: end if;
219:
220: if(l_fromUI = 0) then

Line 758: from wip_flow_schedules wfs

754: planned_quantity,
755: nvl(quantity_completed,0) as quantity_completed,
756: nvl(quantity_scrapped,0) as quantity_scrapped,
757: (planned_quantity - nvl(quantity_completed,0) - nvl(quantity_scrapped,0)) as open_quantity
758: from wip_flow_schedules wfs
759: where wfs.wip_entity_id = wipEntityId
760: ;
761:
762: cursor wip_entity_id_cursor(txn_header_id number) is

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

766: and rownum < 2
767: ;
768:
769: l_wfs_info wfs_info_cursor%ROWTYPE := null;
770: l_wip_entity_id number := null; -- use it to retrieve wip_flow_schedules info
771: begin
772:
773: if (l_logLevel <= wip_constants.trace_logging) then
774: l_params(1).paramName := 'p_txnHeaderID';

Line 1245: from wip_flow_schedules

1241:
1242: if ( l_wipEntityID is not null ) then
1243: select project_id, task_id
1244: into l_srcProjID, l_srcTaskID
1245: from wip_flow_schedules
1246: where wip_entity_id = l_wipEntityID;
1247: end if;
1248:
1249:

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

1292: null;
1293: end generateIssueLocator;
1294:
1295: /**
1296: * This procedure creates an entry in wip_flow_schedules and wip_entities for
1297: * unscheduled work orderless completion. Those entries are needed for the
1298: * following resource and material transactions.
1299: */
1300: procedure createFlowSchedule(p_txnInterfaceID in number := null,

Line 1622: insert into wip_flow_schedules(

1618: and organization_id = l_flowRec.organization_id;
1619:
1620: -- we do NOT need to insert an entry in wip_entities since there is a database
1621: -- trigger on wfs to do that
1622: insert into wip_flow_schedules(
1623: wip_entity_id,
1624: organization_id,
1625: last_update_date,
1626: last_updated_by,

Line 1890: from wip_flow_schedules

1886: select planned_quantity,
1887: quantity_completed
1888: into l_plannedQty,
1889: l_completedQty
1890: from wip_flow_schedules
1891: where wip_entity_id = l_wipEntityID;
1892:
1893: -- status change
1894: -- 0: no change, 1: reopen the schedule, 2: close the schedule

Line 1908: update wip_flow_schedules

1904: l_statusChange := 1;
1905: end if;
1906: end if;
1907:
1908: update wip_flow_schedules
1909: set quantity_completed = nvl(quantity_completed, 0) + l_cplQty,
1910: quantity_scrapped = nvl(quantity_scrapped, 0) + l_scrapQty,
1911: transacted_flag = 'Y',
1912: date_closed = decode(upper(nvl(l_flowSchedule, 'N')),