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_HEADERS2 dependencies on PO_TBL_VARCHAR30

Line 18: p_type_lookup_code_tbl IN po_tbl_varchar30,

14: -- type_lookup_code cannot be null and must be equal to
15: -- BLANKET, STANDARD or QUOTATION.
16: -------------------------------------------------------------------------
17: PROCEDURE type_lookup_code(p_id_tbl IN po_tbl_number,
18: p_type_lookup_code_tbl IN po_tbl_varchar30,
19: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
20: x_result_type OUT NOCOPY VARCHAR2);
21:
22: -----------------------------------------------------------------------------------------

Line 28: p_document_num_tbl IN po_tbl_varchar30,

24: -----------------------------------------------------------------------------------------
25: PROCEDURE document_num(
26: p_id_tbl IN po_tbl_number,
27: p_po_header_id_tbl IN po_tbl_number,
28: p_document_num_tbl IN po_tbl_varchar30,
29: p_type_lookup_code_tbl IN po_tbl_varchar30,
30: p_manual_po_num_type IN VARCHAR2,
31: p_manual_quote_num_type IN VARCHAR2,
32: x_results IN OUT NOCOPY po_validation_results_type,

Line 29: p_type_lookup_code_tbl IN po_tbl_varchar30,

25: PROCEDURE document_num(
26: p_id_tbl IN po_tbl_number,
27: p_po_header_id_tbl IN po_tbl_number,
28: p_document_num_tbl IN po_tbl_varchar30,
29: p_type_lookup_code_tbl IN po_tbl_varchar30,
30: p_manual_po_num_type IN VARCHAR2,
31: p_manual_quote_num_type IN VARCHAR2,
32: x_results IN OUT NOCOPY po_validation_results_type,
33: x_result_set_id IN OUT NOCOPY NUMBER,

Line 40: p_currency_code_tbl IN po_tbl_varchar30,

36: -------------------------------------------------------------------------
37: -- validate currency_code not null and against FND_CURRENCIES.
38: -------------------------------------------------------------------------
39: PROCEDURE currency_code(p_id_tbl IN po_tbl_number,
40: p_currency_code_tbl IN po_tbl_varchar30,
41: x_result_set_id IN OUT NOCOPY NUMBER,
42: x_result_type OUT NOCOPY VARCHAR2);
43:
44: -------------------------------------------------------------------------

Line 51: p_currency_code_tbl IN PO_TBL_VARCHAR30,

47: -- validate rate_type against gl_daily_conversion_type_v, validate rate is not null and positive,
48: -- validate rate against g1_currency_api.get_rate().
49: -------------------------------------------------------------------------
50: PROCEDURE rate_info(p_id_tbl IN po_tbl_number,
51: p_currency_code_tbl IN PO_TBL_VARCHAR30,
52: p_rate_type_tbl IN PO_TBL_VARCHAR30,
53: p_rate_tbl IN po_tbl_number,
54: p_rate_date_tbl IN po_tbl_date,
55: p_func_currency_code IN VARCHAR2,

Line 52: p_rate_type_tbl IN PO_TBL_VARCHAR30,

48: -- validate rate against g1_currency_api.get_rate().
49: -------------------------------------------------------------------------
50: PROCEDURE rate_info(p_id_tbl IN po_tbl_number,
51: p_currency_code_tbl IN PO_TBL_VARCHAR30,
52: p_rate_type_tbl IN PO_TBL_VARCHAR30,
53: p_rate_tbl IN po_tbl_number,
54: p_rate_date_tbl IN po_tbl_date,
55: p_func_currency_code IN VARCHAR2,
56: p_set_of_books_id IN NUMBER,

Line 81: p_type_lookup_code_tbl IN po_tbl_varchar30, --8913559 bug

77: PROCEDURE vendor_info(p_id_tbl IN po_tbl_number,
78: p_vendor_id_tbl IN po_tbl_number,
79: p_vendor_site_id_tbl IN po_tbl_number,
80: p_vendor_contact_id_tbl IN po_tbl_number,
81: p_type_lookup_code_tbl IN po_tbl_varchar30, --8913559 bug
82: p_federal_instance IN VARCHAR,
83: x_result_set_id IN OUT NOCOPY NUMBER,
84: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
85: x_result_type OUT NOCOPY VARCHAR2);

Line 93: p_type_lookup_code_tbl IN po_tbl_varchar30,

89: -------------------------------------------------------------------------
90: PROCEDURE ship_to_location_id(p_id_tbl IN po_tbl_number,
91: p_ship_to_location_id_tbl IN po_tbl_number,
92: -- Bug 7007502: Added new param p_type_lookup_code_tbl
93: p_type_lookup_code_tbl IN po_tbl_varchar30,
94: x_result_set_id IN OUT NOCOPY NUMBER,
95: x_result_type OUT NOCOPY VARCHAR2);
96:
97: -------------------------------------------------------------------------

Line 103: p_type_lookup_code_tbl IN po_tbl_varchar30,

99: -------------------------------------------------------------------------
100: PROCEDURE bill_to_location_id(p_id_tbl IN po_tbl_number,
101: p_bill_to_location_id_tbl IN po_tbl_number,
102: -- Bug 7007502: Added new param p_type_lookup_code_tbl
103: p_type_lookup_code_tbl IN po_tbl_varchar30,
104: x_result_set_id IN OUT NOCOPY NUMBER,
105: x_result_type OUT NOCOPY VARCHAR2);
106:
107: -------------------------------------------------------------------------

Line 111: p_ship_via_lookup_code_tbl IN PO_TBL_VARCHAR30,

107: -------------------------------------------------------------------------
108: -- validate ship_via_lookup_code against ORG_FREIGHT
109: -------------------------------------------------------------------------
110: PROCEDURE ship_via_lookup_code(p_id_tbl IN po_tbl_number,
111: p_ship_via_lookup_code_tbl IN PO_TBL_VARCHAR30,
112: p_inventory_org_id IN NUMBER,
113: x_result_set_id IN OUT NOCOPY NUMBER,
114: x_result_type OUT NOCOPY VARCHAR2);
115:

Line 120: p_fob_lookup_code_tbl IN PO_TBL_VARCHAR30,

116: -------------------------------------------------------------------------
117: -- validate fob_lookup_code against PO_LOOKUP_CODES
118: -------------------------------------------------------------------------
119: PROCEDURE fob_lookup_code(p_id_tbl IN po_tbl_number,
120: p_fob_lookup_code_tbl IN PO_TBL_VARCHAR30,
121: x_result_set_id IN OUT NOCOPY NUMBER,
122: x_result_type OUT NOCOPY VARCHAR2);
123:
124: -------------------------------------------------------------------------

Line 128: p_freight_terms_lookup_tbl IN PO_TBL_VARCHAR30,

124: -------------------------------------------------------------------------
125: -- validate freight_terms_lookup_code against PO_LOOKUP_CODES
126: -------------------------------------------------------------------------
127: PROCEDURE freight_terms_lookup_code(p_id_tbl IN po_tbl_number,
128: p_freight_terms_lookup_tbl IN PO_TBL_VARCHAR30,
129: x_result_set_id IN OUT NOCOPY NUMBER,
130: x_result_type OUT NOCOPY VARCHAR2);
131:
132: -------------------------------------------------------------------------

Line 136: p_shipping_control_tbl IN PO_TBL_VARCHAR30,

132: -------------------------------------------------------------------------
133: -- validate shipping_control against PO_LOOKUP_CODES
134: -------------------------------------------------------------------------
135: PROCEDURE shipping_control(p_id_tbl IN po_tbl_number,
136: p_shipping_control_tbl IN PO_TBL_VARCHAR30,
137: x_result_set_id IN OUT NOCOPY NUMBER,
138: x_result_type OUT NOCOPY VARCHAR2);
139:
140: -------------------------------------------------------------------------

Line 162: p_closed_code_tbl IN PO_TBL_VARCHAR30,

158: -------------------------------------------------------------------------
159: -- validate closed_code = OPEN. Only called for Blanket and SPO.
160: -------------------------------------------------------------------------
161: PROCEDURE closed_code(p_id_tbl IN po_tbl_number,
162: p_closed_code_tbl IN PO_TBL_VARCHAR30,
163: p_acceptance_reqd_flag_tbl IN PO_TBL_VARCHAR1,
164: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
165: x_result_type OUT NOCOPY VARCHAR2);
166:

Line 172: p_approval_status_tbl IN PO_TBL_VARCHAR30,

168: -- validate print_count = 0. Only called for Blanket and SPO.
169: -------------------------------------------------------------------------
170: PROCEDURE print_count(p_id_tbl IN po_tbl_number,
171: p_print_count_tbl IN po_tbl_number,
172: p_approval_status_tbl IN PO_TBL_VARCHAR30,
173: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
174: x_result_type OUT NOCOPY VARCHAR2);
175:
176: -------------------------------------------------------------------------

Line 181: p_approval_status_tbl IN PO_TBL_VARCHAR30,

177: -- validate approval_status = INCOMPLETE, APPROVED, INITIATE APPROVAL.
178: -- Only called for Blanket and SPO.
179: -------------------------------------------------------------------------
180: PROCEDURE approval_status(p_id_tbl IN po_tbl_number,
181: p_approval_status_tbl IN PO_TBL_VARCHAR30,
182: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
183: x_result_type OUT NOCOPY VARCHAR2);
184:
185: -------------------------------------------------------------------------

Line 207: p_type_lookup_code_tbl IN PO_TBL_VARCHAR30,

203: -- validate that acceptance_reuqired_flag has correct value
204: -------------------------------------------------------------------------
205: PROCEDURE acceptance_required_flag
206: ( p_id_tbl IN PO_TBL_NUMBER,
207: p_type_lookup_code_tbl IN PO_TBL_VARCHAR30,
208: p_acceptance_required_flag_tbl IN PO_TBL_VARCHAR1,
209: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
210: x_result_type OUT NOCOPY VARCHAR2
211: );