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: );
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(
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,
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: );
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(
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,
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: );
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(
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,
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: );
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,
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:
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