APPS.GME_MOBILE_TXN dependencies on GME_PENDING_PRODUCT_LOTS

Line 113: gme_pending_product_lots_pvt.relieve_pending_lot(p_pending_lot_id => p_rsrv_pndlot_id

109: ,x_data => x_error_msg);
110:
111: END IF;
112: ELSE
113: gme_pending_product_lots_pvt.relieve_pending_lot(p_pending_lot_id => p_rsrv_pndlot_id
114: ,p_quantity => p_relieve_qty
115: ,p_secondary_quantity=> p_sec_qty
116: ,x_return_status => x_return_status);
117:

Line 1973: gme_pending_product_lots l,

1969: NVL (l.reason_id, -1),
1970: reason_name,
1971: TO_CHAR(l.last_update_date, 'MM/DD/YYYY HH24:MI:SS')
1972: FROM
1973: gme_pending_product_lots l,
1974: mtl_transaction_reasons r,
1975: gme_material_details m, -- nsinghi bug#5236906. Add join to gme_material_details and MLN
1976: mtl_lot_numbers n
1977: WHERE

Line 2036: gme_pending_product_lots l,

2032: NVL (l.reason_id, -1),
2033: reason_name,
2034: TO_CHAR(l.last_update_date, 'MM/DD/YYYY HH24:MI:SS')
2035: FROM
2036: gme_pending_product_lots l,
2037: mtl_transaction_reasons r,
2038: gme_material_details m,
2039: mtl_lot_numbers n
2040: WHERE

Line 2091: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;

2087: p_create_lot IN VARCHAR2,
2088: x_return_status OUT NOCOPY VARCHAR2,
2089: x_error_msg OUT NOCOPY VARCHAR2)
2090: IS
2091: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2092: l_out_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2093: l_material_detail_rec gme_material_details%ROWTYPE;
2094: l_in_material_detail_rec gme_material_details%ROWTYPE;
2095: l_batch_header_rec gme_batch_header%ROWTYPE;

Line 2092: l_out_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;

2088: x_return_status OUT NOCOPY VARCHAR2,
2089: x_error_msg OUT NOCOPY VARCHAR2)
2090: IS
2091: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2092: l_out_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2093: l_material_detail_rec gme_material_details%ROWTYPE;
2094: l_in_material_detail_rec gme_material_details%ROWTYPE;
2095: l_batch_header_rec gme_batch_header%ROWTYPE;
2096: l_message_count NUMBER;

Line 2220: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;

2216: p_is_seq_changed IN VARCHAR2,
2217: x_return_status OUT NOCOPY VARCHAR2,
2218: x_error_msg OUT NOCOPY VARCHAR2)
2219: IS
2220: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2221: l_out_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2222: l_material_detail_rec gme_material_details%ROWTYPE;
2223: l_in_material_detail_rec gme_material_details%ROWTYPE;
2224: l_batch_header_rec gme_batch_header%ROWTYPE;

Line 2221: l_out_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;

2217: x_return_status OUT NOCOPY VARCHAR2,
2218: x_error_msg OUT NOCOPY VARCHAR2)
2219: IS
2220: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2221: l_out_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2222: l_material_detail_rec gme_material_details%ROWTYPE;
2223: l_in_material_detail_rec gme_material_details%ROWTYPE;
2224: l_batch_header_rec gme_batch_header%ROWTYPE;
2225: l_message_count NUMBER;

Line 3053: FROM gme_pending_product_lots

3049: WHERE material_detail_id = p_material_detail_id;
3050:
3051: CURSOR Get_pplot_count IS
3052: SELECT count(*)
3053: FROM gme_pending_product_lots
3054: WHERE batch_id = p_batch_id;
3055:
3056: ITEM_NOT_VALID EXCEPTION;
3057: l_release_type NUMBER;