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 542: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;

538: l_temp_str := CONCAT(p_prefix,p_name);
539:
540:
541: if (p_type = 'PLAN') THEN
542: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
543: ELSIF (p_type = 'PLANELEMENT') THEN
544: SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;
545: ELSIF (p_type = 'EXPRESSION') THEN
546: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;

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

540:
541: if (p_type = 'PLAN') THEN
542: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
543: ELSIF (p_type = 'PLANELEMENT') THEN
544: SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;
545: ELSIF (p_type = 'EXPRESSION') THEN
546: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
547: ELSIF (p_type = 'RATETABLE') THEN
548: SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;

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

542: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
543: ELSIF (p_type = 'PLANELEMENT') THEN
544: SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;
545: ELSIF (p_type = 'EXPRESSION') THEN
546: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
547: ELSIF (p_type = 'RATETABLE') THEN
548: SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;
549: ELSIF (p_type = 'RATEDIMENSION') THEN
550: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;

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

544: SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;
545: ELSIF (p_type = 'EXPRESSION') THEN
546: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
547: ELSIF (p_type = 'RATETABLE') THEN
548: SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;
549: ELSIF (p_type = 'RATEDIMENSION') THEN
550: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
551: ELSIF (p_type = 'FORMULA') THEN
552: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;

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

546: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
547: ELSIF (p_type = 'RATETABLE') THEN
548: SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;
549: ELSIF (p_type = 'RATEDIMENSION') THEN
550: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
551: ELSIF (p_type = 'FORMULA') THEN
552: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
553: END IF;
554:

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

548: SELECT SUBSTRB(l_temp_str,1,80) into l_return_str FROM DUAL;
549: ELSIF (p_type = 'RATEDIMENSION') THEN
550: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
551: ELSIF (p_type = 'FORMULA') THEN
552: SELECT SUBSTRB(l_temp_str,1,30) into l_return_str FROM DUAL;
553: END IF;
554:
555: return l_return_str;
556: EXCEPTION

Line 755: FROM DUAL

751: , fnd_global.user_id
752: , fnd_global.login_id
753: , SYSDATE
754: , fnd_global.user_id
755: FROM DUAL
756: WHERE NOT EXISTS(
757: SELECT 1
758: FROM cn_calc_edges
759: WHERE parent_id = p_calc_sql_exp_id