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.XTR_EFT_SCRIPT_P dependencies on XTR_MTS_RECORDS

Line 287: -- fetch from XTR_MTS_RECORDS spool to file

283: and b.party_code = d.company_code;
284:
285:
286: --
287: -- fetch from XTR_MTS_RECORDS spool to file
288: --
289: cursor MTS_REC is
290: select transfer_details, file_name
291: from XTR_MTS_RECORDS

Line 291: from XTR_MTS_RECORDS

287: -- fetch from XTR_MTS_RECORDS spool to file
288: --
289: cursor MTS_REC is
290: select transfer_details, file_name
291: from XTR_MTS_RECORDS
292: order by FILE_NAME,CREATED_ON_DATE asc;
293:
294: --
295: l_date DATE := sysdate;

Line 338: XTR_RISK_DEBUG_PKG.dlog('BNZ_EFT: ' || '>Insert into XTR_MTS_RECORDS');

334:
335: l_date := l_date + 0.000011;
336: IF xtr_risk_debug_pkg.g_Debug THEN
337: XTR_RISK_DEBUG_PKG.dlog('BNZ_EFT: ' || '> l_date = '|| l_date);
338: XTR_RISK_DEBUG_PKG.dlog('BNZ_EFT: ' || '>Insert into XTR_MTS_RECORDS');
339: XTR_RISK_DEBUG_PKG.dlog('BNZ_EFT: ' || '>l_eft_Script_name = '|| l_eft_script_name||
340: ' cre_header = '||cre_header||
341: ' l_date = '||l_date||
342: ' l_file_name = '|| l_file_name||

Line 346: insert into XTR_MTS_RECORDS(script_name,transfer_details,created_on_date,

342: ' l_file_name = '|| l_file_name||
343: ' settlement_date = '|| settlement_date);
344: END IF;
345:
346: insert into XTR_MTS_RECORDS(script_name,transfer_details,created_on_date,
347: file_name,settlement_date)
348: values(l_eft_script_name,deb_header,l_date,l_file_name,
349: --2305918 to_date(settlement_date,'DD-MON-RR'));
350: trunc(settlement_date));

Line 378: XTR_RISK_DEBUG_PKG.dlog('BNZ_EFT: ' || '>>Insert into XTR_MTS_RECORDS');

374:
375: curr := 2;
376: l_date := l_date + 0.000011;
377: IF xtr_risk_debug_pkg.g_Debug THEN
378: XTR_RISK_DEBUG_PKG.dlog('BNZ_EFT: ' || '>>Insert into XTR_MTS_RECORDS');
379: END IF;
380: insert into XTR_MTS_RECORDS(script_name,transfer_details,created_on_date,
381: file_name,settlement_date)
382: values(l_eft_script_name,deb_rec,l_date,l_file_name,

Line 380: insert into XTR_MTS_RECORDS(script_name,transfer_details,created_on_date,

376: l_date := l_date + 0.000011;
377: IF xtr_risk_debug_pkg.g_Debug THEN
378: XTR_RISK_DEBUG_PKG.dlog('BNZ_EFT: ' || '>>Insert into XTR_MTS_RECORDS');
379: END IF;
380: insert into XTR_MTS_RECORDS(script_name,transfer_details,created_on_date,
381: file_name,settlement_date)
382: values(l_eft_script_name,deb_rec,l_date,l_file_name,
383: --RV 2305918 to_date(settlement_date,'DD-MON-RR'));
384: trunc(settlement_date));

Line 406: insert into XTR_MTS_RECORDS(script_name,transfer_details,created_on_date,

402: deb_hash := substr(d_hash,4);
403: end if;
404: deb_ctrl := '3'||spce||to_char(deb_tot_amt)||spce||to_char(deb_count)||spce||deb_hash;
405: l_date := l_date + 0.000011;
406: insert into XTR_MTS_RECORDS(script_name,transfer_details,created_on_date,
407: file_name,settlement_date)
408: values(l_eft_script_name,deb_ctrl,l_date,l_file_name,
409: --RV 2305918 to_date(settlement_date,'DD-MON-RR'));
410: trunc(settlement_date));

Line 429: XTR_RISK_DEBUG_PKG.dlog('BNZ_EFT: ' || '> Insert into XTR_MTS_RECORDS');

425:
426: l_date := l_date + 0.000011;
427: IF xtr_risk_debug_pkg.g_Debug THEN
428: XTR_RISK_DEBUG_PKG.dlog('BNZ_EFT: ' || '> l_date = ' || l_date);
429: XTR_RISK_DEBUG_PKG.dlog('BNZ_EFT: ' || '> Insert into XTR_MTS_RECORDS');
430: XTR_RISK_DEBUG_PKG.dlog('BNZ_EFT: ' || '>l_eft_Script_name = '|| l_eft_script_name||
431: ' cre_header = '||cre_header||
432: ' l_date = '||l_date||
433: ' l_file_name = '|| l_file_name||

Line 436: insert into XTR_MTS_RECORDS(script_name,transfer_details,created_on_date,

432: ' l_date = '||l_date||
433: ' l_file_name = '|| l_file_name||
434: ' settlement_date = '|| settlement_date);
435: END IF;
436: insert into XTR_MTS_RECORDS(script_name,transfer_details,created_on_date,
437: file_name,settlement_date)
438: values(l_eft_script_name,cre_header,l_date,l_file_name,
439: -- RV 2305918 to_date(settlement_date,'DD-MON-RR'));
440: trunc(settlement_date));

Line 460: insert into XTR_MTS_RECORDS(script_name,transfer_details,created_on_date,

456: End;
457:
458: curr := 2;
459: l_date := l_date + 0.000011;
460: insert into XTR_MTS_RECORDS(script_name,transfer_details,created_on_date,
461: file_name,settlement_date)
462: values(l_eft_script_name,cre_rec,l_date,l_file_name,
463: -- RV 2305918 to_date(settlement_date,'DD-MON-RR'));
464: trunc(settlement_date));

Line 482: insert into XTR_MTS_RECORDS(script_name,transfer_details,created_on_date,

478: cre_hash := substr(c_hash,4);
479: end if;
480: cre_ctrl := '3'||spce||to_char(cre_tot_amt)||spce||to_char(cre_count)||spce||cre_hash;
481: l_date := l_date + 0.000011;
482: insert into XTR_MTS_RECORDS(script_name,transfer_details,created_on_date,
483: file_name,settlement_date)
484: values(l_eft_script_name,cre_ctrl,l_date,l_file_name,
485: --RV 2305198 to_date(settlement_date,'DD-MON-RR'));
486: trunc(settlement_date));

Line 559: -- delete data from XTR_MTS_RECORDS table

555: --FND_FILE.put_names ('eft.log', 'eft.out', '/tmp/');
556: FND_FILE.put_line(FND_FILE.OUTPUT, mts_details);
557: --FND_FILE.new_line(FND_FILE.OUTPUT,1);
558: --
559: -- delete data from XTR_MTS_RECORDS table
560: --
561: DELETE from XTR_MTS_RECORDS
562: WHERE file_name = mts_file_name
563: AND transfer_details = mts_details;

Line 561: DELETE from XTR_MTS_RECORDS

557: --FND_FILE.new_line(FND_FILE.OUTPUT,1);
558: --
559: -- delete data from XTR_MTS_RECORDS table
560: --
561: DELETE from XTR_MTS_RECORDS
562: WHERE file_name = mts_file_name
563: AND transfer_details = mts_details;
564:
565: IF xtr_risk_debug_pkg.g_Debug THEN