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
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;
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: