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.IGIRSTPT dependencies on IGI_STP_CONTROL

Line 86: igi_stp_control c,

82: pck.exchange_rate,
83: pck.exchange_rate_type,
84: pck.exchange_date
85: FROM igi_stp_packages_all pck,
86: igi_stp_control c,
87: HZ_CUST_SITE_USES rsu,
88: igi_stp_net_type_alloc_all net
89: WHERE c.control_id = p_net_batch_id
90: AND pck.batch_id = c.batch_id

Line 374: from igi_stp_control

370: UPDATE igi_stp_batches
371: SET batch_status = 'ARFAILED'
372: WHERE batch_id in
373: (select batch_id
374: from igi_stp_control
375: where control_id = p_net_batch_id);
376: commit;
377: --bug 3199481 fnd logging changes: sdixit
378:

Line 395: from igi_stp_control

391: UPDATE igi_stp_batches
392: SET batch_status = 'ARFAILED'
393: WHERE batch_id in
394: (select batch_id
395: from igi_stp_control
396: where control_id = p_net_batch_id);
397:
398: commit;
399: --bug 3199481 fnd logging changes: sdixit

Line 454: igi_stp_control c,

450: pck.exchange_rate,
451: pck.exchange_rate_type,
452: pck.exchange_date
453: FROM igi_stp_packages_all pck,
454: igi_stp_control c,
455: igi_stp_net_type_alloc_all type
456: WHERE c.control_id = p_net_batch_id
457: AND pck.batch_id = c.batch_id
458: AND pck.application = 'AP'

Line 639: from igi_stp_control

635: UPDATE igi_stp_batches
636: SET batch_status = 'APFAILED'
637: WHERE batch_id in
638: (select batch_id
639: from igi_stp_control
640: where control_id = p_net_batch_id);
641: commit;
642:
643: --bug 3199481 fnd logging changes: sdixit

Line 663: from igi_stp_control

659: UPDATE igi_stp_batches
660: SET batch_status = 'APFAILED'
661: WHERE batch_id in
662: (select batch_id
663: from igi_stp_control
664: where control_id = p_net_batch_id);
665:
666: commit;
667:

Line 785: from igi_stp_control

781: if l_flag = 'Y' then
782: UPDATE igi_stp_batches
783: SET batch_status = 'APFAILED'
784: WHERE batch_id in (select batch_id
785: from igi_stp_control
786: where control_id = p_net_batch_id);
787: commit;
788: --bug 3199481 fnd logging changes: sdixit
789: --standard way to handle when-others as per FND logging guidelines

Line 825: from igi_stp_control

821: if l_flag = 'Y' then
822: UPDATE igi_stp_batches
823: SET batch_status = 'APFAILED'
824: WHERE batch_id in (select batch_id
825: from igi_stp_control
826: where control_id = p_net_batch_id);
827: commit;
828: --bug 3199481 fnd logging changes: sdixit
829: --standard way to handle when-others as per FND logging guidelines

Line 875: from igi_stp_control

871: SELECT netting_trx_type_id
872: FROM igi_stp_batches_all
873: WHERE batch_id in
874: (select batch_id
875: from igi_stp_control
876: where control_id =p_net_batch_id)
877: and org_id = p_org_id;
878: l_trx_type_id igi_stp_batches.netting_trx_type_id%type;
879: --shsaxena for bug 2713715

Line 1025: from igi_stp_control

1021: update ap_expense_report_headers
1022: set vouchno = 0
1023: where vouchno in
1024: (select batch_id
1025: from igi_stp_control
1026: where control_id
1027: = p_net_batch_id);
1028:
1029: --shsaxena for bug 2713715

Line 1070: from igi_stp_control

1066: UPDATE igi_stp_batches
1067: SET batch_status = 'APFAILED'
1068: WHERE batch_id in
1069: (select batch_id
1070: from igi_stp_control
1071: where control_id
1072: = p_net_batch_id);
1073: COMMIT;
1074:

Line 1140: -- from igi_stp_control

