APPS.GML_OPM_ROI_GRP dependencies on IC_LOTS_MST

Line 532: FROM ic_lots_mst

528: l_progress VARCHAR2(4) := '010' ;
529:
530: CURSOR Cur_lot_ctrl_lot IS
531: SELECT lot_id,inactive_ind,delete_mark
532: FROM ic_lots_mst
533: WHERE lot_no = p_lot_attribute_rec.lot_no
534: AND item_id = p_lot_attribute_rec.opm_item_id ;
535:
536:

Line 539: FROM ic_lots_mst

535:
536:
537: CURSOR Cur_sublot_ctrl_lot IS
538: SELECT lot_id,inactive_ind,delete_mark
539: FROM ic_lots_mst
540: WHERE lot_no = p_lot_attribute_rec.lot_no
541: AND item_id = p_lot_attribute_rec.opm_item_id
542: AND sublot_no = p_lot_attribute_rec.sublot_no ;
543:

Line 961: l_ic_lots_mst_rec ic_lots_mst%ROWTYPE;

957: p_rti_id IN NUMBER,
958: x_return_status OUT NOCOPY VARCHAR2 ) IS
959:
960: l_new_lot_rec GMIGAPI.lot_rec_typ;
961: l_ic_lots_mst_rec ic_lots_mst%ROWTYPE;
962: l_ic_lots_cpg_rec ic_lots_cpg%ROWTYPE;
963: l_msg_count NUMBER(3);
964: l_msg_data VARCHAR2(2000);
965: l_inv_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 1016: , x_ic_lots_mst_row => l_ic_lots_mst_rec

1012: , p_init_msg_list => 'F'
1013: , p_commit => 'F'
1014: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1015: , p_lot_rec => l_new_lot_rec
1016: , x_ic_lots_mst_row => l_ic_lots_mst_rec
1017: , x_ic_lots_cpg_row => l_ic_lots_cpg_rec
1018: , x_return_status => x_return_status
1019: , x_msg_count => l_msg_count
1020: , x_msg_data => l_msg_data

Line 1315: l_lot_no ic_lots_mst.lot_no%TYPE;

1311: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
1312: l_lot_attribute_rec gml_opm_roi_grp.lot_attributes_rec_type ;
1313:
1314: l_new_lot_rec GMIGAPI.lot_rec_typ;
1315: l_lot_no ic_lots_mst.lot_no%TYPE;
1316: l_sublot_no ic_lots_mst.sublot_no%TYPE;
1317: l_lot_expiration_date DATE ;
1318: l_lot_quantity NUMBER;
1319: l_lot_secondary_quantity NUMBER;

Line 1316: l_sublot_no ic_lots_mst.sublot_no%TYPE;

1312: l_lot_attribute_rec gml_opm_roi_grp.lot_attributes_rec_type ;
1313:
1314: l_new_lot_rec GMIGAPI.lot_rec_typ;
1315: l_lot_no ic_lots_mst.lot_no%TYPE;
1316: l_sublot_no ic_lots_mst.sublot_no%TYPE;
1317: l_lot_expiration_date DATE ;
1318: l_lot_quantity NUMBER;
1319: l_lot_secondary_quantity NUMBER;
1320: l_reason_code VARCHAR2(4);

Line 1321: l_vendor_lot_no_on_lot ic_lots_mst.vendor_lot_no%TYPE;

1317: l_lot_expiration_date DATE ;
1318: l_lot_quantity NUMBER;
1319: l_lot_secondary_quantity NUMBER;
1320: l_reason_code VARCHAR2(4);
1321: l_vendor_lot_no_on_lot ic_lots_mst.vendor_lot_no%TYPE;
1322: l_vendor_lot_no_on_line ic_lots_mst.vendor_lot_no%TYPE;
1323: l_vendor_id NUMBER;
1324: l_vendor_site_id NUMBER;
1325: l_transaction_date DATE ;

Line 1322: l_vendor_lot_no_on_line ic_lots_mst.vendor_lot_no%TYPE;

1318: l_lot_quantity NUMBER;
1319: l_lot_secondary_quantity NUMBER;
1320: l_reason_code VARCHAR2(4);
1321: l_vendor_lot_no_on_lot ic_lots_mst.vendor_lot_no%TYPE;
1322: l_vendor_lot_no_on_line ic_lots_mst.vendor_lot_no%TYPE;
1323: l_vendor_id NUMBER;
1324: l_vendor_site_id NUMBER;
1325: l_transaction_date DATE ;
1326: l_rti_id NUMBER;

Line 1328: l_lot_desc ic_lots_mst.lot_desc%TYPE;

1324: l_vendor_site_id NUMBER;
1325: l_transaction_date DATE ;
1326: l_rti_id NUMBER;
1327:
1328: l_lot_desc ic_lots_mst.lot_desc%TYPE;
1329:
1330: l_same_lot_count BINARY_INTEGER;
1331: l_parent_transaction_id NUMBER;
1332: l_shipment_header_id NUMBER;