DBA Data[Home] [Help]

APPS.PO_ACCOUNT_HELPER dependencies on PO_TBL_VARCHAR30

Line 146: P_ACRN_TBL IN PO_TBL_VARCHAR30,

142: /*Changed the procedure spec for ACRN refactoring and Regenerating*/
143: PROCEDURE BUILD_ACRN(p_header_id IN NUMBER,
144: P_DIST_ID_TBL IN PO_TBL_NUMBER,
145: P_CODE_ID_TBL IN PO_TBL_NUMBER,
146: P_ACRN_TBL IN PO_TBL_VARCHAR30,
147: P_LOA_TBL IN PO_TBL_VARCHAR30,
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,

Line 147: P_LOA_TBL IN PO_TBL_VARCHAR30,

143: PROCEDURE BUILD_ACRN(p_header_id IN NUMBER,
144: P_DIST_ID_TBL IN PO_TBL_NUMBER,
145: P_CODE_ID_TBL IN PO_TBL_NUMBER,
146: P_ACRN_TBL IN PO_TBL_VARCHAR30,
147: P_LOA_TBL IN PO_TBL_VARCHAR30,
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,

Line 148: P_CHANGE_STAT_TBL IN PO_TBL_VARCHAR30,

144: P_DIST_ID_TBL IN PO_TBL_NUMBER,
145: P_CODE_ID_TBL IN PO_TBL_NUMBER,
146: P_ACRN_TBL IN PO_TBL_VARCHAR30,
147: P_LOA_TBL IN PO_TBL_VARCHAR30,
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,

Line 150: X_ACRN_TBL OUT NOCOPY PO_TBL_VARCHAR30,

146: P_ACRN_TBL IN PO_TBL_VARCHAR30,
147: P_LOA_TBL IN PO_TBL_VARCHAR30,
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*/

Line 174: p_acrn_tbl IN PO_TBL_VARCHAR30,

170: --Bug 16518955
171: PROCEDURE BUILD_ACRN_WRAP(p_header_id IN NUMBER,
172: p_dist_id_tbl IN PO_TBL_NUMBER,
173: p_code_id_tbl IN PO_TBL_NUMBER,
174: p_acrn_tbl IN PO_TBL_VARCHAR30,
175: p_loa_tbl IN PO_TBL_VARCHAR30,
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,

Line 175: p_loa_tbl IN PO_TBL_VARCHAR30,

171: PROCEDURE BUILD_ACRN_WRAP(p_header_id IN NUMBER,
172: p_dist_id_tbl IN PO_TBL_NUMBER,
173: p_code_id_tbl IN PO_TBL_NUMBER,
174: p_acrn_tbl IN PO_TBL_VARCHAR30,
175: p_loa_tbl IN PO_TBL_VARCHAR30,
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,

Line 176: p_change_stat_tbl IN PO_TBL_VARCHAR30,

172: p_dist_id_tbl IN PO_TBL_NUMBER,
173: p_code_id_tbl IN PO_TBL_NUMBER,
174: p_acrn_tbl IN PO_TBL_VARCHAR30,
175: p_loa_tbl IN PO_TBL_VARCHAR30,
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,

Line 178: x_acrn_tbl OUT nocopy PO_TBL_VARCHAR30,

174: p_acrn_tbl IN PO_TBL_VARCHAR30,
175: p_loa_tbl IN PO_TBL_VARCHAR30,
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