APPS.RCV_ROI_TRANSACTION dependencies on RCV_QUANTITIES_S

Line 4918: rcv_quantities_s.get_available_quantity('RECEIVE',

4914: IF (g_asn_debug = 'Y') THEN
4915: asn_debug.put_line('Receiving against a Po');
4916: END IF;
4917:
4918: rcv_quantities_s.get_available_quantity('RECEIVE',
4919: x_shipmentdistributionrec.line_location_id,
4920: 'VENDOR',
4921: NULL,
4922: NULL,

Line 4934: rcv_quantities_s.get_available_asn_quantity('RECEIVE',

4930: IF (g_asn_debug = 'Y') THEN
4931: asn_debug.put_line('Receiving an ASN');
4932: END IF;
4933:
4934: rcv_quantities_s.get_available_asn_quantity('RECEIVE',
4935: x_shipmentdistributionrec.shipment_line_id,
4936: x_shipmentdistributionrec.line_location_id,
4937: NULL, --po_distribution_id
4938: x_shipmentdistributionrec.unit_meas_lookup_code,

Line 4973: rcv_quantities_s.get_available_quantity('DIRECT RECEIPT',

4969: IF (g_asn_debug = 'Y') THEN
4970: asn_debug.put_line('Direct delivery against a Po');
4971: END IF;
4972:
4973: rcv_quantities_s.get_available_quantity('DIRECT RECEIPT',
4974: x_shipmentdistributionrec.po_distribution_id,
4975: 'VENDOR',
4976: NULL,
4977: NULL,

Line 4989: rcv_quantities_s.get_available_asn_quantity('DIRECT RECEIPT',

4985: IF (g_asn_debug = 'Y') THEN
4986: asn_debug.put_line('Direct delivery for an ASN');
4987: END IF;
4988:
4989: rcv_quantities_s.get_available_asn_quantity('DIRECT RECEIPT',
4990: x_shipmentdistributionrec.shipment_line_id,
4991: x_shipmentdistributionrec.line_location_id,
4992: x_shipmentdistributionrec.po_distribution_id,
4993: x_shipmentdistributionrec.unit_meas_lookup_code,

Line 5007: rcv_quantities_s.get_available_quantity procedure */

5003: END IF;
5004: END IF; --}
5005:
5006: /* Bug# 1337787 - Calculated the x_tolerable_qty in
5007: rcv_quantities_s.get_available_quantity procedure */
5008:
5009: -- x_tolerable_qty := x_converted_trx_qty;
5010: -- If qtys have already been allocated for this po_distribution_id during
5011: -- a cascade process which has not been written to the db yet, we need to

Line 6929: rcv_quantities_s.get_available_amount('RECEIVE',

6925: IF (g_asn_debug = 'Y') THEN
6926: asn_debug.put_line('call get_available_amount for Receive');
6927: END IF;
6928:
6929: rcv_quantities_s.get_available_amount('RECEIVE',
6930: x_shipmentdistributionrec.line_location_id,
6931: 'VENDOR',
6932: NULL,
6933: NULL,

Line 6958: rcv_quantities_s.get_available_amount('DIRECT RECEIPT',

6954: asn_debug.put_line('call get_available_amount for Direct Delivery');
6955: END IF;
6956:
6957: /* Bug# 1548597*/
6958: rcv_quantities_s.get_available_amount('DIRECT RECEIPT',
6959: x_shipmentdistributionrec.po_distribution_id,
6960: 'VENDOR',
6961: NULL,
6962: NULL,

Line 6969: rcv_quantities_s.get_available_quantity procedure */

6965: x_tolerable_amt
6966: );
6967:
6968: /* Bug# 1337787 - Calculated the x_tolerable_qty in
6969: rcv_quantities_s.get_available_quantity procedure */
6970:
6971: -- x_tolerable_qty := x_converted_trx_qty;
6972: -- If qtys have already been allocated for this po_distribution_id during
6973: -- a cascade process which has not been written to the db yet, we need to

Line 12386: rcv_quantities_s.get_available_quantity('TRANSFER',

12382: IF (g_asn_debug = 'Y') THEN
12383: asn_debug.put_line('calling transfer get_available_qty ');
12384: END IF;
12385:
12386: rcv_quantities_s.get_available_quantity('TRANSFER',
12387: x_po_transferrec.rcv_transaction_id,
12388: 'VENDOR',
12389: NULL,
12390: x_po_transferrec.rcv_transaction_id,

Line 14196: rcv_quantities_s.get_available_quantity('CORRECT',

14192: asn_debug.put_line('interface qty is 0');
14193: END IF;
14194:
14195: IF (SIGN(temp_cascaded_table(current_n).quantity) = -1) THEN --{
14196: rcv_quantities_s.get_available_quantity('CORRECT',
14197: x_po_correctrec.rcv_transaction_id,
14198: 'VENDOR',
14199: x_po_correctrec.parent_transaction_type,
14200: NULL,

Line 14293: rcv_quantities_s.get_available_quantity('CORRECT',

14289: l_grand_parent_trx_id := x_po_correctrec.rcv_transaction_id;
14290: END IF;
14291:
14292: IF (l_grand_parent_trx_id IS NOT NULL) THEN
14293: rcv_quantities_s.get_available_quantity('CORRECT',
14294: x_po_correctrec.rcv_transaction_id,
14295: 'VENDOR',
14296: x_po_correctrec.parent_transaction_type,
14297: l_grand_parent_trx_id,

Line 15346: rcv_quantities_s.get_available_amount('CORRECT',

15342: END IF;
15343:
15344: IF (SIGN(temp_cascaded_table(current_n).amount) = -1) THEN --{
15345: asn_debug.put_line('Before call to get_available_amt for negative correction');
15346: rcv_quantities_s.get_available_amount('CORRECT',
15347: x_po_correctrec.rcv_transaction_id,
15348: 'VENDOR',
15349: x_po_correctrec.parent_transaction_type,
15350: NULL,

Line 15376: rcv_quantities_s.get_available_amount('CORRECT',

15372: END IF;
15373:
15374: IF (l_grand_parent_trx_id IS NOT NULL) THEN
15375: asn_debug.put_line('gp before get_avail_amt for +ve corr' || l_grand_parent_trx_id);
15376: rcv_quantities_s.get_available_amount('CORRECT',
15377: x_po_correctrec.rcv_transaction_id,
15378: 'VENDOR',
15379: x_po_correctrec.parent_transaction_type,
15380: l_grand_parent_trx_id,