APPS.FV_SLA_PO_PROCESSING_PKG dependencies on FV_EXTRACT_DETAIL_GT

Line 330: FROM fv_extract_detail_gt fed,

326: fed.acc_unanticipated_bud_amount,
327: fed.ent_anticipated_budget_amount,
328: fed.acc_anticipated_budget_amount,
329: fed.rowid fed_rowid
330: FROM fv_extract_detail_gt fed,
331: po_bc_distributions pbd
332: WHERE fed.event_id = pbd.ae_event_id
333: AND fed.line_number = pbd.line_number
334: AND pbd.main_or_backing_code = 'M') LOOP

Line 357: FROM fv_extract_detail_gt fed,

353: INTO l_tot_ent_unanticipated_amt,
354: l_tot_acc_unanticipated_amt,
355: l_tot_ent_anticipated_amt,
356: l_tot_acc_anticipated_amt
357: FROM fv_extract_detail_gt fed,
358: po_bc_distributions pbd
359: WHERE fed.event_id = pbd.ae_event_id
360: AND fed.event_id = gt_rec.event_id
361: AND fed.line_number = pbd.line_number

Line 369: UPDATE fv_extract_detail_gt

365:
366: trace(C_STATE_LEVEL, l_procedure_name, 'l_tot_acc_unanticipated_amt='||l_tot_acc_unanticipated_amt);
367: trace(C_STATE_LEVEL, l_procedure_name, 'l_tot_ent_unanticipated_amt='||l_tot_ent_unanticipated_amt);
368:
369: UPDATE fv_extract_detail_gt
370: SET ent_unanticipated_bud_amount = NVL(ent_unanticipated_bud_amount, 0) + NVL(l_tot_ent_unanticipated_amt, 0),
371: acc_unanticipated_bud_amount = NVL(acc_unanticipated_bud_amount, 0) + NVL(l_tot_acc_unanticipated_amt, 0),
372: ent_anticipated_budget_amount = NVL(ent_anticipated_budget_amount, 0) + NVL(l_tot_ent_anticipated_amt, 0),
373: acc_anticipated_budget_amount = NVL(acc_anticipated_budget_amount, 0) + NVL(l_tot_acc_anticipated_amt, 0)

Line 378: UPDATE fv_extract_detail_gt fed

374: WHERE rowid = gt_rec.fed_rowid;
375:
376: trace(C_STATE_LEVEL, l_procedure_name, 'Updated '||SQL%ROWCOUNT||'rows with rowid');
377:
378: UPDATE fv_extract_detail_gt fed
379: SET ent_unanticipated_bud_amount = 0,
380: acc_unanticipated_bud_amount = 0,
381: ent_anticipated_budget_amount = 0,
382: acc_anticipated_budget_amount = 0

Line 686: INSERT INTO fv_extract_detail_gt

682: --Insert all the data into the fv gt table
683: IF (p_error_code = C_SUCCESS) THEN
684: trace(C_STATE_LEVEL, l_procedure_name, 'Inserting data into GT table');
685: FORALL l_index IN p_fv_extract_detail.first..p_fv_extract_detail.last
686: INSERT INTO fv_extract_detail_gt
687: VALUES p_fv_extract_detail(l_index);
688: trace(C_STATE_LEVEL, l_procedure_name, 'No of rows inserted into FV_EXTRACT_DETAIL_GT: '|| SQL%ROWCOUNT );
689: END IF;
690:

Line 688: trace(C_STATE_LEVEL, l_procedure_name, 'No of rows inserted into FV_EXTRACT_DETAIL_GT: '|| SQL%ROWCOUNT );

684: trace(C_STATE_LEVEL, l_procedure_name, 'Inserting data into GT table');
685: FORALL l_index IN p_fv_extract_detail.first..p_fv_extract_detail.last
686: INSERT INTO fv_extract_detail_gt
687: VALUES p_fv_extract_detail(l_index);
688: trace(C_STATE_LEVEL, l_procedure_name, 'No of rows inserted into FV_EXTRACT_DETAIL_GT: '|| SQL%ROWCOUNT );
689: END IF;
690:
691: --
692: -- Summarize the data