APPS.PSA_FUNDS_CHECKER_PKG dependencies on GL_BC_PACKETS_HISTS

Line 6550: delete from gl_bc_packets_hists bp

6546: ' delete from gl_bc_packet_arrival_order ' || SQL%ROWCOUNT);
6547: -- ========================= FND LOG ===========================
6548:
6549: -- Delete History Record
6550: delete from gl_bc_packets_hists bp
6551: where bp.event_id = p_eventid;
6552:
6553: -- ========================= FND LOG ===========================
6554: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 6555: ' delete from gl_bc_packets_hists ' || SQL%ROWCOUNT);

6551: where bp.event_id = p_eventid;
6552:
6553: -- ========================= FND LOG ===========================
6554: psa_utils.debug_other_string(g_state_level,l_full_path,
6555: ' delete from gl_bc_packets_hists ' || SQL%ROWCOUNT);
6556: -- ========================= FND LOG ===========================
6557:
6558: EXCEPTION
6559:

Line 7340: | inserts them in gl_bc_packets_hists. Only rows with |

7336: /*=======================================================================+
7337: | Function : OPTIMIZE_PACKETS |
7338: | Description : Invoked by bc_optimizer rountine. This acts as a pvt |
7339: | function. Function deletes rows from gl_bc_packets and |
7340: | inserts them in gl_bc_packets_hists. Only rows with |
7341: | status_code R, S, F, T, P, C are deleted. |
7342: +=======================================================================*/
7343:
7344: PROCEDURE optimize_packets (p_ledger_id IN NUMBER, p_purge_days IN NUMBER) IS

Line 7355: | - These rows should get inserted in gl_bc_packets_hists |

7351: | |
7352: | Status_Code: |
7353: | =========== |
7354: | R, S, F, T - All rows for the p_ledger_id |
7355: | - These rows should get inserted in gl_bc_packets_hists |
7356: | |
7357: | P, C - All rows for the p_ledger_id for which session has |
7358: | expired or which are older than 5 days (120 hours) |
7359: | - These rows should not be stored in gl_bc_packets_hists |

Line 7359: | - These rows should not be stored in gl_bc_packets_hists |

7355: | - These rows should get inserted in gl_bc_packets_hists |
7356: | |
7357: | P, C - All rows for the p_ledger_id for which session has |
7358: | expired or which are older than 5 days (120 hours) |
7359: | - These rows should not be stored in gl_bc_packets_hists |
7360: | |
7361: +----------------------------------------------------------------------*/
7362:
7363:

Line 7482: insert into gl_bc_packets_hists

7478:
7479: EXIT WHEN g_bc_pkts_hist.count = 0;
7480:
7481: FORALL i IN 1..g_bc_pkts_hist.count
7482: insert into gl_bc_packets_hists
7483: values g_bc_pkts_hist(i);
7484:
7485: END LOOP; -- Bug 10171221
7486:

Line 7664: | Deletes rows from gl_bc_packets_hists depending upon |

7660:
7661: /*=======================================================================+
7662: | Function : BC_PURGE_HIST |
7663: | Description : Invoked by SRS "Budgetary Control History Purge" |
7664: | Deletes rows from gl_bc_packets_hists depending upon |
7665: | the criteria selected by user while running SRS |
7666: +=======================================================================*/
7667:
7668: PROCEDURE bc_purge_hist (err_buf OUT NOCOPY VARCHAR2,

Line 7691: l_stmt := 'delete from gl_bc_packets_hists '||

7687: psa_utils.debug_other_string(g_state_level,l_full_path, ' l_purge_date -> ' || TO_CHAR(l_purge_date, 'DD-MON-YYYY HH24:MI:SS'));
7688: -- ========================= FND LOG =============================
7689:
7690:
7691: l_stmt := 'delete from gl_bc_packets_hists '||
7692: 'where (last_update_date < :purge_date) '||
7693: ' and ledger_id = :p_ledger_id ';
7694:
7695: l_status_code := CASE p_purge_mode||p_purge_statuses