DBA Data[Home] [Help]

APPS.INV_RCV_STD_RCPT_APIS dependencies on STANDARD

Line 2154: -- returns 'Standard' or 'Inspect' to x_evaluation_result.

2150:
2151: IF NVL(l_return_status, fnd_api.g_ret_sts_success) = fnd_api.g_ret_sts_success THEN
2152: -- If the Quaility Skip Lot function is available, then gets the interface transaction id and
2153: -- calls QA_SKIPLOT_RCV_GRP.EVALUATE_LOT
2154: -- returns 'Standard' or 'Inspect' to x_evaluation_result.
2155: IF NVL(l_qa_availability, fnd_api.g_false) = fnd_api.g_true THEN
2156: l_qa_routing_id := 2;
2157:
2158: BEGIN

Line 2239: -- If QA_SKIPLOT_RCV_GRP returns 'Standard', sets the routing id to 1.

2235: END IF;
2236: RAISE fnd_api.g_exc_unexpected_error;
2237: END IF;
2238:
2239: -- If QA_SKIPLOT_RCV_GRP returns 'Standard', sets the routing id to 1.
2240: -- If QA_SKIPLOT_RCV_GRP returns 'Inspect', leaves the routing id as 2.
2241: IF l_evaluation_result = 'STANDARD' THEN
2242: l_rcv_rcpt_rec.routing_id := 1;
2243: l_qa_routing_id := 1;

Line 2241: IF l_evaluation_result = 'STANDARD' THEN

2237: END IF;
2238:
2239: -- If QA_SKIPLOT_RCV_GRP returns 'Standard', sets the routing id to 1.
2240: -- If QA_SKIPLOT_RCV_GRP returns 'Inspect', leaves the routing id as 2.
2241: IF l_evaluation_result = 'STANDARD' THEN
2242: l_rcv_rcpt_rec.routing_id := 1;
2243: l_qa_routing_id := 1;
2244: END IF;
2245: EXCEPTION

Line 3929: AND poll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')

3925: , mtl_units_of_measure mum
3926: WHERE NVL(poll.approved_flag, 'N') = 'Y'
3927: AND NVL(poll.cancel_flag, 'N') = 'N'
3928: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
3929: AND poll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
3930: AND poh.po_header_id = poll.po_header_id
3931: AND pol.po_line_id = poll.po_line_id
3932: AND poll.po_release_id = por.po_release_id(+)
3933: AND mum.unit_of_measure(+) = rsl.unit_of_measure

Line 4478: -- returns 'Standard' or 'Inspect' to x_evaluation_result.

4474: IF NVL(l_return_status, fnd_api.g_ret_sts_success) = fnd_api.g_ret_sts_success THEN
4475:
4476: -- If the Quaility Skip Lot function is available, then gets the interface transaction id and
4477: -- call QA_SKIPLOT_RCV_GRP.EVALUATE_LOT
4478: -- returns 'Standard' or 'Inspect' to x_evaluation_result.
4479: IF NVL(l_qa_availability, fnd_api.g_false) = fnd_api.g_true THEN
4480: l_rcv_rcpt_rec.inspection_required_flag := 'Y';
4481: l_rcv_rcpt_rec.routing_id := 2;
4482:

Line 4555: -- If QA_SKIPLOT_RCV_GRP returns 'Standard', sets the routing id to 1.

4551: END IF;
4552: RAISE fnd_api.g_exc_unexpected_error;
4553: END IF;
4554:
4555: -- If QA_SKIPLOT_RCV_GRP returns 'Standard', sets the routing id to 1.
4556: -- If QA_SKIPLOT_RCV_GRP returns 'Inspect', leaves the routing id as 2.
4557: IF l_evaluation_result = 'STANDARD' THEN
4558: l_rcv_rcpt_rec.inspection_required_flag := 'N';
4559: l_rcv_rcpt_rec.routing_id := 1;

Line 4557: IF l_evaluation_result = 'STANDARD' THEN

4553: END IF;
4554:
4555: -- If QA_SKIPLOT_RCV_GRP returns 'Standard', sets the routing id to 1.
4556: -- If QA_SKIPLOT_RCV_GRP returns 'Inspect', leaves the routing id as 2.
4557: IF l_evaluation_result = 'STANDARD' THEN
4558: l_rcv_rcpt_rec.inspection_required_flag := 'N';
4559: l_rcv_rcpt_rec.routing_id := 1;
4560: END IF;
4561: