APPS.PA_REP_UTIL_SETUP SQL Statements

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

Line: 17

  l_records_update  NUMBER :=0;

Line: 25

  select cdl.rowid
	from  pa_expenditure_items_all          ei
             ,pa_cost_distribution_lines_all   cdl
    where ei.expenditure_item_date < p_cut_off_date
    and ei.expenditure_item_id = cdl.expenditure_item_id;

Line: 104

     PA_DEBUG.g_err_stage := '250 : Before Update CDL flag to X';

Line: 110

        UPDATE pa_cost_distribution_lines_all  cdl
        SET cdl.util_summarized_flag = 'X'
        WHERE rowid = rec.rowid;

Line: 114

        l_records_update := l_records_update + 1;

Line: 116

        IF l_records_update = l_commit_size THEN
           commit;

Line: 118

           l_records_update := 0;

Line: 122

       PA_DEBUG.g_err_stage := '300 : After  update the CDL Flag';