APPS.WIP_FLOW_UTILITIES dependencies on WIP_CONSTANTS

Line 413: and trunc(wfs.scheduled_completion_date,WIP_CONSTANTS.DATE_FMT) =

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) =
414: trunc(mti.transaction_date,WIP_CONSTANTS.DATE_FMT)
415: and mti.rowid = p_rowid;
416:
417:

Line 414: trunc(mti.transaction_date,WIP_CONSTANTS.DATE_FMT)

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) =
414: trunc(mti.transaction_date,WIP_CONSTANTS.DATE_FMT)
415: and mti.rowid = p_rowid;
416:
417:
418: exception

Line 2334: and mti.transaction_action_id in (1,27,33,34) /*wip_constants.isscomp_action, wip_constants.retcomp_action, wip_constants.issnegc_action, wip_constants.retnegc_action)*/

2330: from mtl_transactions_interface mti,
2331: mtl_system_items_kfv msi
2332: where mti.parent_id = txn_interface_id
2333: and nvl(mti.operation_seq_num, 1) > 0 /* not for phatom assembly */
2334: and mti.transaction_action_id in (1,27,33,34) /*wip_constants.isscomp_action, wip_constants.retcomp_action, wip_constants.issnegc_action, wip_constants.retnegc_action)*/
2335: and mti.inventory_item_id = msi.inventory_item_id
2336: and mti.organization_id = msi.organization_id
2337: and msi.lot_control_code = 2
2338: and msi.serial_number_control_code = 1;

Line 2487: wip_constants.max_displayed_precision));

2483: fetch c_lot into l_lotNumber;
2484:
2485: l_qty := abs(round(l_cur_lot.primary_quantity *
2486: l_lotItemsRecords.transaction_quantity/l_lotItemsRecords.primary_quantity,
2487: wip_constants.max_displayed_precision));
2488: insert into mtl_transaction_lots_temp
2489: (
2490: transaction_temp_id,
2491: last_update_date,