APPS.PSA_BC_XLA_PVT dependencies on PSA_BC_ACCOUNTING_ERRORS

Line 39: TYPE psa_acctg_errors_table IS TABLE OF psa_bc_accounting_errors%ROWTYPE;

35:
36: --==========================================================================
37: -- declaring private variables
38: --==========================================================================
39: TYPE psa_acctg_errors_table IS TABLE OF psa_bc_accounting_errors%ROWTYPE;
40: TYPE psa_events_table IS TABLE OF psa_bc_xla_events_gt.event_id%TYPE;
41:
42: --==========================================================================
43: -- Forward Declaration of PA/GMS API's

Line 52: -- Autonomously insert xla accounting erros rows into psa_bc_accounting_errors

48: procedure psa_cleanup_gt;
49:
50: -------------------------------------------------------------------------------
51: -- PROCEDURE psa_acctg_errors_insert
52: -- Autonomously insert xla accounting erros rows into psa_bc_accounting_errors
53: -- This will allow to see the error records in PSA view results report
54: -- in case a product team issues a rollback.
55: -------------------------------------------------------------------------------
56:

Line 66: DELETE FROM psa_bc_accounting_errors

62:
63: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure psa_acctg_errors_insert');
64:
65: FORALL i in 1..psa_events.COUNT
66: DELETE FROM psa_bc_accounting_errors
67: WHERE event_id = psa_events(i);
68: psa_utils.debug_other_string(g_state_level,l_path_name,'No of rows deleted from psa_bc_accounting_erros: '||SQL%ROWCOUNT);
69:
70: FORALL j in 1..psa_acctg_errors.COUNT

Line 71: INSERT INTO psa_bc_accounting_errors VALUES psa_acctg_errors(j);

67: WHERE event_id = psa_events(i);
68: psa_utils.debug_other_string(g_state_level,l_path_name,'No of rows deleted from psa_bc_accounting_erros: '||SQL%ROWCOUNT);
69:
70: FORALL j in 1..psa_acctg_errors.COUNT
71: INSERT INTO psa_bc_accounting_errors VALUES psa_acctg_errors(j);
72: psa_utils.debug_other_string(g_state_level,l_path_name,'No of rows inserted into psa_bc_accounting_erros: '||SQL%ROWCOUNT);
73:
74: COMMIT;
75: psa_utils.debug_other_string(g_state_level,l_path_name, 'END of procedure psa_acctg_errors_insert');

Line 480: -- Delete/Save errors records from/into PSA BC accounting errors table

476: OPEN c_get_xla_acctg_err;
477: FETCH c_get_xla_acctg_err BULK COLLECT INTO l_psa_acctg_errors;
478: CLOSE c_get_xla_acctg_err;
479:
480: -- Delete/Save errors records from/into PSA BC accounting errors table
481: psa_acctg_errors_insert(l_psa_events,l_psa_acctg_errors);
482:
483: IF l_retcode = 2 THEN
484: psa_utils.debug_other_string(g_state_level,l_path_name, 'ERROR returned in SLA Accounting Engine API');