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: x_subinv VARCHAR2 (60); -- bug 9298154
110: BEGIN
111: X_progress := '010';

Line 355: x_po_distributions_id, x_destination_type_code,

351: X_progress := '060';
352:
353: rcv_distributions_s.get_distributions_info (x_line_location_id,
354: x_shipment_line_id, x_item_id, x_num_of_distributions,
355: x_po_distributions_id, x_destination_type_code,
356: x_destination_type_dsp, x_deliver_to_location_id ,
357: x_deliver_to_location,
358: x_deliver_to_person_id, x_deliver_to_person,
359: x_deliver_to_sub, x_deliver_to_locator_id, x_deliver_to_locator,

Line 803: x_po_distributions_id ,

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

Line 829: IF (X_po_distributions_id IS NOT NULL AND

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

Line 836: FROM po_distributions

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

Line 837: WHERE po_distribution_id = X_po_distributions_id;

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

Line 978: x_po_distributions_id IN OUT NOCOPY NUMBER,

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

Line 1040: x_po_distributions_id,

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