APPS.AP_IMPORT_VALIDATION_PKG dependencies on PO_AP_RECEIPT_MATCH_V

Line 15860: FROM po_ap_receipt_match_v

15856:
15857: BEGIN
15858: SELECT rcv_transaction_id
15859: INTO l_temp_rcv_txn_id
15860: FROM po_ap_receipt_match_v
15861: WHERE po_line_location_id = p_invoice_lines_rec.po_line_location_id;
15862:
15863: EXCEPTION
15864: When no_data_found THEN

Line 15900: FROM po_ap_receipt_match_v

15896:
15897: BEGIN
15898: SELECT rcv_transaction_id
15899: INTO l_temp_rcv_txn_id
15900: FROM po_ap_receipt_match_v
15901: WHERE receipt_number = p_invoice_lines_rec.receipt_number
15902: AND po_line_location_id = p_invoice_lines_rec.po_line_location_id;
15903:
15904: Exception

Line 15941: FROM po_ap_receipt_match_v

15937:
15938: BEGIN
15939: SELECT rcv_transaction_id
15940: INTO l_temp_rcv_txn_id
15941: FROM po_ap_receipt_match_v
15942: WHERE rcv_transaction_id = p_invoice_lines_rec.rcv_transaction_id
15943: AND po_line_location_id = p_invoice_lines_rec.po_line_location_id;
15944:
15945: EXCEPTION

Line 15976: FROM po_ap_receipt_match_v

15972: END IF;
15973: BEGIN
15974: SELECT rcv_transaction_id
15975: INTO l_temp_rcv_txn_id
15976: FROM po_ap_receipt_match_v
15977: WHERE rcv_transaction_id = p_invoice_lines_rec.rcv_transaction_id
15978: AND receipt_number = p_invoice_lines_rec.receipt_number
15979: AND po_line_location_id = p_invoice_lines_rec.po_line_location_id;
15980:

Line 16021: FROM po_ap_receipt_match_v

16017:
16018: BEGIN
16019: SELECT distinct receipt_uom_lookup_code
16020: INTO l_rcv_uom
16021: FROM po_ap_receipt_match_v
16022: WHERE po_line_location_id = p_invoice_lines_rec.po_line_location_id
16023: AND receipt_number = NVL(p_invoice_lines_rec.receipt_number,
16024: receipt_number)
16025: AND rcv_transaction_id = nvl(p_invoice_lines_rec.rcv_transaction_id,

Line 16168: FROM po_ap_receipt_match_v

16164: END IF;
16165: BEGIN
16166: SELECT rcv_transaction_id
16167: INTO l_temp_rcv_txn_id
16168: FROM po_ap_receipt_match_v
16169: WHERE receipt_number = p_invoice_lines_rec.receipt_number
16170: AND po_line_location_id = p_invoice_lines_rec.po_line_location_id;
16171:
16172: Exception

Line 16221: FROM po_ap_receipt_match_v

16217:
16218: BEGIN
16219: SELECT rcv_transaction_id
16220: INTO l_temp_rcv_txn_id
16221: FROM po_ap_receipt_match_v
16222: WHERE rcv_transaction_id = p_invoice_lines_rec.rcv_transaction_id
16223: AND po_line_location_id = p_invoice_lines_rec.po_line_location_id;
16224:
16225: Exception

Line 16257: FROM po_ap_receipt_match_v

16253:
16254: BEGIN
16255: SELECT rcv_transaction_id
16256: INTO l_temp_rcv_txn_id
16257: FROM po_ap_receipt_match_v
16258: WHERE rcv_transaction_id = p_invoice_lines_rec.rcv_transaction_id
16259: AND receipt_number = p_invoice_lines_rec.receipt_number
16260: AND po_line_location_id = p_invoice_lines_rec.po_line_location_id;
16261:

Line 16306: FROM po_ap_receipt_match_v

16302: END IF;
16303: BEGIN
16304: SELECT rcv_transaction_id
16305: INTO l_temp_rcv_txn_id
16306: FROM po_ap_receipt_match_v
16307: WHERE receipt_number = p_invoice_lines_rec.receipt_number;
16308: Exception
16309: When no_data_found THEN
16310: --reject fOR INVALID RECEIPT INFORMATION

Line 16356: FROM po_ap_receipt_match_v

16352: END IF;
16353: BEGIN
16354: SELECT rcv_transaction_id
16355: INTO l_temp_rcv_txn_id
16356: FROM po_ap_receipt_match_v
16357: WHERE rcv_transaction_id = p_invoice_lines_rec.rcv_transaction_id;
16358: Exception
16359: When Others THEN
16360: -- reject fOR INVALID RECEIPT INFORMATION

Line 16389: FROM po_ap_receipt_match_v

16385: END IF;
16386: BEGIN
16387: SELECT rcv_transaction_id
16388: INTO l_temp_rcv_txn_id
16389: FROM po_ap_receipt_match_v
16390: WHERE rcv_transaction_id = p_invoice_lines_rec.rcv_transaction_id
16391: AND receipt_number = p_invoice_lines_rec.receipt_number;
16392: Exception
16393: When Others THEN

Line 16429: FROM po_ap_receipt_match_v

16425: END IF;
16426: BEGIN
16427: SELECT rcv_shipment_line_id
16428: INTO l_temp_ship_line_id
16429: FROM po_ap_receipt_match_v
16430: WHERE rcv_transaction_id = p_invoice_lines_rec.rcv_transaction_id;
16431: Exception
16432: When no_data_found THEN
16433: --reject fOR INVALID RECEIPT INFORMATION

Line 16517: FROM po_ap_receipt_match_v

16513: END IF;
16514: BEGIN
16515: SELECT 'Y'
16516: INTO l_temp_value
16517: FROM po_ap_receipt_match_v
16518: WHERE rcv_transaction_id = p_invoice_lines_rec.rcv_transaction_id
16519: AND receipt_uom_lookup_code =
16520: p_invoice_lines_rec.unit_of_meas_lookup_code;
16521: EXCEPTION