APPS.PQH_COMMITMENT_POSTING dependencies on GMS_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 4489: gms_rec gms_transaction_interface_all%ROWTYPE;

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;
4490: l_proc varchar2(72) := g_package||'.populate_pa_tables';
4491: call_status BOOLEAN;
4492: rphase VARCHAR2(30);
4493: rstatus VARCHAR2(30);

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 4789: DELETE gms_transaction_interface_all

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 ';
4792:
4793: hr_utility.set_location('Deleted gms_transaction_interface_all:',30);

Line 4793: hr_utility.set_location('Deleted gms_transaction_interface_all:',30);

4789: DELETE gms_transaction_interface_all
4790: WHERE batch_name = p_gms_batch_name
4791: And transaction_source = 'GMSEPQHC ';
4792:
4793: hr_utility.set_location('Deleted gms_transaction_interface_all:',30);
4794: COMMIT;
4795: hr_utility.set_location('Transaction commited:',40);
4796: hr_utility.set_location('Leaving:'||l_proc, 100);
4797: EXCEPTION