1: PACKAGE RCV_INT_ORDER_PP_PVT AS
2: /* $Header: RCVPPIOS.pls 120.0.12000000.2 2007/10/22 15:52:00 srnatara ship $ */
3:
4: PROCEDURE derive_internal_order_header(
5: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type);
6:
7: PROCEDURE default_internal_order_header(
8: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type);
9:
4: PROCEDURE derive_internal_order_header(
5: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type);
6:
7: PROCEDURE default_internal_order_header(
8: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type);
9:
10: PROCEDURE validate_internal_order_header(
11: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type);
12:
7: PROCEDURE default_internal_order_header(
8: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type);
9:
10: PROCEDURE validate_internal_order_header(
11: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type);
12:
13: /* Bug 3314675. Use this procedure to default shipment_header_id for
14: * the given shipment_num.
15: */
12:
13: /* Bug 3314675. Use this procedure to default shipment_header_id for
14: * the given shipment_num.
15: */
16: PROCEDURE default_shipment_info(p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type);
17:
18: PROCEDURE update_header(
19: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type);
20:
15: */
16: PROCEDURE default_shipment_info(p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type);
17:
18: PROCEDURE update_header(
19: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type);
20:
21: PROCEDURE derive_io_receive_line(
22: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
23: n IN OUT NOCOPY binary_integer,
18: PROCEDURE update_header(
19: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type);
20:
21: PROCEDURE derive_io_receive_line(
22: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
23: n IN OUT NOCOPY binary_integer,
24: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
25: x_header_record IN rcv_roi_preprocessor.header_rec_type);
26:
20:
21: PROCEDURE derive_io_receive_line(
22: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
23: n IN OUT NOCOPY binary_integer,
24: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
25: x_header_record IN rcv_roi_preprocessor.header_rec_type);
26:
27: PROCEDURE derive_io_trans_line(
28: x_cascaded_table in out nocopy rcv_roi_preprocessor.cascaded_trans_tab_type,
21: PROCEDURE derive_io_receive_line(
22: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
23: n IN OUT NOCOPY binary_integer,
24: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
25: x_header_record IN rcv_roi_preprocessor.header_rec_type);
26:
27: PROCEDURE derive_io_trans_line(
28: x_cascaded_table in out nocopy rcv_roi_preprocessor.cascaded_trans_tab_type,
29: n in out nocopy binary_integer,
24: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
25: x_header_record IN rcv_roi_preprocessor.header_rec_type);
26:
27: PROCEDURE derive_io_trans_line(
28: x_cascaded_table in out nocopy rcv_roi_preprocessor.cascaded_trans_tab_type,
29: n in out nocopy binary_integer,
30: temp_cascaded_table in out nocopy rcv_roi_preprocessor.cascaded_trans_tab_type,
31: x_header_record in rcv_roi_preprocessor.header_rec_type);
32:
26:
27: PROCEDURE derive_io_trans_line(
28: x_cascaded_table in out nocopy rcv_roi_preprocessor.cascaded_trans_tab_type,
29: n in out nocopy binary_integer,
30: temp_cascaded_table in out nocopy rcv_roi_preprocessor.cascaded_trans_tab_type,
31: x_header_record in rcv_roi_preprocessor.header_rec_type);
32:
33: PROCEDURE derive_io_correct_line(
34: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
27: PROCEDURE derive_io_trans_line(
28: x_cascaded_table in out nocopy rcv_roi_preprocessor.cascaded_trans_tab_type,
29: n in out nocopy binary_integer,
30: temp_cascaded_table in out nocopy rcv_roi_preprocessor.cascaded_trans_tab_type,
31: x_header_record in rcv_roi_preprocessor.header_rec_type);
32:
33: PROCEDURE derive_io_correct_line(
34: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
35: n IN OUT NOCOPY binary_integer,
30: temp_cascaded_table in out nocopy rcv_roi_preprocessor.cascaded_trans_tab_type,
31: x_header_record in rcv_roi_preprocessor.header_rec_type);
32:
33: PROCEDURE derive_io_correct_line(
34: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
35: n IN OUT NOCOPY binary_integer,
36: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
37: x_header_record IN rcv_roi_preprocessor.header_rec_type);
38:
32:
33: PROCEDURE derive_io_correct_line(
34: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
35: n IN OUT NOCOPY binary_integer,
36: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
37: x_header_record IN rcv_roi_preprocessor.header_rec_type);
38:
39: PROCEDURE default_io_receive_line(
40: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
33: PROCEDURE derive_io_correct_line(
34: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
35: n IN OUT NOCOPY binary_integer,
36: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
37: x_header_record IN rcv_roi_preprocessor.header_rec_type);
38:
39: PROCEDURE default_io_receive_line(
40: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
41: n IN binary_integer);
36: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
37: x_header_record IN rcv_roi_preprocessor.header_rec_type);
38:
39: PROCEDURE default_io_receive_line(
40: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
41: n IN binary_integer);
42:
43: PROCEDURE default_io_trans_line(
44: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
40: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
41: n IN binary_integer);
42:
43: PROCEDURE default_io_trans_line(
44: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
45: n IN binary_integer);
46:
47: PROCEDURE default_io_correct_line(
48: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
44: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
45: n IN binary_integer);
46:
47: PROCEDURE default_io_correct_line(
48: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
49: n IN binary_integer);
50:
51: PROCEDURE validate_io_receive_line(
52: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
48: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
49: n IN binary_integer);
50:
51: PROCEDURE validate_io_receive_line(
52: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
53: n IN binary_integer,
54: x_header_record IN rcv_roi_preprocessor.header_rec_type);
55:
56: /* The following procedure and functions are added as part of Bug#6375015 fix.
50:
51: PROCEDURE validate_io_receive_line(
52: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
53: n IN binary_integer,
54: x_header_record IN rcv_roi_preprocessor.header_rec_type);
55:
56: /* The following procedure and functions are added as part of Bug#6375015 fix.
57: Procedure get_deliver_to_person_from_rsl()
58: Function get_deliver_to_person_from_rt()
58: Function get_deliver_to_person_from_rt()
59: Function get_deliver_to_person_from_rti() */
60:
61: PROCEDURE get_deliver_to_person_from_rsl(
62: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
63: n IN BINARY_INTEGER
64: );
65:
66: FUNCTION get_deliver_to_person_from_rt(
63: n IN BINARY_INTEGER
64: );
65:
66: FUNCTION get_deliver_to_person_from_rt(
67: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
68: n IN BINARY_INTEGER
69: ) RETURN NUMBER;
70:
71: FUNCTION get_deliver_to_person_from_rti(
68: n IN BINARY_INTEGER
69: ) RETURN NUMBER;
70:
71: FUNCTION get_deliver_to_person_from_rti(
72: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
73: n IN BINARY_INTEGER
74: ) RETURN NUMBER;
75:
76: END RCV_INT_ORDER_PP_PVT;