APPS.RCV_ROI_TRANSACTION dependencies on RCV_QUANTITIES_S

Line 4358: rcv_quantities_s.get_available_quantity('RECEIVE',

4354: IF (g_asn_debug = 'Y') THEN
4355: asn_debug.put_line('Receiving against a Po');
4356: END IF;
4357:
4358: rcv_quantities_s.get_available_quantity('RECEIVE',
4359: x_shipmentdistributionrec.line_location_id,
4360: 'VENDOR',
4361: NULL,
4362: NULL,

Line 4374: rcv_quantities_s.get_available_asn_quantity('RECEIVE',

4370: IF (g_asn_debug = 'Y') THEN
4371: asn_debug.put_line('Receiving an ASN');
4372: END IF;
4373:
4374: rcv_quantities_s.get_available_asn_quantity('RECEIVE',
4375: x_shipmentdistributionrec.shipment_line_id,
4376: x_shipmentdistributionrec.line_location_id,
4377: NULL, --po_distribution_id
4378: x_shipmentdistributionrec.unit_meas_lookup_code,

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

4409: IF (g_asn_debug = 'Y') THEN
4410: asn_debug.put_line('Direct delivery against a Po');
4411: END IF;
4412:
4413: rcv_quantities_s.get_available_quantity('DIRECT RECEIPT',
4414: x_shipmentdistributionrec.po_distribution_id,
4415: 'VENDOR',
4416: NULL,
4417: NULL,

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

4425: IF (g_asn_debug = 'Y') THEN
4426: asn_debug.put_line('Direct delivery for an ASN');
4427: END IF;
4428:
4429: rcv_quantities_s.get_available_asn_quantity('DIRECT RECEIPT',
4430: x_shipmentdistributionrec.shipment_line_id,
4431: x_shipmentdistributionrec.line_location_id,
4432: x_shipmentdistributionrec.po_distribution_id,
4433: x_shipmentdistributionrec.unit_meas_lookup_code,

Line 4447: rcv_quantities_s.get_available_quantity procedure */

4443: END IF;
4444: END IF; --}
4445:
4446: /* Bug# 1337787 - Calculated the x_tolerable_qty in
4447: rcv_quantities_s.get_available_quantity procedure */
4448:
4449: -- x_tolerable_qty := x_converted_trx_qty;
4450: -- If qtys have already been allocated for this po_distribution_id during
4451: -- a cascade process which has not been written to the db yet, we need to

Line 6251: rcv_quantities_s.get_available_amount('RECEIVE',

6247: IF (g_asn_debug = 'Y') THEN
6248: asn_debug.put_line('call get_available_amount for Receive');
6249: END IF;
6250:
6251: rcv_quantities_s.get_available_amount('RECEIVE',
6252: x_shipmentdistributionrec.line_location_id,
6253: 'VENDOR',
6254: NULL,
6255: NULL,

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

6276: asn_debug.put_line('call get_available_amount for Direct Delivery');
6277: END IF;
6278:
6279: /* Bug# 1548597*/
6280: rcv_quantities_s.get_available_amount('DIRECT RECEIPT',
6281: x_shipmentdistributionrec.po_distribution_id,
6282: 'VENDOR',
6283: NULL,
6284: NULL,

Line 6291: rcv_quantities_s.get_available_quantity procedure */

6287: x_tolerable_amt
6288: );
6289:
6290: /* Bug# 1337787 - Calculated the x_tolerable_qty in
6291: rcv_quantities_s.get_available_quantity procedure */
6292:
6293: -- x_tolerable_qty := x_converted_trx_qty;
6294: -- If qtys have already been allocated for this po_distribution_id during
6295: -- a cascade process which has not been written to the db yet, we need to

Line 11112: rcv_quantities_s.get_available_quantity('TRANSFER',

11108: IF (g_asn_debug = 'Y') THEN
11109: asn_debug.put_line('calling transfer get_available_qty ');
11110: END IF;
11111:
11112: rcv_quantities_s.get_available_quantity('TRANSFER',
11113: x_po_transferrec.rcv_transaction_id,
11114: 'VENDOR',
11115: NULL,
11116: x_po_transferrec.rcv_transaction_id,

Line 12827: rcv_quantities_s.get_available_quantity('CORRECT',

12823: asn_debug.put_line('interface qty is 0');
12824: END IF;
12825:
12826: IF (SIGN(temp_cascaded_table(current_n).quantity) = -1) THEN --{
12827: rcv_quantities_s.get_available_quantity('CORRECT',
12828: x_po_correctrec.rcv_transaction_id,
12829: 'VENDOR',
12830: x_po_correctrec.parent_transaction_type,
12831: NULL,

Line 12923: rcv_quantities_s.get_available_quantity('CORRECT',

12919: l_grand_parent_trx_id := x_po_correctrec.rcv_transaction_id;
12920: END IF;
12921:
12922: IF (l_grand_parent_trx_id IS NOT NULL) THEN
12923: rcv_quantities_s.get_available_quantity('CORRECT',
12924: x_po_correctrec.rcv_transaction_id,
12925: 'VENDOR',
12926: x_po_correctrec.parent_transaction_type,
12927: l_grand_parent_trx_id,

Line 13931: rcv_quantities_s.get_available_amount('CORRECT',

13927: END IF;
13928:
13929: IF (SIGN(temp_cascaded_table(current_n).amount) = -1) THEN --{
13930: asn_debug.put_line('Before call to get_available_amt for negative correction');
13931: rcv_quantities_s.get_available_amount('CORRECT',
13932: x_po_correctrec.rcv_transaction_id,
13933: 'VENDOR',
13934: x_po_correctrec.parent_transaction_type,
13935: NULL,

Line 13961: rcv_quantities_s.get_available_amount('CORRECT',

13957: END IF;
13958:
13959: IF (l_grand_parent_trx_id IS NOT NULL) THEN
13960: asn_debug.put_line('gp before get_avail_amt for +ve corr' || l_grand_parent_trx_id);
13961: rcv_quantities_s.get_available_amount('CORRECT',
13962: x_po_correctrec.rcv_transaction_id,
13963: 'VENDOR',
13964: x_po_correctrec.parent_transaction_type,
13965: l_grand_parent_trx_id,