APPS.GMI_AUTO_ALLOC_BATCH_PKG dependencies on GMI_AUTO_ALLOCATION_BATCH

Line 83: l_batch_rec gmi_auto_allocation_batch%rowtype;

79: x_msg_data VARCHAR2(2000);
80: x_return_status VARCHAR2(1);
81:
82: l_wdd_rec wsh_delivery_details%rowtype;
83: l_batch_rec gmi_auto_allocation_batch%rowtype;
84: l_where_clause VARCHAR2(3000):= NULL;
85: l_number_of_rows NUMBER;
86: l_order_by VARCHAR2(3000):= NULL;
87: l_detailed_qty NUMBER;

Line 104: FROM gmi_auto_allocation_batch

100: WHERE wdd.delivery_detail_id = p_delivery_detail_id;
101:
102: CURSOR Get_Batch_Rec_Cur IS
103: SELECT *
104: FROM gmi_auto_allocation_batch
105: WHERE batch_id = p_batch_id;
106:
107: TYPE wdd_rc IS REF CURSOR;
108: wdd_cur1 wdd_rc;

Line 507: | p_batch_rec gmi_auto_allocation_batch%rowtype

503: | x_return_status Return status
504: | x_msg_count Number of messages in the list
505: | x_msg_data Text of messages
506: | p_wdd_rec wsh_delivery_details%rowtype
507: | p_batch_rec gmi_auto_allocation_batch%rowtype
508: | x_number_of_rows
509: | x_qc_grade
510: | x_detailed_qty
511: | x_qty_UM

Line 531: , p_batch_rec IN gmi_auto_allocation_batch%rowtype

527: p_api_version IN NUMBER
528: , p_init_msg_list IN VARCHAR2
529: , p_commit IN VARCHAR2
530: , p_wdd_rec IN wsh_delivery_details%rowtype
531: , p_batch_rec IN gmi_auto_allocation_batch%rowtype
532: , x_number_of_rows OUT NOCOPY NUMBER
533: , x_qc_grade OUT NOCOPY VARCHAR2
534: , x_detailed_qty OUT NOCOPY NUMBER
535: , x_qty_UM OUT NOCOPY VARCHAR2

Line 1241: GMI_Reservation_Util.PrintLn('(opm_dbg) End of GMI_auto_allocation_batch_pkg.Call_Pick_Confirm, l_return_status is '

1237:
1238: GMI_Reservation_Util.PrintLn('(opm_dbg) Before setting the return value 3');
1239: x_qty_UM2 := ll_mo_line_tbl(1).secondary_uom_code;
1240:
1241: GMI_Reservation_Util.PrintLn('(opm_dbg) End of GMI_auto_allocation_batch_pkg.Call_Pick_Confirm, l_return_status is '
1242: || l_return_status);
1243:
1244: EXCEPTION
1245: WHEN FND_API.G_EXC_ERROR THEN

Line 1543: p_auto_alloc_batch_rec IN gmi_auto_allocation_batch%ROWTYPE )

1539: END Get_Allocation_Record;
1540:
1541:
1542: PROCEDURE Insert_Row (
1543: p_auto_alloc_batch_rec IN gmi_auto_allocation_batch%ROWTYPE )
1544: IS
1545: l_err_no NUMBER;
1546: l_err_msg VARCHAR2(100);
1547:

Line 1549: INSERT INTO GMI_AUTO_ALLOCATION_BATCH (

1545: l_err_no NUMBER;
1546: l_err_msg VARCHAR2(100);
1547:
1548: BEGIN
1549: INSERT INTO GMI_AUTO_ALLOCATION_BATCH (
1550: BATCH_ID
1551: ,NAME
1552: ,FROM_ORDER_HEADER_NO
1553: ,TO_ORDER_HEADER_NO