APPS.PQH_COMMITMENT_POSTING dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 4485: This procedure populates pa_transaction_interface_all and gms_transaction_interface_all tables

4481: p_call_status OUT NOCOPY BOOLEAN
4482: )
4483: IS
4484: /*
4485: This procedure populates pa_transaction_interface_all and gms_transaction_interface_all tables
4486: and submits conc request to import records in to projects.
4487: It waits till conc request is complete
4488: */
4489: gms_rec gms_transaction_interface_all%ROWTYPE;

Line 4524: INSERT INTO PA_TRANSACTION_INTERFACE_ALL

4520: From dual;
4521: --
4522: -- Insert in to PA_TRANSACTIONS_ALL
4523: --
4524: INSERT INTO PA_TRANSACTION_INTERFACE_ALL
4525: (
4526: TXN_INTERFACE_ID
4527: ,TRANSACTION_SOURCE
4528: ,BATCH_NAME

Line 4652: FROM pa_transaction_interface_all

4648: SELECT
4649: nvl(transaction_rejection_code,'P') rejection_code,
4650: orig_transaction_reference,
4651: transaction_status_code
4652: FROM pa_transaction_interface_all
4653: WHERE transaction_source = 'GMSEPQHC '
4654: AND batch_name = p_gms_batch_name
4655: AND transaction_status_code in ('R', 'PI', 'PR', 'PO');
4656:

Line 4674: FROM pa_transaction_interface_all

4670: -- In both cases import for all records failed
4671: --
4672: SELECT
4673: count(*) into l_cnt
4674: FROM pa_transaction_interface_all
4675: WHERE transaction_source = 'GMSEPQHC '
4676: And batch_name = p_gms_batch_name
4677: And transaction_status_code in ('P', 'I');
4678:

Line 4775: Procedure to purge records from pa_transaction_interface_all and gms_transaction_interface_all

4771: p_gms_batch_name IN varchar2
4772: )
4773: IS
4774: /*
4775: Procedure to purge records from pa_transaction_interface_all and gms_transaction_interface_all
4776: once Import process is complete
4777: */
4778: l_proc varchar2(72) := g_package||'.purge_pa_tables';
4779: PRAGMA AUTONOMOUS_TRANSACTION;

Line 4783: DELETE pa_transaction_interface_all

4779: PRAGMA AUTONOMOUS_TRANSACTION;
4780:
4781: BEGIN
4782: hr_utility.set_location('Entering:'||l_proc, 10);
4783: DELETE pa_transaction_interface_all
4784: WHERE batch_name = p_gms_batch_name
4785: And transaction_source = 'GMSEPQHC ';
4786:
4787: hr_utility.set_location('Deleted pa_transaction_interface_all:',20);

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

4783: DELETE pa_transaction_interface_all
4784: WHERE batch_name = p_gms_batch_name
4785: And transaction_source = 'GMSEPQHC ';
4786:
4787: hr_utility.set_location('Deleted pa_transaction_interface_all:',20);
4788:
4789: DELETE gms_transaction_interface_all
4790: WHERE batch_name = p_gms_batch_name
4791: And transaction_source = 'GMSEPQHC ';

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

4806: /**************************************************************/
4807:
4808: PROCEDURE populate_gms_tables IS
4809: /*
4810: This procedure transfers records from pqh_gl_interface to pa_transaction_interface_all,
4811: kicks off the TRANSACTION IMPORT program in GMS
4812: */
4813:
4814: ---------------Local Variables---------------------------------------------