APPS.PQH_GL_POSTING dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 5463: FROM pa_transaction_interface_all

5459: SELECT
5460: nvl(transaction_rejection_code,'P') rejection_code,
5461: orig_transaction_reference,
5462: transaction_status_code
5463: FROM pa_transaction_interface_all
5464: WHERE transaction_source = 'GMSEPQHBC'
5465: AND batch_name = p_gms_batch_name
5466: AND transaction_status_code in ('R', 'PI', 'PR', 'PO');
5467:

Line 5485: FROM pa_transaction_interface_all

5481: -- In both cases import for all records failed
5482: --
5483: SELECT
5484: count(*) into l_cnt
5485: FROM pa_transaction_interface_all
5486: WHERE transaction_source = 'GMSEPQHBC'
5487: And batch_name = p_gms_batch_name
5488: And transaction_status_code in ('P', 'I');
5489:

Line 5587: Procedure to purge records from pa_transaction_interface_all and gms_transaction_interface_all

5583: p_gms_batch_name IN varchar2
5584: )
5585: IS
5586: /*
5587: Procedure to purge records from pa_transaction_interface_all and gms_transaction_interface_all
5588: once Import process is complete
5589: */
5590: l_proc varchar2(72) := g_package||'.purge_pa_tables';
5591: PRAGMA AUTONOMOUS_TRANSACTION;

Line 5595: DELETE pa_transaction_interface_all

5591: PRAGMA AUTONOMOUS_TRANSACTION;
5592:
5593: BEGIN
5594: hr_utility.set_location('Entering:'||l_proc, 10);
5595: DELETE pa_transaction_interface_all
5596: WHERE batch_name = p_gms_batch_name
5597: And transaction_source = 'GMSEPQHBC';
5598:
5599: hr_utility.set_location('Deleted pa_transaction_interface_all:',20);

Line 5599: hr_utility.set_location('Deleted pa_transaction_interface_all:',20);

5595: DELETE pa_transaction_interface_all
5596: WHERE batch_name = p_gms_batch_name
5597: And transaction_source = 'GMSEPQHBC';
5598:
5599: hr_utility.set_location('Deleted pa_transaction_interface_all:',20);
5600:
5601: DELETE gms_transaction_interface_all
5602: WHERE batch_name = p_gms_batch_name
5603: And transaction_source = 'GMSEPQHBC';

Line 5625: This procedure populates pa_transaction_interface_all and gms_transaction_interface_all tables

5621: p_call_status OUT NOCOPY BOOLEAN
5622: )
5623: IS
5624: /*
5625: This procedure populates pa_transaction_interface_all and gms_transaction_interface_all tables
5626: and submits conc request to import records in to projects.
5627: It waits till conc request is complete
5628: */
5629: gms_rec gms_transaction_interface_all%ROWTYPE;

Line 5664: INSERT INTO PA_TRANSACTION_INTERFACE_ALL

5660: From dual;
5661: --
5662: -- Insert in to PA_TRANSACTIONS_ALL
5663: --
5664: INSERT INTO PA_TRANSACTION_INTERFACE_ALL
5665: (
5666: TXN_INTERFACE_ID
5667: ,TRANSACTION_SOURCE
5668: ,BATCH_NAME

Line 5777: This procedure transfers records from pqh_gl_interface to pa_transaction_interface_all,

5773: ----------------------------------------------------------------------------------------------------------
5774:
5775: PROCEDURE populate_gms_tables IS
5776: /*
5777: This procedure transfers records from pqh_gl_interface to pa_transaction_interface_all,
5778: kicks off the TRANSACTION IMPORT program in GMS
5779: */
5780:
5781: ---------------Local Variables---------------------------------------------