APPS.PSA_UTILS dependencies on PSA_XLA_UNDO_ACCT_AUDIT

Line 412: INSERT INTO psa_xla_undo_acct_audit

408: p_retcode := g_SUCCESS;
409: p_errbuf := NULL;
410: l_path_name := g_path_name || '.start_xla_audit';
411:
412: INSERT INTO psa_xla_undo_acct_audit
413: (
414: audit_id,
415: user_id,
416: resp_id,

Line 441: psa_xla_undo_acct_audit_s.nextval,

437: program_mode
438: )
439: VALUES
440: (
441: psa_xla_undo_acct_audit_s.nextval,
442: g_user_id,
443: g_resp_id,
444: g_login_id,
445: g_request_id,

Line 500: UPDATE psa_xla_undo_acct_audit

496: p_retcode := g_SUCCESS;
497: p_errbuf := NULL;
498: l_path_name := g_path_name || '.end_xla_audit';
499:
500: UPDATE psa_xla_undo_acct_audit
501: SET end_date = SYSDATE,
502: program_status = p_program_status,
503: program_mesg = p_program_mesg
504: WHERE audit_id = p_audit_id;

Line 533: l_program_status psa_xla_undo_acct_audit.program_status%TYPE;

529: l_bc_status VARCHAR2(2000);
530: l_packet_id NUMBER;
531: l_audit_id NUMBER;
532: l_entity_rec xla_transaction_entities%ROWTYPE;
533: l_program_status psa_xla_undo_acct_audit.program_status%TYPE;
534: l_program_mesg psa_xla_undo_acct_audit.program_mesg%TYPE;
535: l_tmp_errbuf VARCHAR2(4000);
536: l_tmp_retcode NUMBER;
537:

Line 534: l_program_mesg psa_xla_undo_acct_audit.program_mesg%TYPE;

530: l_packet_id NUMBER;
531: l_audit_id NUMBER;
532: l_entity_rec xla_transaction_entities%ROWTYPE;
533: l_program_status psa_xla_undo_acct_audit.program_status%TYPE;
534: l_program_mesg psa_xla_undo_acct_audit.program_mesg%TYPE;
535: l_tmp_errbuf VARCHAR2(4000);
536: l_tmp_retcode NUMBER;
537:
538: BEGIN

Line 737: l_program_status psa_xla_undo_acct_audit.program_status%TYPE;

733: l_audit_id NUMBER;
734: l_entity_rec xla_transaction_entities%ROWTYPE;
735: l_tmp_errbuf VARCHAR2(4000);
736: l_tmp_retcode NUMBER;
737: l_program_status psa_xla_undo_acct_audit.program_status%TYPE;
738: l_program_mesg psa_xla_undo_acct_audit.program_mesg%TYPE;
739:
740: BEGIN
741: p_retcode := g_SUCCESS;

Line 738: l_program_mesg psa_xla_undo_acct_audit.program_mesg%TYPE;

734: l_entity_rec xla_transaction_entities%ROWTYPE;
735: l_tmp_errbuf VARCHAR2(4000);
736: l_tmp_retcode NUMBER;
737: l_program_status psa_xla_undo_acct_audit.program_status%TYPE;
738: l_program_mesg psa_xla_undo_acct_audit.program_mesg%TYPE;
739:
740: BEGIN
741: p_retcode := g_SUCCESS;
742: p_errbuf := NULL;