DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_PVT dependencies on PA_FP_TXN_CURRENCIES

Line 3935: 2) pa_fp_txn_currencies

3931: to the workplan type attached to the project for
3932: the passed project id.
3933: Deletes data from the following tables -
3934: 1) pa_proj_fp_options
3935: 2) pa_fp_txn_currencies
3936: 3) pa_proj_period_profiles
3937: 4) pa_fp_upgrade_audit
3938:
3939: Please note that all validations before calling this API shall be done

Line 4087: -- delete from pa_fp_txn_currencies

4083:
4084: -- delete from pa_proj_fp_options table
4085: DELETE FROM pa_proj_fp_options WHERE proj_fp_options_id = l_proj_fp_options_id;
4086:
4087: -- delete from pa_fp_txn_currencies
4088: DELETE FROM pa_fp_txn_currencies WHERE proj_fp_options_id = l_proj_fp_options_id;
4089:
4090: -- delete from pa_fp_upgrade_audit
4091: DELETE FROM pa_fp_upgrade_audit WHERE proj_fp_options_id = l_proj_fp_options_id;

Line 4088: DELETE FROM pa_fp_txn_currencies WHERE proj_fp_options_id = l_proj_fp_options_id;

4084: -- delete from pa_proj_fp_options table
4085: DELETE FROM pa_proj_fp_options WHERE proj_fp_options_id = l_proj_fp_options_id;
4086:
4087: -- delete from pa_fp_txn_currencies
4088: DELETE FROM pa_fp_txn_currencies WHERE proj_fp_options_id = l_proj_fp_options_id;
4089:
4090: -- delete from pa_fp_upgrade_audit
4091: DELETE FROM pa_fp_upgrade_audit WHERE proj_fp_options_id = l_proj_fp_options_id;
4092: