DBA Data[Home] [Help]

APPS.MIGRATE_BATCH dependencies on IC_ITEM_MST

Line 4800: l_item_mst ic_item_mst%ROWTYPE;

4796: x_is_plain OUT NOCOPY BOOLEAN,
4797: x_return_status OUT NOCOPY VARCHAR2
4798: ) IS
4799: l_matl_dtl pm_matl_dtl_bak%ROWTYPE;
4800: l_item_mst ic_item_mst%ROWTYPE;
4801: l_ic_tran_pnd ic_tran_pnd%ROWTYPE;
4802: l_whse_loct_ctl ic_whse_mst.whse_code%TYPE;
4803: l_def_lot_found BOOLEAN;
4804:

Line 4856: FROM ic_item_mst

4852: WHERE line_id = p_line_id;
4853: l_pos := 2;
4854: SELECT *
4855: INTO l_item_mst
4856: FROM ic_item_mst
4857: WHERE item_id = l_matl_dtl.item_id;
4858: l_pos := 3;
4859: l_def_lot_found := FALSE;
4860: x_def_lot_id := 0;

Line 4985: p_item_master IN ic_item_mst%ROWTYPE,

4981: END get_default_lot;
4982:
4983: PROCEDURE deduce_transaction_warehouse (
4984: p_transaction IN ic_tran_pnd%ROWTYPE,
4985: p_item_master IN ic_item_mst%ROWTYPE,
4986: x_whse_code OUT NOCOPY ps_whse_eff.whse_code%TYPE
4987: ) IS
4988: CURSOR cur_eff_whse (
4989: p_orgn_code VARCHAR2,