APPS.AHL_CMP_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 893: SELECT Mtl_Material_Transactions_S.nextval

889: CLOSE TRX_ACTION_CUR;
890:
891:
892: IF(p_x_txn_hdr_id IS NULL) THEN
893: SELECT Mtl_Material_Transactions_S.nextval
894: INTO p_x_txn_hdr_id
895: FROM DUAL;
896: IF G_DEBUG='Y' THEN
897: AHL_DEBUG_PUB.debug('Header id created..['||p_x_txn_hdr_id||']');

Line 905: SELECT Mtl_Material_Transactions_S.nextval

901: --l_loop_count := 0;
902:
903: IF ( p_x_ahl_mtlxfr_rec.Quantity > 0) THEN
904:
905: SELECT Mtl_Material_Transactions_S.nextval
906: INTO p_x_txn_intf_id
907: FROM DUAL;
908:
909: IF G_DEBUG='Y' THEN

Line 953: SELECT Mtl_Material_Transactions_S.nextval

949: FETCH get_lot_dff_attrib INTO l_lot_dff_rec;
950: CLOSE get_lot_dff_attrib;
951:
952: IF(p_x_ahl_mtlxfr_rec.Serial_Number IS NOT NULL) THEN
953: SELECT Mtl_Material_Transactions_S.nextval
954: INTO l_txn_tmp_id
955: FROM DUAL;
956: ELSE
957: l_txn_tmp_id := p_x_txn_intf_id;