APPS.PA_FIN_PLAN_TYPES_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

procedure delete
    (p_fin_plan_type_id               IN     pa_fin_plan_types_b.fin_plan_type_id%type,
     p_record_version_number          IN     pa_fin_plan_types_b.record_version_number%type,
     x_return_status       	      OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
     x_msg_count           	      OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
     x_msg_data		              OUT    NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
 l_msg_count       NUMBER;

Line: 42

                                p_procedure_name   => 'delete');

Line: 46

   pa_fin_plan_types_utils.delete_val
       (  P_FIN_PLAN_TYPE_ID => p_fin_plan_type_id,
          X_RETURN_STATUS => x_return_status,
          X_MSG_COUNT => x_msg_count,
          X_MSG_DATA => x_msg_data);

Line: 70

       pa_fin_plan_types_pkg.delete_row
         (  X_FIN_PLAN_TYPE_ID => p_fin_plan_type_id);

Line: 73

       DELETE
       FROM   pa_pt_co_impl_statuses
       WHERE  fin_plan_type_id=p_fin_plan_type_id;

Line: 87

                               p_procedure_name   => 'delete');

Line: 89

end delete;