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

Line 398: into h_set_of_books_id from dual;

394: -- get mrc related info
395: begin
396: -- h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
397: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
398: into h_set_of_books_id from dual;
399:
400: if (h_set_of_books_id = -1) then
401: h_set_of_books_id := null;
402: 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 1059: into h_set_of_books_id from dual;

1055: -- get mrc related info
1056: begin
1057: -- h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
1058: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
1059: into h_set_of_books_id from dual;
1060:
1061: exception
1062: when others then
1063: h_set_of_books_id := null;

Line 1589: into h_set_of_books_id from dual;

1585: -- get mrc related info
1586: begin
1587: --h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
1588: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
1589: into h_set_of_books_id from dual;
1590:
1591: exception
1592: when others then
1593: h_set_of_books_id := null;

Line 1929: into h_set_of_books_id from dual;

1925: -- get mrc related info
1926: begin
1927: --h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
1928: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
1929: into h_set_of_books_id from dual;
1930:
1931: exception
1932: when others then
1933: h_set_of_books_id := null;

Line 2252: into h_set_of_books_id from dual;

2248: -- get mrc related info
2249: begin
2250: -- h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
2251: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
2252: into h_set_of_books_id from dual;
2253:
2254: exception
2255: when others then
2256: h_set_of_books_id := null;

Line 2533: into h_set_of_books_id from dual;

2529: -- get mrc related info
2530: begin
2531: --h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
2532: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
2533: into h_set_of_books_id from dual;
2534:
2535: exception
2536: when others then
2537: h_set_of_books_id := null;