eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VAL_HEADERS dependencies on PO_TBL_NUMBER

Line 5: p_header_id_tbl IN PO_TBL_NUMBER

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

Line 6: , p_price_update_tol_tbl IN PO_TBL_NUMBER

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:

Line 12: p_header_id_tbl IN PO_TBL_NUMBER

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

Line 13: , p_amount_limit_tbl IN PO_TBL_NUMBER

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:

Line 19: p_header_id_tbl IN PO_TBL_NUMBER

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

Line 20: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER

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

Line 21: , p_amount_limit_tbl IN PO_TBL_NUMBER

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:

Line 27: p_header_id_tbl IN PO_TBL_NUMBER

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

Line 28: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER

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:

Line 34: p_header_id_tbl IN PO_TBL_NUMBER

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

Line 35: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER

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

Line 36: , p_amount_limit_tbl IN PO_TBL_NUMBER

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:

Line 42: p_header_id_tbl IN PO_TBL_NUMBER

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

Line 43: , p_vendor_id_tbl IN PO_TBL_NUMBER

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:

Line 49: p_header_id_tbl IN PO_TBL_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: );

Line 50: , p_rate_tbl IN PO_TBL_NUMBER

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:

Line 56: p_header_id_tbl IN PO_TBL_NUMBER

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

Line 57: , p_org_id_tbl IN PO_TBL_NUMBER

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

Line 61: , p_rate_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:

Line 67: p_header_id_tbl IN PO_TBL_NUMBER

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

Line 76: p_header_id_tbl IN PO_TBL_NUMBER

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

Line 84: p_header_id_tbl IN PO_TBL_NUMBER

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

Line 92: p_header_id_tbl IN PO_TBL_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

Line 100: p_header_id_tbl IN PO_TBL_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

Line 108: p_header_id_tbl IN PO_TBL_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

Line 116: p_header_id_tbl IN PO_TBL_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

Line 117: , p_org_id_tbl IN PO_TBL_NUMBER

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

Line 124: p_header_id_tbl IN PO_TBL_NUMBER

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

Line 125: , p_org_id_tbl IN PO_TBL_NUMBER

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

Line 140: p_header_id_tbl IN PO_TBL_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: );

Line 141: , p_agent_id_tbl IN PO_TBL_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:

Line 147: p_header_id_tbl IN PO_TBL_NUMBER

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

Line 148: , p_ship_to_loc_id_tbl IN PO_TBL_NUMBER

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:

Line 154: p_header_id_tbl IN PO_TBL_NUMBER

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

Line 155: , p_vendor_id_tbl IN PO_TBL_NUMBER

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:

Line 161: p_header_id_tbl IN PO_TBL_NUMBER

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

Line 162: , p_vendor_site_id_tbl IN PO_TBL_NUMBER

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:

Line 169: p_header_id_tbl IN PO_TBL_NUMBER

165: );
166:
167: -- 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

Line 171: , p_org_id_tbl IN PO_TBL_NUMBER

167: -- 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: --