APPS.GME_TRANS_ENGINE_UTIL dependencies on PS_WHSE_EFF

Line 860: ,x_whse_code OUT NOCOPY ps_whse_eff.whse_code%TYPE

856:
857: PROCEDURE deduce_transaction_warehouse (
858: p_transaction IN ic_tran_pnd%ROWTYPE
859: ,p_item_master IN ic_item_mst%ROWTYPE
860: ,x_whse_code OUT NOCOPY ps_whse_eff.whse_code%TYPE
861: ,x_return_status OUT NOCOPY VARCHAR2)
862: IS
863: CURSOR cur_eff_whse (
864: p_orgn_code VARCHAR2

Line 869: FROM ps_whse_eff

865: ,p_item_id NUMBER
866: ,p_line_type NUMBER)
867: IS
868: SELECT whse_code
869: FROM ps_whse_eff
870: WHERE plant_code = p_orgn_code
871: AND (whse_item_id IS NULL OR whse_item_id = p_item_id)
872: AND ( (p_line_type > 0 AND replen_ind = 1)
873: OR (p_line_type < 0 AND consum_ind = 1) )

Line 943: l_tran_whse ps_whse_eff.whse_code%TYPE;

939: FROM ic_whse_mst
940: WHERE whse_code = v_whse_code;
941:
942: get_trans_rec cur_get_def_trans%ROWTYPE;
943: l_tran_whse ps_whse_eff.whse_code%TYPE;
944: l_return_status VARCHAR2 (1);
945: l_api_name CONSTANT VARCHAR2 (30) := 'GET_DEFAULT_LOT';
946: l_batch_type gme_batch_header.batch_type%TYPE;
947: l_doc_type gme_inventory_txns_gtmp.doc_type%TYPE;