1136: -- UPDATE igi_stp_batches
1137: -- SET batch_status = 'COMPLETE'
1138: -- WHERE batch_id in
1139: -- (select batch_id
1140: -- from igi_stp_control
1141: -- where control_id = p_net_batch_id);
1142: --
1143: -- commit;
1144: -- --fnd_file.put_line(fnd_file.log , 'Submission succeded '||to_char(p_ap_import_request_id));

Line 1254: from igi_stp_control

1250: UPDATE igi_stp_batches
1251: SET batch_status = 'ARFAILED'
1252: WHERE batch_id in
1253: (select batch_id
1254: from igi_stp_control
1255: where control_id = p_net_batch_id);
1256:
1257: COMMIT;
1258:

Line 1323: -- from igi_stp_control

1319: -- UPDATE igi_stp_batches
1320: -- SET batch_status = 'COMPLETE'
1321: -- WHERE batch_id in
1322: -- (select batch_id
1323: -- from igi_stp_control
1324: -- where control_id = p_net_batch_id);
1325: --
1326: -- COMMIT;
1327: -- --fnd_file.put_line(fnd_file.log , 'Submission succeded '||to_char(p_ar_import_request_id));

Line 1347: from igi_stp_control

1343: UPDATE igi_stp_batches
1344: SET batch_status = 'COMPLETE'
1345: WHERE batch_id in
1346: (select batch_id
1347: from igi_stp_control
1348: where control_id = p_net_batch_id);
1349:
1350: commit;
1351: fnd_file.put_line (fnd_file.log , 'Submission succeded for AR --> '||to_char(p_ar_import_request_id));

Line 1363: from igi_stp_control

1359: UPDATE igi_stp_batches
1360: SET batch_status = 'COMPLETE'
1361: WHERE batch_id in
1362: (select batch_id
1363: from igi_stp_control
1364: where control_id = p_net_batch_id);
1365:
1366: COMMIT;
1367: fnd_file.put_line (fnd_file.log , 'Submission succeded for AP --> '||to_char(p_ap_import_request_id));

Line 1378: from igi_stp_control

1374: UPDATE igi_stp_batches
1375: SET batch_status = 'COMPLETE'
1376: WHERE batch_id in
1377: (select batch_id
1378: from igi_stp_control
1379: where control_id = p_net_batch_id);
1380:
1381: COMMIT;
1382: fnd_file.put_line (fnd_file.log , 'Submission succeded for AR --> '||to_char(p_ar_import_request_id));

Line 1394: from igi_stp_control

1390: if l_flag = 'P' then
1391: UPDATE igi_stp_batches
1392: SET batch_status = 'APFAILED'
1393: WHERE batch_id in (select batch_id
1394: from igi_stp_control
1395: where control_id = p_net_batch_id);
1396: commit;
1397: --bug 3199481 fnd logging changes: sdixit
1398: --standard way to handle when-others as per FND logging guidelines

Line 1416: from igi_stp_control

1412: elsif l_flag = 'R' then
1413: UPDATE igi_stp_batches
1414: SET batch_status = 'ARFAILED'
1415: WHERE batch_id in (select batch_id
1416: from igi_stp_control
1417: where control_id = p_net_batch_id);
1418: commit;
1419: --bug 3199481 fnd logging changes: sdixit
1420: --standard way to handle when-others as per FND logging guidelines

Line 1442: from igi_stp_control

1438: if l_flag = 'P' then
1439: UPDATE igi_stp_batches
1440: SET batch_status = 'APFAILED'
1441: WHERE batch_id in (select batch_id
1442: from igi_stp_control
1443: where control_id = p_net_batch_id);
1444: commit;
1445: --bug 3199481 fnd logging changes: sdixit
1446: --standard way to handle when-others as per FND logging guidelines

Line 1464: from igi_stp_control

1460: elsif l_flag = 'R' then
1461: UPDATE igi_stp_batches
1462: SET batch_status = 'ARFAILED'
1463: WHERE batch_id in (select batch_id
1464: from igi_stp_control
1465: where control_id = p_net_batch_id);
1466: commit;
1467: --bug 3199481 fnd logging changes: sdixit
1468: --standard way to handle when-others as per FND logging guidelines