APPS.PO_VAL_HEADERS dependencies on PO_TBL_VARCHAR30

Line 58: , p_currency_code_tbl IN PO_TBL_VARCHAR30

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

Line 59: , p_rate_type_tbl IN PO_TBL_VARCHAR30

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

Line 68: , p_supplier_notif_method_tbl IN PO_TBL_VARCHAR30

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

Line 69: , p_fax_tbl IN PO_TBL_VARCHAR30

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

Line 85: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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

Line 93: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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

Line 101: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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

Line 109: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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

Line 118: , p_segment1_tbl IN PO_TBL_VARCHAR30

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:

Line 126: , p_segment1_tbl IN PO_TBL_VARCHAR30

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

Line 127: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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:

Line 170: , p_segment1_tbl IN PO_TBL_VARCHAR30

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