9: ) RETURN VARCHAR2;
10:
11: PROCEDURE default_who_columns(
12: x_last_update_date_tbl IN OUT NOCOPY PO_TBL_DATE,
13: x_last_updated_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
14: x_last_update_login_tbl IN OUT NOCOPY PO_TBL_NUMBER,
15: x_creation_date_tbl IN OUT NOCOPY PO_TBL_DATE,
16: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
17: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
10:
11: PROCEDURE default_who_columns(
12: x_last_update_date_tbl IN OUT NOCOPY PO_TBL_DATE,
13: x_last_updated_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
14: x_last_update_login_tbl IN OUT NOCOPY PO_TBL_NUMBER,
15: x_creation_date_tbl IN OUT NOCOPY PO_TBL_DATE,
16: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
17: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
18: x_program_application_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
12: x_last_update_date_tbl IN OUT NOCOPY PO_TBL_DATE,
13: x_last_updated_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
14: x_last_update_login_tbl IN OUT NOCOPY PO_TBL_NUMBER,
15: x_creation_date_tbl IN OUT NOCOPY PO_TBL_DATE,
16: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
17: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
18: x_program_application_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
19: x_program_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
20: x_program_update_date_tbl IN OUT NOCOPY PO_TBL_DATE
13: x_last_updated_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
14: x_last_update_login_tbl IN OUT NOCOPY PO_TBL_NUMBER,
15: x_creation_date_tbl IN OUT NOCOPY PO_TBL_DATE,
16: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
17: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
18: x_program_application_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
19: x_program_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
20: x_program_update_date_tbl IN OUT NOCOPY PO_TBL_DATE
21: );
14: x_last_update_login_tbl IN OUT NOCOPY PO_TBL_NUMBER,
15: x_creation_date_tbl IN OUT NOCOPY PO_TBL_DATE,
16: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
17: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
18: x_program_application_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
19: x_program_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
20: x_program_update_date_tbl IN OUT NOCOPY PO_TBL_DATE
21: );
22:
15: x_creation_date_tbl IN OUT NOCOPY PO_TBL_DATE,
16: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
17: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
18: x_program_application_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
19: x_program_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
20: x_program_update_date_tbl IN OUT NOCOPY PO_TBL_DATE
21: );
22:
23: -- line related utility method
22:
23: -- line related utility method
24: PROCEDURE calculate_max_line_num
25: (
26: p_po_header_id_tbl IN PO_TBL_NUMBER,
27: p_draft_id_tbl IN PO_TBL_NUMBER
28: );
29:
30: FUNCTION get_next_line_num
23: -- line related utility method
24: PROCEDURE calculate_max_line_num
25: (
26: p_po_header_id_tbl IN PO_TBL_NUMBER,
27: p_draft_id_tbl IN PO_TBL_NUMBER
28: );
29:
30: FUNCTION get_next_line_num
31: (
36: RETURN NUMBER;
37:
38: PROCEDURE check_line_num_unique
39: (
40: p_po_header_id_tbl IN PO_TBL_NUMBER,
41: p_draft_id_tbl IN PO_TBL_NUMBER,
42: p_intf_line_id_tbl IN PO_TBL_NUMBER,
43: p_line_num_tbl IN PO_TBL_NUMBER,
44: x_line_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
37:
38: PROCEDURE check_line_num_unique
39: (
40: p_po_header_id_tbl IN PO_TBL_NUMBER,
41: p_draft_id_tbl IN PO_TBL_NUMBER,
42: p_intf_line_id_tbl IN PO_TBL_NUMBER,
43: p_line_num_tbl IN PO_TBL_NUMBER,
44: x_line_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
45: );
38: PROCEDURE check_line_num_unique
39: (
40: p_po_header_id_tbl IN PO_TBL_NUMBER,
41: p_draft_id_tbl IN PO_TBL_NUMBER,
42: p_intf_line_id_tbl IN PO_TBL_NUMBER,
43: p_line_num_tbl IN PO_TBL_NUMBER,
44: x_line_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
45: );
46:
39: (
40: p_po_header_id_tbl IN PO_TBL_NUMBER,
41: p_draft_id_tbl IN PO_TBL_NUMBER,
42: p_intf_line_id_tbl IN PO_TBL_NUMBER,
43: p_line_num_tbl IN PO_TBL_NUMBER,
44: x_line_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
45: );
46:
47: -- location related utility method
46:
47: -- location related utility method
48: PROCEDURE calculate_max_shipment_num
49: (
50: p_po_line_id_tbl IN PO_TBL_NUMBER,
51: p_draft_id_tbl IN PO_TBL_NUMBER
52: );
53:
54: FUNCTION get_next_shipment_num
47: -- location related utility method
48: PROCEDURE calculate_max_shipment_num
49: (
50: p_po_line_id_tbl IN PO_TBL_NUMBER,
51: p_draft_id_tbl IN PO_TBL_NUMBER
52: );
53:
54: FUNCTION get_next_shipment_num
55: (
60: RETURN NUMBER;
61:
62: PROCEDURE check_shipment_num_unique
63: (
64: p_po_line_id_tbl IN PO_TBL_NUMBER,
65: p_draft_id_tbl IN PO_TBL_NUMBER,
66: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,
67: p_shipment_num_tbl IN PO_TBL_NUMBER,
68: x_shipment_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
61:
62: PROCEDURE check_shipment_num_unique
63: (
64: p_po_line_id_tbl IN PO_TBL_NUMBER,
65: p_draft_id_tbl IN PO_TBL_NUMBER,
66: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,
67: p_shipment_num_tbl IN PO_TBL_NUMBER,
68: x_shipment_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
69: );
62: PROCEDURE check_shipment_num_unique
63: (
64: p_po_line_id_tbl IN PO_TBL_NUMBER,
65: p_draft_id_tbl IN PO_TBL_NUMBER,
66: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,
67: p_shipment_num_tbl IN PO_TBL_NUMBER,
68: x_shipment_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
69: );
70:
63: (
64: p_po_line_id_tbl IN PO_TBL_NUMBER,
65: p_draft_id_tbl IN PO_TBL_NUMBER,
66: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,
67: p_shipment_num_tbl IN PO_TBL_NUMBER,
68: x_shipment_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
69: );
70:
71: -- Distribution related utility method
70:
71: -- Distribution related utility method
72: PROCEDURE calculate_max_dist_num
73: (
74: p_line_loc_id_tbl IN PO_TBL_NUMBER,
75: p_draft_id_tbl IN PO_TBL_NUMBER
76: );
77:
78: FUNCTION get_next_dist_num
71: -- Distribution related utility method
72: PROCEDURE calculate_max_dist_num
73: (
74: p_line_loc_id_tbl IN PO_TBL_NUMBER,
75: p_draft_id_tbl IN PO_TBL_NUMBER
76: );
77:
78: FUNCTION get_next_dist_num
79: (
84: RETURN NUMBER;
85:
86: PROCEDURE check_dist_num_unique
87: (
88: p_line_loc_id_tbl IN PO_TBL_NUMBER,
89: p_draft_id_tbl IN PO_TBL_NUMBER,
90: p_intf_dist_id_tbl IN PO_TBL_NUMBER,
91: p_dist_num_tbl IN PO_TBL_NUMBER,
92: x_dist_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
85:
86: PROCEDURE check_dist_num_unique
87: (
88: p_line_loc_id_tbl IN PO_TBL_NUMBER,
89: p_draft_id_tbl IN PO_TBL_NUMBER,
90: p_intf_dist_id_tbl IN PO_TBL_NUMBER,
91: p_dist_num_tbl IN PO_TBL_NUMBER,
92: x_dist_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
93: );
86: PROCEDURE check_dist_num_unique
87: (
88: p_line_loc_id_tbl IN PO_TBL_NUMBER,
89: p_draft_id_tbl IN PO_TBL_NUMBER,
90: p_intf_dist_id_tbl IN PO_TBL_NUMBER,
91: p_dist_num_tbl IN PO_TBL_NUMBER,
92: x_dist_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
93: );
94:
87: (
88: p_line_loc_id_tbl IN PO_TBL_NUMBER,
89: p_draft_id_tbl IN PO_TBL_NUMBER,
90: p_intf_dist_id_tbl IN PO_TBL_NUMBER,
91: p_dist_num_tbl IN PO_TBL_NUMBER,
92: x_dist_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
93: );
94:
95: -- Price Differential related utility method
95: -- Price Differential related utility method
96: PROCEDURE calculate_max_price_diff_num
97: (
98: p_entity_type_tbl IN PO_TBL_VARCHAR30,
99: p_entity_id_tbl IN PO_TBL_NUMBER,
100: p_draft_id_tbl IN PO_TBL_NUMBER,
101: p_price_diff_num_tbl IN PO_TBL_NUMBER
102: );
103:
96: PROCEDURE calculate_max_price_diff_num
97: (
98: p_entity_type_tbl IN PO_TBL_VARCHAR30,
99: p_entity_id_tbl IN PO_TBL_NUMBER,
100: p_draft_id_tbl IN PO_TBL_NUMBER,
101: p_price_diff_num_tbl IN PO_TBL_NUMBER
102: );
103:
104: FUNCTION get_next_price_diff_num
97: (
98: p_entity_type_tbl IN PO_TBL_VARCHAR30,
99: p_entity_id_tbl IN PO_TBL_NUMBER,
100: p_draft_id_tbl IN PO_TBL_NUMBER,
101: p_price_diff_num_tbl IN PO_TBL_NUMBER
102: );
103:
104: FUNCTION get_next_price_diff_num
105: (
110:
111: PROCEDURE check_price_diff_num_unique
112: (
113: p_entity_type_tbl IN PO_TBL_VARCHAR30,
114: p_entity_id_tbl IN PO_TBL_NUMBER,
115: p_draft_id_tbl IN PO_TBL_NUMBER,
116: p_intf_price_diff_id_tbl IN PO_TBL_NUMBER,
117: p_price_diff_num_tbl IN PO_TBL_NUMBER,
118: x_price_diff_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
111: PROCEDURE check_price_diff_num_unique
112: (
113: p_entity_type_tbl IN PO_TBL_VARCHAR30,
114: p_entity_id_tbl IN PO_TBL_NUMBER,
115: p_draft_id_tbl IN PO_TBL_NUMBER,
116: p_intf_price_diff_id_tbl IN PO_TBL_NUMBER,
117: p_price_diff_num_tbl IN PO_TBL_NUMBER,
118: x_price_diff_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
119: );
112: (
113: p_entity_type_tbl IN PO_TBL_VARCHAR30,
114: p_entity_id_tbl IN PO_TBL_NUMBER,
115: p_draft_id_tbl IN PO_TBL_NUMBER,
116: p_intf_price_diff_id_tbl IN PO_TBL_NUMBER,
117: p_price_diff_num_tbl IN PO_TBL_NUMBER,
118: x_price_diff_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
119: );
120:
113: p_entity_type_tbl IN PO_TBL_VARCHAR30,
114: p_entity_id_tbl IN PO_TBL_NUMBER,
115: p_draft_id_tbl IN PO_TBL_NUMBER,
116: p_intf_price_diff_id_tbl IN PO_TBL_NUMBER,
117: p_price_diff_num_tbl IN PO_TBL_NUMBER,
118: x_price_diff_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
119: );
120:
121: -- utility method used in item creation