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.GMS_AWARD_DIST_ENG dependencies on PA_TRANSACTION_XFACE_CONTROL

Line 1629: FROM pa_transaction_xface_control

1625: ' batch = '||batch||
1626: ' sys link = '||etypeclasscode, 1);
1627: SELECT 1
1628: INTO dummy
1629: FROM pa_transaction_xface_control
1630: WHERE transaction_source = trx_source
1631: AND batch_name = batch
1632: AND system_linkage_function = etypeclasscode
1633: AND status = 'PENDING'

Line 1637: pa_cc_utils.log_message('Updated interface id/status on pa_transaction_xface_control',1);

1633: AND status = 'PENDING'
1634: FOR UPDATE OF status NOWAIT;
1635:
1636: pa_cc_utils.log_message('Got lock for record',1);
1637: pa_cc_utils.log_message('Updated interface id/status on pa_transaction_xface_control',1);
1638: pa_cc_utils.reset_curr_function;
1639:
1640: RETURN 0;
1641: EXCEPTION

Line 1798: FROM pa_transaction_xface_control xc

1794: SELECT xc.transaction_source
1795: , xc.batch_name
1796: , xc.system_linkage_function
1797: , xc.batch_name ||xc.system_linkage_function|| to_char(P_xface_id) exp_group_name
1798: FROM pa_transaction_xface_control xc
1799: WHERE xc.transaction_source = P_transaction_source
1800: AND xc.batch_name = nvl(P_batch, xc.batch_name)
1801: AND xc.status = 'PENDING';
1802: