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_FASRSVED_XMLP_PKG dependencies on DUAL

Line 425: into h_set_of_books_id from dual;

421: -- get mrc related info
422: begin
423: -- h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
424: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
425: into h_set_of_books_id from dual;
426:
427: if (h_set_of_books_id = -1) then
428: h_set_of_books_id := null;
429: end if;

Line 886: into h_set_of_books_id from dual;

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

Line 1086: into h_set_of_books_id from dual;

1082: -- get mrc related info
1083: begin
1084: -- h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
1085: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
1086: into h_set_of_books_id from dual;
1087:
1088: exception
1089: when others then
1090: h_set_of_books_id := null;

Line 1616: into h_set_of_books_id from dual;

1612: -- get mrc related info
1613: begin
1614: --h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
1615: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
1616: into h_set_of_books_id from dual;
1617:
1618: exception
1619: when others then
1620: h_set_of_books_id := null;

Line 1956: into h_set_of_books_id from dual;

1952: -- get mrc related info
1953: begin
1954: --h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
1955: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
1956: into h_set_of_books_id from dual;
1957:
1958: exception
1959: when others then
1960: h_set_of_books_id := null;

Line 2279: into h_set_of_books_id from dual;

2275: -- get mrc related info
2276: begin
2277: -- h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
2278: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
2279: into h_set_of_books_id from dual;
2280:
2281: exception
2282: when others then
2283: h_set_of_books_id := null;

Line 2560: into h_set_of_books_id from dual;

2556: -- get mrc related info
2557: begin
2558: --h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
2559: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
2560: into h_set_of_books_id from dual;
2561:
2562: exception
2563: when others then
2564: h_set_of_books_id := null;