APPS.GME_TRANS_ENGINE_UTIL dependencies on GME_BATCH_HEADER

Line 22: p_batch_row IN gme_batch_header%ROWTYPE

18: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_TRANS_ENGINE_UTIL';
19: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
20:
21: PROCEDURE load_mat_and_rsc_trans (
22: p_batch_row IN gme_batch_header%ROWTYPE
23: ,x_mat_row_count OUT NOCOPY NUMBER
24: ,x_rsc_row_count OUT NOCOPY NUMBER
25: ,x_return_status OUT NOCOPY VARCHAR2)
26: IS

Line 648: p_batch_row IN gme_batch_header%ROWTYPE

644: Rishi Varma B3818266/3759970 10-08-2004
645: Added the condition for elimination of reversed records
646: =============================================================================================*/
647: PROCEDURE load_rsrc_trans (
648: p_batch_row IN gme_batch_header%ROWTYPE
649: ,x_rsc_row_count OUT NOCOPY NUMBER
650: ,x_return_status OUT NOCOPY VARCHAR2)
651: IS
652: CURSOR c_get_reversal_resources

Line 817: p_batch_row IN gme_batch_header%ROWTYPE

813: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
814: END load_rsrc_trans;
815:
816: PROCEDURE set_default_lot_for_batch (
817: p_batch_row IN gme_batch_header%ROWTYPE
818: ,x_return_status OUT NOCOPY VARCHAR2)
819: IS
820: CURSOR cur_get_matl (v_batch_id gme_batch_header.batch_id%TYPE)
821: IS

Line 820: CURSOR cur_get_matl (v_batch_id gme_batch_header.batch_id%TYPE)

816: PROCEDURE set_default_lot_for_batch (
817: p_batch_row IN gme_batch_header%ROWTYPE
818: ,x_return_status OUT NOCOPY VARCHAR2)
819: IS
820: CURSOR cur_get_matl (v_batch_id gme_batch_header.batch_id%TYPE)
821: IS
822: SELECT material_detail_id
823: FROM gme_material_details
824: WHERE batch_id = v_batch_id;

Line 912: v_batch_id gme_batch_header.batch_id%TYPE

908: l_whse_loct_ctl ic_whse_mst.whse_code%TYPE;
909: l_def_lot_found BOOLEAN;
910:
911: CURSOR cur_get_def_trans (
912: v_batch_id gme_batch_header.batch_id%TYPE
913: ,v_line_id gme_material_details.material_detail_id%TYPE
914: ,v_doc_type gme_inventory_txns_gtmp.doc_type%TYPE)
915: IS
916: SELECT trans_id, whse_code

Line 946: l_batch_type gme_batch_header.batch_type%TYPE;

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;
948: l_cnt NUMBER;
949: error_deduce_trans_whse EXCEPTION;
950: -- corrupt_batch EXCEPTION;

Line 968: FROM gme_batch_header

964: WHERE item_id = l_matl_dtl.item_id;
965:
966: SELECT batch_type
967: INTO l_batch_type
968: FROM gme_batch_header
969: WHERE batch_id = l_matl_dtl.batch_id;
970:
971: IF (l_batch_type = 0) THEN
972: l_doc_type := 'PROD';