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

Line 392: into h_set_of_books_id from dual;

388: -- get mrc related info
389: begin
390: -- h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
391: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
392: into h_set_of_books_id from dual;
393:
394: if (h_set_of_books_id = -1) then
395: h_set_of_books_id := null;
396: end if;

Line 859: into h_set_of_books_id from dual;

855: -- get mrc related info
856: begin
857: --h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
858: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
859: into h_set_of_books_id from dual;
860:
861: if (h_set_of_books_id = -1) then
862: h_set_of_books_id := null;
863: end if;

Line 1067: into h_set_of_books_id from dual;

1063: -- get mrc related info
1064: begin
1065: -- h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
1066: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
1067: into h_set_of_books_id from dual;
1068:
1069: exception
1070: when others then
1071: h_set_of_books_id := null;

Line 1603: into h_set_of_books_id from dual;

1599: -- get mrc related info
1600: begin
1601: --h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
1602: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
1603: into h_set_of_books_id from dual;
1604:
1605: exception
1606: when others then
1607: h_set_of_books_id := null;

Line 1952: into h_set_of_books_id from dual;

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

Line 2283: into h_set_of_books_id from dual;

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

Line 2567: into h_set_of_books_id from dual;

2563: -- get mrc related info
2564: begin
2565: --h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
2566: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
2567: into h_set_of_books_id from dual;
2568:
2569: exception
2570: when others then
2571: h_set_of_books_id := null;