DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS dependencies on PO_TBL_DATE

Line 61: , p_rate_date_tbl IN PO_TBL_DATE

57: p_header_id_tbl IN PO_TBL_NUMBER
58: , p_org_id_tbl IN PO_TBL_NUMBER
59: , p_currency_code_tbl IN PO_TBL_VARCHAR30
60: , p_rate_type_tbl IN PO_TBL_VARCHAR30
61: , p_rate_date_tbl IN PO_TBL_DATE
62: , p_rate_tbl IN PO_TBL_NUMBER
63: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
64: , x_result_type OUT NOCOPY VARCHAR2
65: );

Line 78: , p_start_date_tbl IN PO_TBL_DATE

74: );
75:
76: PROCEDURE effective_le_expiration(
77: p_header_id_tbl IN PO_TBL_NUMBER
78: , p_start_date_tbl IN PO_TBL_DATE
79: , p_end_date_tbl IN PO_TBL_DATE
80: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
81: , x_result_type OUT NOCOPY VARCHAR2
82: );

Line 79: , p_end_date_tbl IN PO_TBL_DATE

75:
76: PROCEDURE effective_le_expiration(
77: p_header_id_tbl IN PO_TBL_NUMBER
78: , p_start_date_tbl IN PO_TBL_DATE
79: , p_end_date_tbl IN PO_TBL_DATE
80: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
81: , x_result_type OUT NOCOPY VARCHAR2
82: );
83:

Line 87: , p_start_date_tbl IN PO_TBL_DATE

83:
84: PROCEDURE effective_from_le_order_date(
85: p_header_id_tbl IN PO_TBL_NUMBER
86: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
87: , p_start_date_tbl IN PO_TBL_DATE
88: , x_result_set_id IN OUT NOCOPY NUMBER
89: , x_result_type OUT NOCOPY VARCHAR2
90: );
91:

Line 95: , p_end_date_tbl IN PO_TBL_DATE

91:
92: PROCEDURE effective_to_ge_order_date(
93: p_header_id_tbl IN PO_TBL_NUMBER
94: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
95: , p_end_date_tbl IN PO_TBL_DATE
96: , x_result_set_id IN OUT NOCOPY NUMBER
97: , x_result_type OUT NOCOPY VARCHAR2
98: );
99:

Line 103: , p_start_date_tbl IN PO_TBL_DATE

99:
100: PROCEDURE contract_start_le_order_date(
101: p_header_id_tbl IN PO_TBL_NUMBER
102: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
103: , p_start_date_tbl IN PO_TBL_DATE
104: , x_result_set_id IN OUT NOCOPY NUMBER
105: , x_result_type OUT NOCOPY VARCHAR2
106: );
107:

Line 111: , p_end_date_tbl IN PO_TBL_DATE

107:
108: PROCEDURE contract_end_ge_order_date(
109: p_header_id_tbl IN PO_TBL_NUMBER
110: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
111: , p_end_date_tbl IN PO_TBL_DATE
112: , x_result_set_id IN OUT NOCOPY NUMBER
113: , x_result_type OUT NOCOPY VARCHAR2
114: );
115:

Line 193: ,p_mod_eff_date_tbl IN PO_TBL_DATE

189:
190: --Mod Project
191: PROCEDURE mod_eff_dt_lt_need_by_dt(
192: p_header_id_tbl IN PO_TBL_NUMBER
193: ,p_mod_eff_date_tbl IN PO_TBL_DATE
194: ,x_result_set_id IN OUT NOCOPY NUMBER
195: ,x_result_type OUT NOCOPY VARCHAR2
196: );
197:

Line 201: ,p_mod_eff_date_tbl IN PO_TBL_DATE

197:
198: PROCEDURE mod_eff_dt_not_null(
199: p_header_id_tbl IN PO_TBL_NUMBER
200: ,p_draft_type_tbl IN PO_TBL_VARCHAR30
201: ,p_mod_eff_date_tbl IN PO_TBL_DATE
202: ,x_result_set_id IN OUT NOCOPY NUMBER
203: ,x_result_type OUT NOCOPY VARCHAR2
204: );
205:

Line 230: , p_start_date_tbl IN PO_TBL_DATE

226:
227: PROCEDURE clm_eff_from_le_order_date(
228: p_header_id_tbl IN PO_TBL_NUMBER
229: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
230: , p_start_date_tbl IN PO_TBL_DATE
231: , p_clm_effective_date_tbl IN PO_TBL_DATE
232: , x_result_set_id IN OUT NOCOPY NUMBER
233: , x_result_type OUT NOCOPY VARCHAR2
234: );

Line 231: , p_clm_effective_date_tbl IN PO_TBL_DATE

227: PROCEDURE clm_eff_from_le_order_date(
228: p_header_id_tbl IN PO_TBL_NUMBER
229: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
230: , p_start_date_tbl IN PO_TBL_DATE
231: , p_clm_effective_date_tbl IN PO_TBL_DATE
232: , x_result_set_id IN OUT NOCOPY NUMBER
233: , x_result_type OUT NOCOPY VARCHAR2
234: );
235: