DBA Data[Home] [Help]

APPS.INV_RCV_STD_RCPT_APIS dependencies on STANDARD

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

2203:
2204: IF NVL(l_return_status, fnd_api.g_ret_sts_success) = fnd_api.g_ret_sts_success THEN
2205: -- If the Quaility Skip Lot function is available, then gets the interface transaction id and
2206: -- calls QA_SKIPLOT_RCV_GRP.EVALUATE_LOT
2207: -- returns 'Standard' or 'Inspect' to x_evaluation_result.
2208: IF NVL(l_qa_availability, fnd_api.g_false) = fnd_api.g_true THEN
2209: l_qa_routing_id := 2;
2210:
2211: BEGIN

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

2288: END IF;
2289: RAISE fnd_api.g_exc_unexpected_error;
2290: END IF;
2291:
2292: -- If QA_SKIPLOT_RCV_GRP returns 'Standard', sets the routing id to 1.
2293: -- If QA_SKIPLOT_RCV_GRP returns 'Inspect', leaves the routing id as 2.
2294: IF l_evaluation_result = 'STANDARD' THEN
2295: l_rcv_rcpt_rec.routing_id := 1;
2296: l_qa_routing_id := 1;

Line 2294: IF l_evaluation_result = 'STANDARD' THEN

2290: END IF;
2291:
2292: -- If QA_SKIPLOT_RCV_GRP returns 'Standard', sets the routing id to 1.
2293: -- If QA_SKIPLOT_RCV_GRP returns 'Inspect', leaves the routing id as 2.
2294: IF l_evaluation_result = 'STANDARD' THEN
2295: l_rcv_rcpt_rec.routing_id := 1;
2296: l_qa_routing_id := 1;
2297: END IF;
2298: EXCEPTION

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

4106: , mtl_units_of_measure mum
4107: WHERE NVL(poll.approved_flag, 'N') = 'Y'
4108: AND NVL(poll.cancel_flag, 'N') = 'N'
4109: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
4110: AND poll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
4111: AND poh.po_header_id = poll.po_header_id
4112: AND pol.po_line_id = poll.po_line_id
4113: AND poll.po_release_id = por.po_release_id(+)
4114: AND mum.unit_of_measure(+) = rsl.unit_of_measure

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

4741: IF NVL(l_return_status, fnd_api.g_ret_sts_success) = fnd_api.g_ret_sts_success THEN
4742:
4743: -- If the Quaility Skip Lot function is available, then gets the interface transaction id and
4744: -- call QA_SKIPLOT_RCV_GRP.EVALUATE_LOT
4745: -- returns 'Standard' or 'Inspect' to x_evaluation_result.
4746: IF NVL(l_qa_availability, fnd_api.g_false) = fnd_api.g_true THEN
4747: l_rcv_rcpt_rec.inspection_required_flag := 'Y';
4748: l_rcv_rcpt_rec.routing_id := 2;
4749:

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

4818: END IF;
4819: RAISE fnd_api.g_exc_unexpected_error;
4820: END IF;
4821:
4822: -- If QA_SKIPLOT_RCV_GRP returns 'Standard', sets the routing id to 1.
4823: -- If QA_SKIPLOT_RCV_GRP returns 'Inspect', leaves the routing id as 2.
4824: IF l_evaluation_result = 'STANDARD' THEN
4825: l_rcv_rcpt_rec.inspection_required_flag := 'N';
4826: l_rcv_rcpt_rec.routing_id := 1;

Line 4824: IF l_evaluation_result = 'STANDARD' THEN

4820: END IF;
4821:
4822: -- If QA_SKIPLOT_RCV_GRP returns 'Standard', sets the routing id to 1.
4823: -- If QA_SKIPLOT_RCV_GRP returns 'Inspect', leaves the routing id as 2.
4824: IF l_evaluation_result = 'STANDARD' THEN
4825: l_rcv_rcpt_rec.inspection_required_flag := 'N';
4826: l_rcv_rcpt_rec.routing_id := 1;
4827: END IF;
4828: