140: /*bug 3224177 start*/
141: -- Refer to Update "16-JAN-04 sagarwal" in the history above.
142: -- This has been added as part of code merge
143: PROCEDURE Delete_Fp_Options
144: (p_project_id IN PA_FP_TXN_CURRENCIES.PROJECT_ID%TYPE
145: ,x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
146:
147:
148: PROCEDURE Update_Txn_Currencies
145: ,x_err_code IN OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
146:
147:
148: PROCEDURE Update_Txn_Currencies
149: ( p_project_id IN PA_FP_TXN_CURRENCIES.PROJECT_ID%TYPE
150: ,p_proj_curr_code IN PA_FP_TXN_CURRENCIES.TXN_CURRENCY_CODE%TYPE);
151: /*bug 3224177 end*/
152:
153:
146:
147:
148: PROCEDURE Update_Txn_Currencies
149: ( p_project_id IN PA_FP_TXN_CURRENCIES.PROJECT_ID%TYPE
150: ,p_proj_curr_code IN PA_FP_TXN_CURRENCIES.TXN_CURRENCY_CODE%TYPE);
151: /*bug 3224177 end*/
152:
153:
154:
276: );
277:
278: PROCEDURE Check_Currency_Name_Or_Code
279: (
280: p_txn_currency_code IN pa_fp_txn_currencies.txn_currency_code%TYPE
281: ,p_currency_code_name IN VARCHAR2
282: ,p_check_id_flag IN VARCHAR2
283: ,x_txn_currency_code OUT NOCOPY pa_fp_txn_currencies.txn_currency_code%TYPE --File.Sql.39 bug 4440895
284: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
279: (
280: p_txn_currency_code IN pa_fp_txn_currencies.txn_currency_code%TYPE
281: ,p_currency_code_name IN VARCHAR2
282: ,p_check_id_flag IN VARCHAR2
283: ,x_txn_currency_code OUT NOCOPY pa_fp_txn_currencies.txn_currency_code%TYPE --File.Sql.39 bug 4440895
284: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
285: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
286: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
287: ) ;