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

Line 47: select substr(to_char(abs(dbms_random.random)),1,RAND_NUM_LENGTH) into l_unique_identifier from dual;

43: -- EXPRESSION Name : 30 Chararcters
44: -- Formula Name : 30 characters
45: -- Scenario Name : 80 characters
46:
47: select substr(to_char(abs(dbms_random.random)),1,RAND_NUM_LENGTH) into l_unique_identifier from dual;
48: select fnd_message.get_string('CN','CN_COPY_MSG') into l_msg_copy from dual;
49:
50: -- Magic number 2 is for an underscore and 1 extra character
51:

Line 48: select fnd_message.get_string('CN','CN_COPY_MSG') into l_msg_copy from dual;

44: -- Formula Name : 30 characters
45: -- Scenario Name : 80 characters
46:
47: select substr(to_char(abs(dbms_random.random)),1,RAND_NUM_LENGTH) into l_unique_identifier from dual;
48: select fnd_message.get_string('CN','CN_COPY_MSG') into l_msg_copy from dual;
49:
50: -- Magic number 2 is for an underscore and 1 extra character
51:
52: l_length := RAND_NUM_LENGTH + 2 + LENGTHB(l_msg_copy);

Line 494: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;

490: l_temp_str := CONCAT(p_prefix,p_name);
491:
492:
493: if (p_type = 'PLAN') THEN
494: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
495: ELSIF (p_type = 'PLANELEMENT') THEN
496: SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;
497: ELSIF (p_type = 'EXPRESSION') THEN
498: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;

Line 496: SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;

492:
493: if (p_type = 'PLAN') THEN
494: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
495: ELSIF (p_type = 'PLANELEMENT') THEN
496: SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;
497: ELSIF (p_type = 'EXPRESSION') THEN
498: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
499: ELSIF (p_type = 'RATETABLE') THEN
500: SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;

Line 498: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;

494: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
495: ELSIF (p_type = 'PLANELEMENT') THEN
496: SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;
497: ELSIF (p_type = 'EXPRESSION') THEN
498: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
499: ELSIF (p_type = 'RATETABLE') THEN
500: SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;
501: ELSIF (p_type = 'RATEDIMENSION') THEN
502: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;

Line 500: SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;

496: SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;
497: ELSIF (p_type = 'EXPRESSION') THEN
498: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
499: ELSIF (p_type = 'RATETABLE') THEN
500: SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;
501: ELSIF (p_type = 'RATEDIMENSION') THEN
502: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
503: ELSIF (p_type = 'FORMULA') THEN
504: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;

Line 502: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;

498: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
499: ELSIF (p_type = 'RATETABLE') THEN
500: SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;
501: ELSIF (p_type = 'RATEDIMENSION') THEN
502: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
503: ELSIF (p_type = 'FORMULA') THEN
504: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
505: END IF;
506:

Line 504: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;

500: SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;
501: ELSIF (p_type = 'RATEDIMENSION') THEN
502: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
503: ELSIF (p_type = 'FORMULA') THEN
504: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
505: END IF;
506:
507: return l_return_str;
508: EXCEPTION