DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_PVT dependencies on PA_FP_TXN_CURRENCIES

Line 3974: 2) pa_fp_txn_currencies

3970: to the workplan type attached to the project for
3971: the passed project id.
3972: Deletes data from the following tables -
3973: 1) pa_proj_fp_options
3974: 2) pa_fp_txn_currencies
3975: 3) pa_proj_period_profiles
3976: 4) pa_fp_upgrade_audit
3977:
3978: Please note that all validations before calling this API shall be done

Line 4126: -- delete from pa_fp_txn_currencies

4122:
4123: -- delete from pa_proj_fp_options table
4124: DELETE FROM pa_proj_fp_options WHERE proj_fp_options_id = l_proj_fp_options_id;
4125:
4126: -- delete from pa_fp_txn_currencies
4127: DELETE FROM pa_fp_txn_currencies WHERE proj_fp_options_id = l_proj_fp_options_id;
4128:
4129: -- delete from pa_fp_upgrade_audit
4130: DELETE FROM pa_fp_upgrade_audit WHERE proj_fp_options_id = l_proj_fp_options_id;

Line 4127: DELETE FROM pa_fp_txn_currencies WHERE proj_fp_options_id = l_proj_fp_options_id;

4123: -- delete from pa_proj_fp_options table
4124: DELETE FROM pa_proj_fp_options WHERE proj_fp_options_id = l_proj_fp_options_id;
4125:
4126: -- delete from pa_fp_txn_currencies
4127: DELETE FROM pa_fp_txn_currencies WHERE proj_fp_options_id = l_proj_fp_options_id;
4128:
4129: -- delete from pa_fp_upgrade_audit
4130: DELETE FROM pa_fp_upgrade_audit WHERE proj_fp_options_id = l_proj_fp_options_id;
4131: