1 PACKAGE RCV_RMA_TRANSACTIONS
2 /* $Header: RCVRMATS.pls 120.0.12000000.1 2007/01/16 23:31:12 appldev ship $*/
3 AUTHID CURRENT_USER AS
4 PROCEDURE derive_rma_line(
5 x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
6 n IN OUT NOCOPY BINARY_INTEGER,
7 temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
8 x_header_record IN rcv_roi_preprocessor.header_rec_type
9 );
10
11 PROCEDURE derive_rma_trans_del(
12 x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
13 n IN OUT NOCOPY BINARY_INTEGER,
14 temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
15 x_header_record IN rcv_roi_preprocessor.header_rec_type
16 );
17
18 PROCEDURE derive_rma_correction_line(
19 x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
20 n IN OUT NOCOPY BINARY_INTEGER,
21 temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
22 x_header_record IN rcv_roi_preprocessor.header_rec_type
23 );
24
25 PROCEDURE default_rma_line(
26 x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
27 n IN BINARY_INTEGER,
28 x_header_id IN rcv_headers_interface.header_interface_id%TYPE,
29 x_header_record IN rcv_roi_preprocessor.header_rec_type
30 );
31
32 PROCEDURE validate_rma_line(
33 x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
34 n IN BINARY_INTEGER,
35 x_header_record IN rcv_roi_preprocessor.header_rec_type
36 );
37
38 PROCEDURE get_location_id(
39 x_location_id_record IN OUT NOCOPY rcv_shipment_object_sv.location_id_record_type
40 );
41
42 PROCEDURE get_locator_id(
43 x_locator_id_record IN OUT NOCOPY rcv_shipment_line_sv.locator_id_record_type
44 );
45
46 PROCEDURE get_routing_header_id(
47 x_routing_header_id_record IN OUT NOCOPY rcv_shipment_line_sv.routing_header_id_rec_type
48 );
49
50 PROCEDURE get_routing_step_id(
51 x_routing_step_id_record IN OUT NOCOPY rcv_shipment_line_sv.routing_step_id_rec_type
52 );
53
54 PROCEDURE get_reason_id(
55 x_reason_id_record IN OUT NOCOPY rcv_shipment_line_sv.reason_id_record_type
56 );
57
58 PROCEDURE default_item_revision(
59 x_item_revision_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type
60 );
61
62 PROCEDURE validate_item_revision(
63 x_item_revision_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type
64 );
65
66 PROCEDURE check_date_tolerance(
67 expected_receipt_date IN DATE,
68 promised_date IN DATE,
69 days_early_receipt_allowed IN NUMBER,
70 days_late_receipt_allowed IN NUMBER,
71 receipt_days_exception_code IN OUT NOCOPY VARCHAR2
72 );
73
74 FUNCTION convert_into_correct_qty(
75 source_qty IN NUMBER,
76 source_uom IN VARCHAR2,
77 item_id IN NUMBER,
78 dest_uom IN VARCHAR2
79 )
80 RETURN NUMBER;
81
82 PROCEDURE get_item_id(
83 x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type
84 );
85
86 -- API call done by EDI to obtain the org_id
87 PROCEDURE get_org_id_from_hr_loc_id(
88 p_hr_location_id IN NUMBER,
89 x_organization_id OUT NOCOPY NUMBER
90 );
91 END RCV_RMA_TRANSACTIONS;