DBA Data[Home] [Help]

APPS.RCV_RECEIPTS_QUERY_SV dependencies on PO_DISTRIBUTIONS

Line 30: x_po_distributions_id IN OUT NOCOPY NUMBER,

26: x_uom IN OUT NOCOPY VARCHAR2,
27: x_primary_uom IN OUT NOCOPY VARCHAR2,
28: x_valid_ship_to_location IN OUT NOCOPY BOOLEAN,
29: x_num_of_distributions IN OUT NOCOPY NUMBER,
30: x_po_distributions_id IN OUT NOCOPY NUMBER,
31: x_destination_type_code IN OUT NOCOPY VARCHAR2,
32: x_destination_type_dsp IN OUT NOCOPY VARCHAR2,
33: x_deliver_to_location_id IN OUT NOCOPY NUMBER,
34: x_deliver_to_location IN OUT NOCOPY VARCHAR2,

Line 107: l_code_combination_id PO_DISTRIBUTIONS.code_combination_id%TYPE;

103: /* Bug# 3680886 : Removed the initialization to zero for X_ms_routing_id */
104: X_ms_routing_id NUMBER;
105:
106: --
107: l_code_combination_id PO_DISTRIBUTIONS.code_combination_id%TYPE;
108: --
109: BEGIN
110:
111: X_progress := '010';

Line 376: x_po_distributions_id, x_destination_type_code,

372: X_progress := '060';
373:
374: rcv_distributions_s.get_distributions_info (x_line_location_id,
375: x_shipment_line_id, x_item_id, x_num_of_distributions,
376: x_po_distributions_id, x_destination_type_code,
377: x_destination_type_dsp, x_deliver_to_location_id ,
378: x_deliver_to_location,
379: x_deliver_to_person_id, x_deliver_to_person,
380: x_deliver_to_sub, x_deliver_to_locator_id, x_deliver_to_locator,

Line 805: x_po_distributions_id ,

801: X_default_locator_id := x_deliver_to_locator_id;
802:
803: X_success := rcv_sub_locator_sv.put_away_api (
804: x_line_location_id ,
805: x_po_distributions_id ,
806: x_shipment_line_id ,
807: x_receipt_source_code ,
808: x_org_id ,
809: x_to_organization_id ,

Line 831: IF (X_po_distributions_id IS NOT NULL AND

827: X_progress := '132';
828:
829: IF (x_receipt_source_code <> 'CUSTOMER') THEN
830:
831: IF (X_po_distributions_id IS NOT NULL AND
832: x_deliver_to_locator_id IS NOT NULL) THEN
833:
834: X_progress := '133';
835:

Line 838: FROM po_distributions

834: X_progress := '133';
835:
836: SELECT project_id, task_id
837: INTO X_project_id, X_task_id
838: FROM po_distributions
839: WHERE po_distribution_id = X_po_distributions_id;
840:
841: ELSIF (x_req_distribution_id IS NOT NULL AND
842: x_deliver_to_locator_id IS NOT NULL) THEN

Line 839: WHERE po_distribution_id = X_po_distributions_id;

835:
836: SELECT project_id, task_id
837: INTO X_project_id, X_task_id
838: FROM po_distributions
839: WHERE po_distribution_id = X_po_distributions_id;
840:
841: ELSIF (x_req_distribution_id IS NOT NULL AND
842: x_deliver_to_locator_id IS NOT NULL) THEN
843:

Line 980: x_po_distributions_id IN OUT NOCOPY NUMBER,

976: x_uom IN OUT NOCOPY VARCHAR2,
977: x_primary_uom IN OUT NOCOPY VARCHAR2,
978: x_valid_ship_to_location IN OUT NOCOPY BOOLEAN,
979: x_num_of_distributions IN OUT NOCOPY NUMBER,
980: x_po_distributions_id IN OUT NOCOPY NUMBER,
981: x_destination_type_code IN OUT NOCOPY VARCHAR2,
982: x_destination_type_dsp IN OUT NOCOPY VARCHAR2,
983: x_deliver_to_location_id IN OUT NOCOPY NUMBER,
984: x_deliver_to_location IN OUT NOCOPY VARCHAR2,

Line 1042: x_po_distributions_id,

1038: x_uom,
1039: x_primary_uom,
1040: x_valid_ship_to_location,
1041: x_num_of_distributions,
1042: x_po_distributions_id,
1043: x_destination_type_code,
1044: x_destination_type_dsp,
1045: x_deliver_to_location_id,
1046: x_deliver_to_location,