eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_GL_POSTING dependencies on GMS_TRANSACTION_INTERFACE_ALL

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

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

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

5601: DELETE gms_transaction_interface_all
5602: WHERE batch_name = p_gms_batch_name
5603: And transaction_source = 'GMSEPQHBC';
5604:
5605: hr_utility.set_location('Deleted gms_transaction_interface_all:',30);
5606: COMMIT;
5607: hr_utility.set_location('Transaction commited:',40);
5608: hr_utility.set_location('Leaving:'||l_proc, 100);
5609: EXCEPTION

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 5629: gms_rec gms_transaction_interface_all%ROWTYPE;

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;
5630: l_proc varchar2(72) := g_package||'.populate_pa_tables';
5631: call_status BOOLEAN;
5632: rphase VARCHAR2(30);
5633: rstatus VARCHAR2(30);