APPS.PSA_BC_XLA_PVT dependencies on PSA_BC_ACCOUNTING_ERRORS

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

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

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

359:
360:
361: -------------------------------------------------------------------------------
362: -- PROCEDURE psa_acctg_errors_insert
363: -- Autonomously insert xla accounting erros rows into psa_bc_accounting_errors
364: -- This will allow to see the error records in PSA view results report
365: -- in case a product team issues a rollback.
366: -------------------------------------------------------------------------------
367:

Line 377: DELETE FROM psa_bc_accounting_errors

373:
374: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure psa_acctg_errors_insert');
375:
376: FORALL i in 1..psa_events.COUNT
377: DELETE FROM psa_bc_accounting_errors
378: WHERE event_id = psa_events(i);
379: psa_utils.debug_other_string(g_state_level,l_path_name,'No of rows deleted from psa_bc_accounting_erros: '||SQL%ROWCOUNT);
380:
381: FORALL j in 1..psa_acctg_errors.COUNT

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

378: WHERE event_id = psa_events(i);
379: psa_utils.debug_other_string(g_state_level,l_path_name,'No of rows deleted from psa_bc_accounting_erros: '||SQL%ROWCOUNT);
380:
381: FORALL j in 1..psa_acctg_errors.COUNT
382: INSERT INTO psa_bc_accounting_errors VALUES psa_acctg_errors(j);
383: psa_utils.debug_other_string(g_state_level,l_path_name,'No of rows inserted into psa_bc_accounting_erros: '||SQL%ROWCOUNT);
384:
385: COMMIT;
386: psa_utils.debug_other_string(g_state_level,l_path_name, 'END of procedure psa_acctg_errors_insert');

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

825: OPEN c_get_xla_acctg_err;
826: FETCH c_get_xla_acctg_err BULK COLLECT INTO l_psa_acctg_errors;
827: CLOSE c_get_xla_acctg_err;
828:
829: -- Delete/Save errors records from/into PSA BC accounting errors table
830: psa_acctg_errors_insert(l_psa_events,l_psa_acctg_errors);
831:
832: IF l_retcode = 2 THEN
833: psa_utils.debug_other_string(g_state_level,l_path_name, 'ERROR returned in SLA Accounting Engine API');