APPS.PSA_FUNDS_CHECKER_PKG dependencies on GL_BC_PACKETS_HISTS

Line 6475: delete from gl_bc_packets_hists bp

6471: ' delete from gl_bc_packet_arrival_order ' || SQL%ROWCOUNT);
6472: -- ========================= FND LOG ===========================
6473:
6474: -- Delete History Record
6475: delete from gl_bc_packets_hists bp
6476: where bp.event_id = p_eventid;
6477:
6478: -- ========================= FND LOG ===========================
6479: psa_utils.debug_other_string(g_state_level,l_full_path,

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

6476: where bp.event_id = p_eventid;
6477:
6478: -- ========================= FND LOG ===========================
6479: psa_utils.debug_other_string(g_state_level,l_full_path,
6480: ' delete from gl_bc_packets_hists ' || SQL%ROWCOUNT);
6481: -- ========================= FND LOG ===========================
6482:
6483: EXCEPTION
6484:

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

7261: /*=======================================================================+
7262: | Function : OPTIMIZE_PACKETS |
7263: | Description : Invoked by bc_optimizer rountine. This acts as a pvt |
7264: | function. Function deletes rows from gl_bc_packets and |
7265: | inserts them in gl_bc_packets_hists. Only rows with |
7266: | status_code R, S, F, T, P, C are deleted. |
7267: +=======================================================================*/
7268:
7269: PROCEDURE optimize_packets (p_ledger_id IN NUMBER, p_purge_days IN NUMBER) IS

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

7276: | |
7277: | Status_Code: |
7278: | =========== |
7279: | R, S, F, T - All rows for the p_ledger_id |
7280: | - These rows should get inserted in gl_bc_packets_hists |
7281: | |
7282: | P, C - All rows for the p_ledger_id for which session has |
7283: | expired or which are older than 5 days (120 hours) |
7284: | - These rows should not be stored in gl_bc_packets_hists |

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

7280: | - These rows should get inserted in gl_bc_packets_hists |
7281: | |
7282: | P, C - All rows for the p_ledger_id for which session has |
7283: | expired or which are older than 5 days (120 hours) |
7284: | - These rows should not be stored in gl_bc_packets_hists |
7285: | |
7286: +----------------------------------------------------------------------*/
7287:
7288:

Line 7404: insert into gl_bc_packets_hists

7400: -- ========================= FND LOG =============================
7401:
7402:
7403: FORALL i IN 1..g_bc_pkts_hist.count
7404: insert into gl_bc_packets_hists
7405: values g_bc_pkts_hist(i);
7406:
7407: if p_purge_days > 0 then
7408:

Line 7478: | Deletes rows from gl_bc_packets_hists depending upon |

7474:
7475: /*=======================================================================+
7476: | Function : BC_PURGE_HIST |
7477: | Description : Invoked by SRS "Budgetary Control History Purge" |
7478: | Deletes rows from gl_bc_packets_hists depending upon |
7479: | the criteria selected by user while running SRS |
7480: +=======================================================================*/
7481:
7482: PROCEDURE bc_purge_hist (err_buf OUT NOCOPY VARCHAR2,

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

7501: 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'));
7502: -- ========================= FND LOG =============================
7503:
7504:
7505: l_stmt := 'delete from gl_bc_packets_hists '||
7506: 'where (last_update_date < :purge_date) '||
7507: ' and ledger_id = :p_ledger_id ';
7508:
7509: l_status_code := CASE p_purge_mode||p_purge_statuses