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