[Home] [Help]
PACKAGE: APPS.PO_VAL_HEADERS
Source
1 PACKAGE PO_VAL_HEADERS AS
2 -- $Header: PO_VAL_HEADERS.pls 120.3 2006/07/19 18:26:47 dedelgad noship $
3
4 PROCEDURE price_update_tol_ge_zero(
5 p_header_id_tbl IN PO_TBL_NUMBER
6 , p_price_update_tol_tbl IN PO_TBL_NUMBER
7 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
8 , x_result_type OUT NOCOPY VARCHAR2
9 );
10
11 PROCEDURE amount_limit_ge_zero(
12 p_header_id_tbl IN PO_TBL_NUMBER
13 , p_amount_limit_tbl IN PO_TBL_NUMBER
14 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
15 , x_result_type OUT NOCOPY VARCHAR2
16 );
17
18 PROCEDURE amt_limit_ge_amt_agreed(
19 p_header_id_tbl IN PO_TBL_NUMBER
20 , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
21 , p_amount_limit_tbl IN PO_TBL_NUMBER
22 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
23 , x_result_type OUT NOCOPY VARCHAR2
24 );
25
26 PROCEDURE amount_agreed_ge_zero(
27 p_header_id_tbl IN PO_TBL_NUMBER
28 , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
29 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
30 , x_result_type OUT NOCOPY VARCHAR2
31 );
32
33 PROCEDURE amount_agreed_not_null(
34 p_header_id_tbl IN PO_TBL_NUMBER
35 , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
36 , p_amount_limit_tbl IN PO_TBL_NUMBER
37 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
38 , x_result_type OUT NOCOPY VARCHAR2
39 );
40
41 PROCEDURE warn_supplier_on_hold(
42 p_header_id_tbl IN PO_TBL_NUMBER
43 , p_vendor_id_tbl IN PO_TBL_NUMBER
44 , x_result_set_id IN OUT NOCOPY NUMBER
45 , x_result_type OUT NOCOPY VARCHAR2
46 );
47
48 PROCEDURE rate_gt_zero(
49 p_header_id_tbl IN PO_TBL_NUMBER
50 , p_rate_tbl IN PO_TBL_NUMBER
51 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
52 , x_result_type OUT NOCOPY VARCHAR2
53 );
54
55 PROCEDURE rate_combination_valid(
56 p_header_id_tbl IN PO_TBL_NUMBER
57 , p_org_id_tbl IN PO_TBL_NUMBER
58 , p_currency_code_tbl IN PO_TBL_VARCHAR30
59 , p_rate_type_tbl IN PO_TBL_VARCHAR30
60 , p_rate_date_tbl IN PO_TBL_DATE
61 , p_rate_tbl IN PO_TBL_NUMBER
62 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
63 , x_result_type OUT NOCOPY VARCHAR2
64 );
65
66 PROCEDURE fax_email_address_valid(
67 p_header_id_tbl IN PO_TBL_NUMBER
68 , p_supplier_notif_method_tbl IN PO_TBL_VARCHAR30
69 , p_fax_tbl IN PO_TBL_VARCHAR30
70 , p_email_address_tbl IN PO_TBL_VARCHAR2000
71 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
72 , x_result_type OUT NOCOPY VARCHAR2
73 );
74
75 PROCEDURE effective_le_expiration(
76 p_header_id_tbl IN PO_TBL_NUMBER
77 , p_start_date_tbl IN PO_TBL_DATE
78 , p_end_date_tbl IN PO_TBL_DATE
79 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
80 , x_result_type OUT NOCOPY VARCHAR2
81 );
82
83 PROCEDURE effective_from_le_order_date(
84 p_header_id_tbl IN PO_TBL_NUMBER
85 , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
86 , p_start_date_tbl IN PO_TBL_DATE
87 , x_result_set_id IN OUT NOCOPY NUMBER
88 , x_result_type OUT NOCOPY VARCHAR2
89 );
90
91 PROCEDURE effective_to_ge_order_date(
92 p_header_id_tbl IN PO_TBL_NUMBER
93 , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
94 , p_end_date_tbl IN PO_TBL_DATE
95 , x_result_set_id IN OUT NOCOPY NUMBER
96 , x_result_type OUT NOCOPY VARCHAR2
97 );
98
99 PROCEDURE contract_start_le_order_date(
100 p_header_id_tbl IN PO_TBL_NUMBER
101 , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
102 , p_start_date_tbl IN PO_TBL_DATE
103 , x_result_set_id IN OUT NOCOPY NUMBER
104 , x_result_type OUT NOCOPY VARCHAR2
105 );
106
107 PROCEDURE contract_end_ge_order_date(
108 p_header_id_tbl IN PO_TBL_NUMBER
109 , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
110 , p_end_date_tbl IN PO_TBL_DATE
111 , x_result_set_id IN OUT NOCOPY NUMBER
112 , x_result_type OUT NOCOPY VARCHAR2
113 );
114
115 PROCEDURE doc_num_chars_valid(
116 p_header_id_tbl IN PO_TBL_NUMBER
117 , p_org_id_tbl IN PO_TBL_NUMBER
118 , p_segment1_tbl IN PO_TBL_VARCHAR30
119 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
120 , x_result_type OUT NOCOPY VARCHAR2
121 );
122
123 PROCEDURE doc_num_unique(
124 p_header_id_tbl IN PO_TBL_NUMBER
125 , p_org_id_tbl IN PO_TBL_NUMBER
126 , p_segment1_tbl IN PO_TBL_VARCHAR30
127 , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
128 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
129 , x_result_type OUT NOCOPY VARCHAR2
130 );
131
132 PROCEDURE check_agreement_dates(
133 p_online_report_id IN NUMBER
134 , p_login_id IN NUMBER
135 , p_user_id IN NUMBER
136 , x_sequence IN OUT NOCOPY NUMBER
137 );
138
139 PROCEDURE agent_id_not_null(
140 p_header_id_tbl IN PO_TBL_NUMBER
141 , p_agent_id_tbl IN PO_TBL_NUMBER
142 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
143 , x_result_type OUT NOCOPY VARCHAR2
144 );
145
146 PROCEDURE ship_to_loc_not_null(
147 p_header_id_tbl IN PO_TBL_NUMBER
148 , p_ship_to_loc_id_tbl IN PO_TBL_NUMBER
149 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
150 , x_result_type OUT NOCOPY VARCHAR2
151 );
152
153 PROCEDURE vendor_id_not_null(
154 p_header_id_tbl IN PO_TBL_NUMBER
155 , p_vendor_id_tbl IN PO_TBL_NUMBER
156 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
157 , x_result_type OUT NOCOPY VARCHAR2
158 );
159
160 PROCEDURE vendor_site_id_not_null(
161 p_header_id_tbl IN PO_TBL_NUMBER
162 , p_vendor_site_id_tbl IN PO_TBL_NUMBER
163 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
164 , x_result_type OUT NOCOPY VARCHAR2
165 );
166
167 --<Begin Bug# 5372769> EXCEPTION WHEN SAVE PO WO/ NUMBER IF DOCUMENT NUMBERING IS SET TO MANUAL
168 PROCEDURE segment1_not_null(
169 p_header_id_tbl IN PO_TBL_NUMBER
170 , p_segment1_tbl IN PO_TBL_VARCHAR30
171 , p_org_id_tbl IN PO_TBL_NUMBER
172 , x_result_set_id IN OUT NOCOPY NUMBER
173 , x_result_type OUT NOCOPY VARCHAR2
174 );
175 --<End 5372769>
176
177 END PO_VAL_HEADERS;