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_LD_PKG dependencies on PA_TRANSACTION_XFACE_CONTROL

Line 33: pa_transaction_xface_control xc

29: , xc.batch_name
30: , xc.system_linkage_function
31: --, xc.batch_name ||xc.system_linkage_function|| to_char(P_xface_id) exp_group_name name --Bug 3035863 : commented as its not used anywhere
32: FROM
33: pa_transaction_xface_control xc
34: WHERE
35: xc.transaction_source = P_transaction_source
36: AND xc.batch_name = nvl(P_batch, xc.batch_name)
37: AND xc.status = 'PENDING';

Line 274: pa_transaction_xface_control

270:
271: CURSOR C_lock_records IS
272: SELECT 1
273: FROM
274: pa_transaction_xface_control
275: WHERE
276: transaction_source = trx_source
277: AND batch_name = NVL(batch,batch_name) -- Bug 3035863 : Introduced NVL as batch can be NULL
278: AND system_linkage_function = NVL(etypeclasscode,system_linkage_function) -- Bug 3035863 : Introduced NVL as etypeclasscode can be NULL

Line 301: from control table pa_transaction_xface_control and updates them to 'IN_PROGRESS'

297:
298: /* Bug 3035863: Explanation on below code modification
299:
300: Oracle projects Transaction import process picks the PENDING status records
301: from control table pa_transaction_xface_control and updates them to 'IN_PROGRESS'
302: during processing .At the end of process updates them to 'PROCESSED' if successful
303: else in case of failure updates them back to 'PENDING' status.
304:
305: But in Grants the records are marked and left in 'IN_PROGRESS' status. We don't

Line 326: DELETE pa_transaction_xface_control

322: run before updating the current run record to same status. */
323:
324: pa_cc_utils.log_message('GMS_LD_PKG.LOCKCNTRLREC : Deleting interface control record in IN_PROGRESS status which is created during last run' ,1);
325:
326: DELETE pa_transaction_xface_control
327: WHERE transaction_source = trx_source
328: AND batch_name = NVL(batch,batch_name) -- Bug 3035863
329: AND system_linkage_function = NVL(etypeclasscode,system_linkage_function) -- Bug 3035863
330: AND status = 'IN_PROGRESS' ;

Line 332: pa_cc_utils.log_message('GMS_LD_PKG.LOCKCNTRLREC : Number of records deleted from pa_transaction_xface_control : '||SQl%ROWCOUNT);

328: AND batch_name = NVL(batch,batch_name) -- Bug 3035863
329: AND system_linkage_function = NVL(etypeclasscode,system_linkage_function) -- Bug 3035863
330: AND status = 'IN_PROGRESS' ;
331:
332: pa_cc_utils.log_message('GMS_LD_PKG.LOCKCNTRLREC : Number of records deleted from pa_transaction_xface_control : '||SQl%ROWCOUNT);
333:
334: UPDATE pa_transaction_xface_control
335: SET
336: interface_id = P_xface_id

Line 334: UPDATE pa_transaction_xface_control

330: AND status = 'IN_PROGRESS' ;
331:
332: pa_cc_utils.log_message('GMS_LD_PKG.LOCKCNTRLREC : Number of records deleted from pa_transaction_xface_control : '||SQl%ROWCOUNT);
333:
334: UPDATE pa_transaction_xface_control
335: SET
336: interface_id = P_xface_id
337: , status = 'IN_PROGRESS'
338: WHERE

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

340: AND batch_name = NVL(batch,batch_name) -- Bug 3035863
341: AND system_linkage_function = NVL(etypeclasscode,system_linkage_function) -- Bug 3035863
342: AND status = 'PENDING';
343:
344: pa_cc_utils.log_message('Updated interface id/status on pa_transaction_xface_control',1);
345:
346: pa_cc_utils.reset_curr_function;
347: RETURN 0;
348:

Line 409: PROCEDURE PROC_CREATE_GROUP (p_batch_name pa_transaction_xface_control.batch_name%TYPE ) is

405: begin
406: END PROC_FUNDS_CHECK_ENC ;
407: **************************************************************/
408:
409: PROCEDURE PROC_CREATE_GROUP (p_batch_name pa_transaction_xface_control.batch_name%TYPE ) is
410: l_req_id NUMBER; /*bug 5689213*/
411: BEGIN
412:
413: if (X_status is null) then -- Record is accepted by the ValidateItem Proc.

Line 843: FROM pa_transaction_xface_control xc

839: transaction_status_code = 'R'
840: WHERE transaction_status_code ='P'
841: AND (transaction_source,batch_name,decode(system_linkage,'OT','ST',system_linkage)) IN
842: (SELECT xc.transaction_source,xc.batch_name,xc.system_linkage_function
843: FROM pa_transaction_xface_control xc
844: WHERE xc.transaction_source = P_transaction_source
845: AND xc.batch_name = nvl(P_batch, xc.batch_name)
846: AND xc.status = 'PENDING');
847: