148: P_CHANGE_STAT_TBL IN PO_TBL_VARCHAR30,
149: P_REGEN_Y_N IN VARCHAR2,
150: X_ACRN_TBL OUT NOCOPY PO_TBL_VARCHAR30,
151: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
152: X_RETURN_MESSAGE OUT NOCOPY PO_TBL_VARCHAR2000,
153: X_MESSAGE_TOKEN OUT NOCOPY PO_TBL_VARCHAR2000);
154: /*END Changes the procedure spec for ACRN refactoring and Regenerating*/
155:
156: PROCEDURE IS_VALID_ACRN(P_ACRN IN VARCHAR2,
149: P_REGEN_Y_N IN VARCHAR2,
150: X_ACRN_TBL OUT NOCOPY PO_TBL_VARCHAR30,
151: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
152: X_RETURN_MESSAGE OUT NOCOPY PO_TBL_VARCHAR2000,
153: X_MESSAGE_TOKEN OUT NOCOPY PO_TBL_VARCHAR2000);
154: /*END Changes the procedure spec for ACRN refactoring and Regenerating*/
155:
156: PROCEDURE IS_VALID_ACRN(P_ACRN IN VARCHAR2,
157: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
176: p_change_stat_tbl IN PO_TBL_VARCHAR30,
177: p_regen_y_n IN VARCHAR2,
178: x_acrn_tbl OUT nocopy PO_TBL_VARCHAR30,
179: x_return_status OUT nocopy VARCHAR2,
180: x_return_message OUT nocopy PO_TBL_VARCHAR2000,
181: x_message_token OUT nocopy PO_TBL_VARCHAR2000);
182: --Bug 16518955
183: END PO_ACCOUNT_HELPER;
177: p_regen_y_n IN VARCHAR2,
178: x_acrn_tbl OUT nocopy PO_TBL_VARCHAR30,
179: x_return_status OUT nocopy VARCHAR2,
180: x_return_message OUT nocopy PO_TBL_VARCHAR2000,
181: x_message_token OUT nocopy PO_TBL_VARCHAR2000);
182: --Bug 16518955
183: END PO_ACCOUNT_HELPER;