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

Line 297: dual

293: BEGIN
294: SELECT
295: 1 into l_exists
296: FROM
297: dual
298: WHERE
299: exists ( select attr_id from ego_templ_attributes eta, ego_attrs_v av
300: where 'MTL_SYSTEM_ITEMS.'||av.database_column = p_attribute_name
301: and eta.attribute_id = av.attr_id

Line 460: dual

456: BEGIN
457: SELECT
458: 1 into l_exists
459: FROM
460: dual
461: WHERE
462: exists ( select attr_id from ego_templ_attributes eta, ego_attrs_v av
463: where 'MTL_SYSTEM_ITEMS.'||av.database_column = p_attribute_name
464: and eta.attribute_id = av.attr_id

Line 570: select to_number(p_attribute_value) into l_attr_number_value from dual;

566: IF( l_data_type_code = G_CHAR_DATA_TYPE ) THEN
567: l_attr_string_value := p_attribute_value;
568: ELSIF( l_data_type_code = G_NUMBER_DATA_TYPE ) THEN
569: -- convert attribute value to number
570: select to_number(p_attribute_value) into l_attr_number_value from dual;
571: ELSIF( l_data_type_code = G_DATE_DATA_TYPE ) THEN
572: -- convert attribute value to date
573: select to_date(p_attribute_value, 'DD/MM/YYYY') into l_attr_date_value from dual;
574: ELSIF( l_data_type_code = G_DATE_TIME_DATA_TYPE ) THEN

Line 573: select to_date(p_attribute_value, 'DD/MM/YYYY') into l_attr_date_value from dual;

569: -- convert attribute value to number
570: select to_number(p_attribute_value) into l_attr_number_value from dual;
571: ELSIF( l_data_type_code = G_DATE_DATA_TYPE ) THEN
572: -- convert attribute value to date
573: select to_date(p_attribute_value, 'DD/MM/YYYY') into l_attr_date_value from dual;
574: ELSIF( l_data_type_code = G_DATE_TIME_DATA_TYPE ) THEN
575: -- convert attribute value to date time
576: select to_date(p_attribute_value, 'DD/MM/YYYY HH:MM:SS AM') into l_attr_date_value from dual;
577: ELSIF( l_data_type_code = G_TRANS_TEXT_DATA_TYPE ) THEN

Line 576: select to_date(p_attribute_value, 'DD/MM/YYYY HH:MM:SS AM') into l_attr_date_value from dual;

572: -- convert attribute value to date
573: select to_date(p_attribute_value, 'DD/MM/YYYY') into l_attr_date_value from dual;
574: ELSIF( l_data_type_code = G_DATE_TIME_DATA_TYPE ) THEN
575: -- convert attribute value to date time
576: select to_date(p_attribute_value, 'DD/MM/YYYY HH:MM:SS AM') into l_attr_date_value from dual;
577: ELSIF( l_data_type_code = G_TRANS_TEXT_DATA_TYPE ) THEN
578: l_attr_translated_value := p_attribute_value;
579: ELSE
580: RAISE e_data_type_missing;

Line 674: select to_number(p_attribute_value) into l_attr_number_value from dual;

670: l_attr_string_value := p_attribute_value;
671:
672: ELSIF( l_data_type_code = G_NUMBER_DATA_TYPE ) THEN
673: -- convert attribute value to number
674: select to_number(p_attribute_value) into l_attr_number_value from dual;
675:
676: ELSIF( l_data_type_code = G_DATE_DATA_TYPE ) THEN
677: -- convert attribute value to date
678: select to_date(p_attribute_value, 'DD/MM/YYYY') into l_attr_date_value from dual;

Line 678: select to_date(p_attribute_value, 'DD/MM/YYYY') into l_attr_date_value from dual;

674: select to_number(p_attribute_value) into l_attr_number_value from dual;
675:
676: ELSIF( l_data_type_code = G_DATE_DATA_TYPE ) THEN
677: -- convert attribute value to date
678: select to_date(p_attribute_value, 'DD/MM/YYYY') into l_attr_date_value from dual;
679:
680: ELSIF( l_data_type_code = G_DATE_TIME_DATA_TYPE ) THEN
681: select to_date(p_attribute_value, 'DD/MM/YYYY HH:MM:SS AM') into l_attr_date_value from dual;
682:

Line 681: select to_date(p_attribute_value, 'DD/MM/YYYY HH:MM:SS AM') into l_attr_date_value from dual;

677: -- convert attribute value to date
678: select to_date(p_attribute_value, 'DD/MM/YYYY') into l_attr_date_value from dual;
679:
680: ELSIF( l_data_type_code = G_DATE_TIME_DATA_TYPE ) THEN
681: select to_date(p_attribute_value, 'DD/MM/YYYY HH:MM:SS AM') into l_attr_date_value from dual;
682:
683: ELSIF( l_data_type_code = G_TRANS_TEXT_DATA_TYPE ) THEN
684: l_attr_translated_value := p_attribute_value;
685: