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

Line 796: FROM DUAL;

792: l_err_token_table(2).TOKEN_NAME := 'CLASS_MEANING';
793: BEGIN
794: SELECT EGO_EXT_FWK_PUB.Get_Class_Meaning(p_object_name, error_rec.class_code_value)
795: INTO l_err_token_table(2).TOKEN_VALUE
796: FROM DUAL;
797: EXCEPTION
798: WHEN OTHERS THEN
799: l_err_token_table(2).TOKEN_VALUE := error_rec.class_code_value;
800: END;

Line 1497: FROM DUAL;

1493: G_ENTITY_ID := p_entity_id;
1494: -- entity code will take precedence over entity_id
1495: SELECT NVL(p_entity_code, DECODE(G_ENTITY_ID, NULL, G_APPLICATION_CONTEXT||'_EXTFWK_USER_ATTRS',NULL))
1496: INTO G_ENTITY_CODE
1497: FROM DUAL;
1498:
1499: -- Initialize error handler
1500: IF FND_API.To_Boolean(p_init_error_handler) THEN
1501: ERROR_HANDLER.Initialize;

Line 2861: EXECUTE IMMEDIATE 'SELECT TO_CHAR('||G_NULL_DATE_VAL||','''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||'''), TO_CHAR('||G_NULL_DATE_VAL||', ''SYYYY-MM-DD'') FROM DUAL '

2857: -----------------------------------------------------
2858: -- Validating, replacing the NULL characters here.
2859: -----------------------------------------------------
2860:
2861: EXECUTE IMMEDIATE 'SELECT TO_CHAR('||G_NULL_DATE_VAL||','''||EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||'''), TO_CHAR('||G_NULL_DATE_VAL||', ''SYYYY-MM-DD'') FROM DUAL '
2862: INTO l_null_date_time_value,l_null_date_value;
2863:
2864: l_dynamic_sql := 'UPDATE '||p_interface_table_name||' SET ';
2865: IF (l_attr_metadata_rec.DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

Line 3893: SELECT REPLACE(l_tvs_where_clause,FND_GLOBAL.LOCAL_CHR(10),FND_GLOBAL.LOCAL_CHR(32)) INTO l_tvs_where_clause FROM dual; --replacing new line character

3889: ------------------------------------------------------
3890: -- In case the where clause has new line or tabs --
3891: -- we need to remove it BugFix:4101091 --
3892: ------------------------------------------------------
3893: SELECT REPLACE(l_tvs_where_clause,FND_GLOBAL.LOCAL_CHR(10),FND_GLOBAL.LOCAL_CHR(32)) INTO l_tvs_where_clause FROM dual; --replacing new line character
3894: SELECT REPLACE(l_tvs_where_clause,FND_GLOBAL.LOCAL_CHR(13),FND_GLOBAL.LOCAL_CHR(32)) INTO l_tvs_where_clause FROM dual; --removing carriage return
3895:
3896: IF(INSTR(UPPER(l_tvs_where_clause),' ORDER ')) <> 0 THEN --Bug:4065857 gnanda we need to remove the order by clause if any in the where clause
3897: l_tvs_where_clause := SUBSTR(l_tvs_where_clause, 1 , INSTR(UPPER(l_tvs_where_clause),' ORDER '));

Line 3894: SELECT REPLACE(l_tvs_where_clause,FND_GLOBAL.LOCAL_CHR(13),FND_GLOBAL.LOCAL_CHR(32)) INTO l_tvs_where_clause FROM dual; --removing carriage return

3890: -- In case the where clause has new line or tabs --
3891: -- we need to remove it BugFix:4101091 --
3892: ------------------------------------------------------
3893: SELECT REPLACE(l_tvs_where_clause,FND_GLOBAL.LOCAL_CHR(10),FND_GLOBAL.LOCAL_CHR(32)) INTO l_tvs_where_clause FROM dual; --replacing new line character
3894: SELECT REPLACE(l_tvs_where_clause,FND_GLOBAL.LOCAL_CHR(13),FND_GLOBAL.LOCAL_CHR(32)) INTO l_tvs_where_clause FROM dual; --removing carriage return
3895:
3896: IF(INSTR(UPPER(l_tvs_where_clause),' ORDER ')) <> 0 THEN --Bug:4065857 gnanda we need to remove the order by clause if any in the where clause
3897: l_tvs_where_clause := SUBSTR(l_tvs_where_clause, 1 , INSTR(UPPER(l_tvs_where_clause),' ORDER '));
3898: END IF;

Line 3977: SELECT REPLACE(l_tvs_where_clause,':$OBJECT$','UAI1') INTO l_tvs_where_clause FROM DUAL;

3973: END LOOP;
3974:
3975: WHILE (INSTR(l_tvs_where_clause, ':$OBJECT$') > 0)
3976: LOOP
3977: SELECT REPLACE(l_tvs_where_clause,':$OBJECT$','UAI1') INTO l_tvs_where_clause FROM DUAL;
3978: END LOOP;
3979:
3980: /*
3981: NOTE ...

Line 4584: SELECT REPLACE(l_tvs_where_clause,FND_GLOBAL.LOCAL_CHR(10),FND_GLOBAL.LOCAL_CHR(32)) INTO l_tvs_where_clause FROM dual; --replacing new line character

4580: ------------------------------------------------------
4581: -- In case the where clause has new line or tabs --
4582: -- we need to remove it BugFix:4101091 --
4583: ------------------------------------------------------
4584: SELECT REPLACE(l_tvs_where_clause,FND_GLOBAL.LOCAL_CHR(10),FND_GLOBAL.LOCAL_CHR(32)) INTO l_tvs_where_clause FROM dual; --replacing new line character
4585: SELECT REPLACE(l_tvs_where_clause,FND_GLOBAL.LOCAL_CHR(13),FND_GLOBAL.LOCAL_CHR(32)) INTO l_tvs_where_clause FROM dual; --removing carriage return
4586:
4587: IF(INSTR(UPPER(l_tvs_where_clause),' ORDER ')) <> 0 THEN --Bug:4065857 gnanda we need to remove the order by clause if any in the where clause
4588: l_tvs_where_clause := SUBSTR(l_tvs_where_clause, 1 , INSTR(UPPER(l_tvs_where_clause),' ORDER '));

Line 4585: SELECT REPLACE(l_tvs_where_clause,FND_GLOBAL.LOCAL_CHR(13),FND_GLOBAL.LOCAL_CHR(32)) INTO l_tvs_where_clause FROM dual; --removing carriage return

4581: -- In case the where clause has new line or tabs --
4582: -- we need to remove it BugFix:4101091 --
4583: ------------------------------------------------------
4584: SELECT REPLACE(l_tvs_where_clause,FND_GLOBAL.LOCAL_CHR(10),FND_GLOBAL.LOCAL_CHR(32)) INTO l_tvs_where_clause FROM dual; --replacing new line character
4585: SELECT REPLACE(l_tvs_where_clause,FND_GLOBAL.LOCAL_CHR(13),FND_GLOBAL.LOCAL_CHR(32)) INTO l_tvs_where_clause FROM dual; --removing carriage return
4586:
4587: IF(INSTR(UPPER(l_tvs_where_clause),' ORDER ')) <> 0 THEN --Bug:4065857 gnanda we need to remove the order by clause if any in the where clause
4588: l_tvs_where_clause := SUBSTR(l_tvs_where_clause, 1 , INSTR(UPPER(l_tvs_where_clause),' ORDER '));
4589: END IF;

Line 4690: SELECT REPLACE(l_tvs_where_clause,':$OBJECT$','UAI1') INTO l_tvs_where_clause FROM DUAL;

4686:
4687: END LOOP;
4688: WHILE (INSTR(l_tvs_where_clause, ':$OBJECT$') > 0)
4689: LOOP
4690: SELECT REPLACE(l_tvs_where_clause,':$OBJECT$','UAI1') INTO l_tvs_where_clause FROM DUAL;
4691: END LOOP;
4692: /*
4693: THERE COULD BE A POSSIBILITY THAT THE TVS QUERY RETURNS MORE THAN ONE ROW
4694: IN THIS CASE WE JUST TAKE THE FIRST ROW : ( i.e. WHERE ROWNUM = 1)

Line 5942: 'NVL((SELECT NVL(RTCQ.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||','||wierd_constant||') FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM '||

5938: --i.e. l_rtcq_to_ext_whr_uks_idnt_chk.
5939: l_rtcq_to_ext_where_uks := l_rtcq_to_ext_where_uks||
5940: ' AND NVL(RTCQ.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||','||wierd_constant||')'||
5941: '= DECODE (RTCQ.TRANSACTION_TYPE, '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''' , '||
5942: 'NVL((SELECT NVL(RTCQ.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||','||wierd_constant||') FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM '||
5943: l_ext_tl_table_name||' WHERE EXTENSION_ID = EXT.EXTENSION_ID AND ROWNUM = 1 )), '||wierd_constant_2||' ) '||
5944: ',NVL((SELECT '||l_attr_metadata_table_sr(d).DATABASE_COLUMN || ' FROM '||l_ext_tl_table_name||' WHERE LANGUAGE = USERENV(''LANG'') AND EXTENSION_ID = EXT.EXTENSION_ID),'||wierd_constant||' ) '||
5945: ')';
5946: l_rtcq_to_ext_whr_uks_idnt_chk := l_rtcq_to_ext_whr_uks_idnt_chk||

Line 8026: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') FROM DUAL';

8022: l_error_code := G_PS_INVALID_DATE_DATA ;
8023: IF (INSTR(p_value_to_convert,'$SYSDATE$') > 0 ) THEN
8024: l_formated_string := TRIM(REPLACE(p_value_to_convert, '$'));
8025: l_dynamic_sql := 'SELECT TO_CHAR('||l_formated_string||', '''||
8026: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') FROM DUAL';
8027: EXECUTE IMMEDIATE l_dynamic_sql INTO l_formated_string;
8028: l_date_value := TO_DATE(l_formated_string,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
8029: ELSE
8030: l_date_value := TO_DATE(p_value_to_convert, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

Line 8038: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') FROM DUAL';

8034: l_error_code := G_PS_INVALID_DATE_TIME_DATA ;
8035: IF (INSTR(p_value_to_convert,'$SYSDATE$') > 0 ) THEN
8036: l_formated_string := TRIM(REPLACE(p_value_to_convert, '$'));
8037: l_dynamic_sql := 'SELECT TO_CHAR('||l_formated_string||', '''||
8038: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') FROM DUAL';
8039: EXECUTE IMMEDIATE l_dynamic_sql INTO l_formated_string;
8040: l_date_value := TO_DATE(l_formated_string,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
8041: ELSE
8042: l_date_value := TO_DATE(p_value_to_convert,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

Line 8073: 'YYYY-MM-DD HH24:MI:SS'||''') FROM DUAL';

8069:
8070: IF (INSTR(UPPER(p_date),'$SYSDATE$') > 0 ) THEN
8071: l_formated_string := TRIM(REPLACE(p_date, '$'));
8072: l_dynamic_sql := 'SELECT TO_CHAR('||l_formated_string||', '''||
8073: 'YYYY-MM-DD HH24:MI:SS'||''') FROM DUAL';
8074: EXECUTE IMMEDIATE l_dynamic_sql INTO l_formated_string;
8075: l_date := TO_DATE(l_formated_string,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
8076: RETURN l_date;
8077: ELSE

Line 8126: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') FROM DUAL';--'SYYYY-MM-DD HH24:MI:SS'

8122:
8123: IF (INSTR(p_value_to_check,'$SYSDATE$') > 0 ) THEN
8124: l_formated_string := TRIM(REPLACE(p_value_to_check, '$'));
8125: l_dynamic_sql := 'SELECT TO_CHAR('||l_formated_string||', '''||
8126: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') FROM DUAL';--'SYYYY-MM-DD HH24:MI:SS'
8127: EXECUTE IMMEDIATE l_dynamic_sql INTO l_formated_string;
8128: l_date_value := TO_DATE(l_formated_string,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);--'SYYYY-MM-DD HH24:MI:SS'
8129: ELSE
8130: l_date_value := TO_DATE(p_value_to_check,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

Line 8136: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') FROM DUAL';--'SYYYY-MM-DD HH24:MI:SS'

8132:
8133: IF (INSTR(p_max_value,'$SYSDATE$') > 0 ) THEN
8134: l_formated_string := TRIM(REPLACE(p_max_value, '$'));
8135: l_dynamic_sql := 'SELECT TO_CHAR('||l_formated_string||', '''||
8136: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') FROM DUAL';--'SYYYY-MM-DD HH24:MI:SS'
8137: EXECUTE IMMEDIATE l_dynamic_sql INTO l_formated_string;
8138: l_max_date := TO_DATE(l_formated_string,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);--'YYYY-MM-DD HH24:MI:SS'
8139: ELSE
8140: l_index_max := INSTR(p_max_value,'.');

Line 8152: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') FROM DUAL';

8148:
8149: IF (INSTR(p_min_value,'$SYSDATE$') > 0 ) THEN
8150: l_formated_string := TRIM(REPLACE(p_min_value, '$'));
8151: l_dynamic_sql := 'SELECT TO_CHAR('||l_formated_string||', '''||
8152: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') FROM DUAL';
8153: EXECUTE IMMEDIATE l_dynamic_sql INTO l_formated_string;
8154: l_min_date := TO_DATE(l_formated_string,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
8155: ELSE
8156: l_index_min := INSTR(p_min_value,'.');

Line 8556: l_additional_class_Code_query := ' SELECT -2910 FROM DUAL ';

8552: END LOOP;
8553: END IF; -- l_has_data_level_id
8554:
8555: IF (p_additional_class_Code_query IS NULL) THEN
8556: l_additional_class_Code_query := ' SELECT -2910 FROM DUAL ';
8557: ELSE
8558: l_additional_class_Code_query := p_additional_class_Code_query;
8559: END IF;
8560: code_debug(l_api_name ||' phase 2 ');