DBA Data[Home] [Help]

APPS.FLM_EXECUTION_UTIL dependencies on WIP_LOT_SERIAL_OBJ_T

Line 1345: x_compInfo in out nocopy system.wip_lot_serial_obj_t,

1341: p_projectID in number,
1342: p_taskID in number,
1343: p_toOpSeqNum in number,
1344: p_altRoutDesig in varchar2,
1345: x_compInfo in out nocopy system.wip_lot_serial_obj_t,
1346: x_returnStatus out nocopy varchar2) IS
1347:
1348: CURSOR routing_seq_no_alt(p_org_id NUMBER, p_assembly_id NUMBER) IS
1349: select common_routing_sequence_id

Line 1363: l_compLotSerTbl system.wip_lot_serial_obj_t;

1359: and alternate_routing_designator = p_alt_desig;
1360:
1361:
1362: l_compTbl system.wip_component_tbl_t;
1363: l_compLotSerTbl system.wip_lot_serial_obj_t;
1364: l_rtg_seq_id NUMBER;
1365: l_curItem system.wip_component_obj_t;
1366:
1367: BEGIN

Line 1443: x_compTbl in out nocopy system.wip_lot_serial_obj_t,

1439: p_projectID in number,
1440: p_taskID in number,
1441: p_toOpSeqNum in number,
1442: p_rtg_seq_id in number,
1443: x_compTbl in out nocopy system.wip_lot_serial_obj_t,
1444: x_returnStatus out nocopy varchar2) is
1445:
1446: CURSOR sub_exist(p_org_id NUMBER, p_wip_ent_id NUMBER) IS
1447: select 1 as subs

Line 1694: x_compTbl in out nocopy system.wip_lot_serial_obj_t,

1690: p_projectID in number,
1691: p_taskID in number,
1692: p_toOpSeqNum in number,
1693: p_altRoutDesig in varchar2,
1694: x_compTbl in out nocopy system.wip_lot_serial_obj_t,
1695: x_returnStatus out nocopy varchar2) IS
1696: l_curItem system.wip_component_obj_t;
1697:
1698: cursor comp_lot (p_wip_ent_id NUMBER,