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 1495: FROM pa_transaction_xface_control

1491: ' batch = '||batch||
1492: ' sys link = '||etypeclasscode, 1);
1493: SELECT 1
1494: INTO dummy
1495: FROM pa_transaction_xface_control
1496: WHERE transaction_source = trx_source
1497: AND batch_name = batch
1498: AND system_linkage_function = etypeclasscode
1499: AND status = 'PENDING'

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

1499: AND status = 'PENDING'
1500: FOR UPDATE OF status NOWAIT;
1501:
1502: pa_cc_utils.log_message('Got lock for record',1);
1503: pa_cc_utils.log_message('Updated interface id/status on pa_transaction_xface_control',1);
1504: pa_cc_utils.reset_curr_function;
1505:
1506: RETURN 0;
1507: EXCEPTION

Line 1664: FROM pa_transaction_xface_control xc

1660: SELECT xc.transaction_source
1661: , xc.batch_name
1662: , xc.system_linkage_function
1663: , xc.batch_name ||xc.system_linkage_function|| to_char(P_xface_id) exp_group_name
1664: FROM pa_transaction_xface_control xc
1665: WHERE xc.transaction_source = P_transaction_source
1666: AND xc.batch_name = nvl(P_batch, xc.batch_name)
1667: AND xc.status = 'PENDING';
1668: