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.IGIDOSL dependencies on IGI_DOS_TRX_HEADERS

Line 226: SELECT trx_id FROM igi_dos_trx_headers

222: IS
223: SELECT SUM(NVL(s.funds_available,0) - NVL(s.new_balance,0))
224: FROM igi_dos_trx_sources s
225: WHERE trx_id IN (
226: SELECT trx_id FROM igi_dos_trx_headers
227: WHERE trx_number = Dossier_num
228: AND dossier_id = Dossier_id);
229:
230: BEGIN

Line 278: UPDATE igi_dos_trx_headers trx

274: ' l_trx_status --> ' || l_trx_status);
275: /* =============== END DEBUG LOG ================== */
276:
277: -- Flag the DOSSIER as in process
278: UPDATE igi_dos_trx_headers trx
279: SET trx.trx_status = l_trx_status,
280: trx.last_update_date= sysdate
281: WHERE trx.trx_number = dossier_num;
282:

Line 285: ' updated igi_dos_trx_headers ');

281: WHERE trx.trx_number = dossier_num;
282:
283: /* =============== START DEBUG LOG ================ */
284: DEBUG_LOG_STRING (l_proc_level, 'startup.Msg6',
285: ' updated igi_dos_trx_headers ');
286: /* =============== END DEBUG LOG ================== */
287:
288: -- Get the approval run id
289: SELECT igi_dos_approval_run_s1.NextVal

Line 1336: igi_dos_trx_headers thead

1332:
1333: SELECT dtype.sob_id
1334: INTO l_sob_id
1335: FROM igi_dos_doc_types dtype,
1336: igi_dos_trx_headers thead
1337: WHERE thead.dossier_id = dtype.dossier_id
1338: AND thead.trx_number = l_dossier_num;
1339:
1340: /* =============== START DEBUG LOG ================ */

Line 1354: UPDATE igi_dos_trx_headers trx

1350:
1351: IF igi_dos_funds.approve(l_dossier_num, l_user_id, l_responsibility_id, l_sob_id)
1352: THEN
1353:
1354: UPDATE igi_dos_trx_headers trx
1355: SET trx.trx_status = l_trx_status,
1356: trx.last_update_date= sysdate
1357: WHERE trx.trx_number = l_dossier_num;
1358:

Line 1361: ' updating igi_dos_trx_headers ');

1357: WHERE trx.trx_number = l_dossier_num;
1358:
1359: /* =============== START DEBUG LOG ================ */
1360: DEBUG_LOG_STRING (l_proc_level, 'approve.Msg5',
1361: ' updating igi_dos_trx_headers ');
1362: /* =============== END DEBUG LOG ================== */
1363:
1364: ELSE
1365: /* =============== START DEBUG LOG ================ */

Line 1459: UPDATE IGI_DOS_TRX_HEADERS trx

1455: DEBUG_LOG_STRING (l_proc_level, 'reject.Msg3',
1456: ' l_trx_status --> ' || l_trx_status);
1457: /* =============== END DEBUG LOG ================== */
1458:
1459: UPDATE IGI_DOS_TRX_HEADERS trx
1460: SET trx.trx_status = l_trx_status,
1461: trx.last_update_date= sysdate
1462: WHERE trx.trx_number = l_dossier_id;
1463:

Line 1466: ' updating igi_dos_trx_headers ');

1462: WHERE trx.trx_number = l_dossier_id;
1463:
1464: /* =============== START DEBUG LOG ================ */
1465: DEBUG_LOG_STRING (l_proc_level, 'reject.Msg4',
1466: ' updating igi_dos_trx_headers ');
1467: /* =============== END DEBUG LOG ================== */
1468:
1469: result := 'COMPLETE' ;
1470:

Line 2053: igi_dos_trx_headers thead

2049:
2050: SELECT dtype.SOB_ID
2051: INTO l_sob_id
2052: FROM IGI_DOS_DOC_TYPES dtype,
2053: igi_dos_trx_headers thead
2054: WHERE thead.dossier_id = dtype.dossier_id
2055: and thead.trx_number = l_trx_number;
2056:
2057: /* =============== START DEBUG LOG ================ */

Line 2083: UPDATE IGI_DOS_TRX_HEADERS trx

2079: DEBUG_LOG_STRING (l_proc_level, 'UnreserveFunds.Msg5',
2080: ' l_trx_status --> ' || l_trx_status);
2081: /* =============== END DEBUG LOG ================== */
2082:
2083: UPDATE IGI_DOS_TRX_HEADERS trx
2084: SET trx.trx_status = l_trx_status,
2085: trx.last_update_date= sysdate
2086: WHERE trx.trx_number = l_trx_number ;
2087:

Line 2090: ' updated igi_dos_trx_headers ');

2086: WHERE trx.trx_number = l_trx_number ;
2087:
2088: /* =============== START DEBUG LOG ================ */
2089: DEBUG_LOG_STRING (l_proc_level, 'UnreserveFunds.Msg6',
2090: ' updated igi_dos_trx_headers ');
2091: /* =============== END DEBUG LOG ================== */
2092:
2093: END IF ;
2094:

Line 2315: SELECT trx_id FROM igi_dos_trx_headers

2311: l_new_source VARCHAR2(1);
2312:
2313: CURSOR c_get_trx_id
2314: IS
2315: SELECT trx_id FROM igi_dos_trx_headers
2316: WHERE trx_number = l_dossier_num
2317: AND dossier_id = l_dossier_id;
2318:
2319: CURSOR c_get_sources

Line 2609: l_dossier_num igi_dos_trx_headers.trx_number%TYPE :=

2605: funcmode IN VARCHAR2,
2606: result OUT NOCOPY VARCHAR2 ) IS
2607:
2608: l_trx_status igi_lookups.meaning%TYPE;
2609: l_dossier_num igi_dos_trx_headers.trx_number%TYPE :=
2610: Wf_Engine.GetItemAttrText ( itemtype => itemtype,
2611: itemkey => itemkey,
2612: aname => 'DOSSIER_NUM');
2613:

Line 2638: UPDATE igi_dos_trx_headers trx

2634: ' l_trx_status --> ' || l_trx_status);
2635: /* =============== END DEBUG LOG ================== */
2636:
2637: -- Rewind the 'In Process' status to 'Creating'
2638: UPDATE igi_dos_trx_headers trx
2639: SET trx.trx_status = l_trx_status,
2640: trx.last_update_date= sysdate
2641: WHERE trx.trx_number = l_dossier_num;
2642:

Line 2645: ' updating igi_dos_trx_headers ');

2641: WHERE trx.trx_number = l_dossier_num;
2642:
2643: /* =============== START DEBUG LOG ================ */
2644: DEBUG_LOG_STRING (l_proc_level, 'RewindInProcess.Msg3',
2645: ' updating igi_dos_trx_headers ');
2646: /* =============== END DEBUG LOG ================== */
2647:
2648: COMMIT;
2649: