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.FA_FASRSVES_XMLP_PKG dependencies on DUAL

Line 416: into h_set_of_books_id from dual;

412: -- get mrc related info
413: begin
414: -- h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
415: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
416: into h_set_of_books_id from dual;
417:
418: if (h_set_of_books_id = -1) then
419: h_set_of_books_id := null;
420: end if;

Line 883: into h_set_of_books_id from dual;

879: -- get mrc related info
880: begin
881: --h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
882: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
883: into h_set_of_books_id from dual;
884:
885: if (h_set_of_books_id = -1) then
886: h_set_of_books_id := null;
887: end if;

Line 1091: into h_set_of_books_id from dual;

1087: -- get mrc related info
1088: begin
1089: -- h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
1090: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
1091: into h_set_of_books_id from dual;
1092:
1093: exception
1094: when others then
1095: h_set_of_books_id := null;

Line 1627: into h_set_of_books_id from dual;

1623: -- get mrc related info
1624: begin
1625: --h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
1626: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
1627: into h_set_of_books_id from dual;
1628:
1629: exception
1630: when others then
1631: h_set_of_books_id := null;

Line 1976: into h_set_of_books_id from dual;

1972: -- get mrc related info
1973: begin
1974: --h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
1975: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
1976: into h_set_of_books_id from dual;
1977:
1978: exception
1979: when others then
1980: h_set_of_books_id := null;

Line 2307: into h_set_of_books_id from dual;

2303: -- get mrc related info
2304: begin
2305: -- h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
2306: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
2307: into h_set_of_books_id from dual;
2308:
2309: exception
2310: when others then
2311: h_set_of_books_id := null;

Line 2591: into h_set_of_books_id from dual;

2587: -- get mrc related info
2588: begin
2589: --h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
2590: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
2591: into h_set_of_books_id from dual;
2592:
2593: exception
2594: when others then
2595: h_set_of_books_id := null;