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 298: dual

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

Line 461: dual

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

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

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

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

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

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

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

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

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

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

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

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

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