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 797: FROM DUAL;

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

Line 1811: FROM DUAL;

1807: G_ENTITY_ID := p_entity_id;
1808: -- entity code will take precedence over entity_id
1809: SELECT NVL(p_entity_code, DECODE(G_ENTITY_ID, NULL, G_APPLICATION_CONTEXT||'_EXTFWK_USER_ATTRS',NULL))
1810: INTO G_ENTITY_CODE
1811: FROM DUAL;
1812:
1813: -- Initialize error handler
1814: IF FND_API.To_Boolean(p_init_error_handler) THEN
1815: ERROR_HANDLER.Initialize;

Line 2879: FROM DUAL

2875:
2876: /* Bug 13414358 - Start */
2877: ' UPDATE '||p_interface_table_name||' UAI2
2878: SET UAI2.TRANSACTION_TYPE = Nvl(( SELECT '''||EGO_USER_ATTRS_DATA_PVT.G_UPDATE_MODE||'''
2879: FROM DUAL
2880: WHERE EXISTS '||l_ext_table_select1||
2881: '), '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''')
2882: WHERE UAI2.DATA_SET_ID = :data_set_id
2883: AND UAI2.ATTR_GROUP_TYPE = :attr_group_type

Line 3326: 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 '

3322: -----------------------------------------------------
3323: -- Validating, replacing the NULL characters here.
3324: -----------------------------------------------------
3325:
3326: 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 '
3327: INTO l_null_date_time_value,l_null_date_value;
3328:
3329: l_dynamic_sql := 'UPDATE ';
3330: IF (l_attr_metadata_rec(l_var).DATA_TYPE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN

Line 4401: 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

4397: ------------------------------------------------------
4398: -- In case the where clause has new line or tabs --
4399: -- we need to remove it BugFix:4101091 --
4400: ------------------------------------------------------
4401: 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
4402: 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
4403:
4404: 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
4405: l_tvs_where_clause := SUBSTR(l_tvs_where_clause, 1 , INSTR(UPPER(l_tvs_where_clause),' ORDER '));

Line 4402: 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

4398: -- In case the where clause has new line or tabs --
4399: -- we need to remove it BugFix:4101091 --
4400: ------------------------------------------------------
4401: 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
4402: 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
4403:
4404: 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
4405: l_tvs_where_clause := SUBSTR(l_tvs_where_clause, 1 , INSTR(UPPER(l_tvs_where_clause),' ORDER '));
4406: END IF;

Line 4543: SELECT REPLACE(l_tvs_where_clause_clob,':$OBJECT$','UAI1') INTO l_tvs_where_clause_clob FROM DUAL;

4539: END LOOP;
4540:
4541: WHILE (DBMS_LOB.INSTR(l_tvs_where_clause_clob, ':$OBJECT$') > 0)
4542: LOOP
4543: SELECT REPLACE(l_tvs_where_clause_clob,':$OBJECT$','UAI1') INTO l_tvs_where_clause_clob FROM DUAL;
4544: END LOOP;
4545:
4546: -- l_tvs_where_clause := l_tvs_where_clause_clob; -- Bug 10151142 : Commented
4547: --end of bug9846845

Line 5604: 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

5600: ------------------------------------------------------
5601: -- In case the where clause has new line or tabs --
5602: -- we need to remove it BugFix:4101091 --
5603: ------------------------------------------------------
5604: 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
5605: 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
5606:
5607: 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
5608: l_tvs_where_clause := SUBSTR(l_tvs_where_clause, 1 , INSTR(UPPER(l_tvs_where_clause),' ORDER '));

Line 5605: 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

5601: -- In case the where clause has new line or tabs --
5602: -- we need to remove it BugFix:4101091 --
5603: ------------------------------------------------------
5604: 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
5605: 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
5606:
5607: 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
5608: l_tvs_where_clause := SUBSTR(l_tvs_where_clause, 1 , INSTR(UPPER(l_tvs_where_clause),' ORDER '));
5609: END IF;

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

5729:
5730: END LOOP;
5731: WHILE (INSTR(l_tvs_where_clause, ':$OBJECT$') > 0)
5732: LOOP
5733: SELECT REPLACE(l_tvs_where_clause,':$OBJECT$','UAI1') INTO l_tvs_where_clause FROM DUAL;
5734: END LOOP;
5735: /*
5736: THERE COULD BE A POSSIBILITY THAT THE TVS QUERY RETURNS MORE THAN ONE ROW
5737: IN THIS CASE WE JUST TAKE THE FIRST ROW : ( i.e. WHERE ROWNUM = 1)

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

7345: --i.e. l_rtcq_to_ext_whr_uks_idnt_chk.
7346: l_rtcq_to_ext_where_uks := l_rtcq_to_ext_where_uks||
7347: ' AND NVL(RTCQ.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||','||wierd_constant||')'||
7348: '= DECODE (RTCQ.TRANSACTION_TYPE, '''||EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''' , '||
7349: 'NVL((SELECT NVL(RTCQ.'||l_attr_metadata_table_sr(d).DATABASE_COLUMN||','||wierd_constant||') FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM '||
7350: l_ext_tl_table_name||' WHERE EXTENSION_ID = EXT.EXTENSION_ID AND ROWNUM = 1 )), '||wierd_constant_2||' ) '||
7351: ',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||' ) '||
7352: ')';
7353: l_rtcq_to_ext_whr_uks_idnt_chk := l_rtcq_to_ext_whr_uks_idnt_chk||

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

9732: l_error_code := G_PS_INVALID_DATE_DATA ;
9733: IF (INSTR(p_value_to_convert,'$SYSDATE$') > 0 ) THEN
9734: l_formated_string := TRIM(REPLACE(p_value_to_convert, '$'));
9735: l_dynamic_sql := 'SELECT TO_CHAR('||l_formated_string||', '''||
9736: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') FROM DUAL';
9737: EXECUTE IMMEDIATE l_dynamic_sql INTO l_formated_string;
9738: l_date_value := TO_DATE(l_formated_string,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
9739: ELSE
9740: l_date_value := TO_DATE(p_value_to_convert, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

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

9744: l_error_code := G_PS_INVALID_DATE_TIME_DATA ;
9745: IF (INSTR(p_value_to_convert,'$SYSDATE$') > 0 ) THEN
9746: l_formated_string := TRIM(REPLACE(p_value_to_convert, '$'));
9747: l_dynamic_sql := 'SELECT TO_CHAR('||l_formated_string||', '''||
9748: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') FROM DUAL';
9749: EXECUTE IMMEDIATE l_dynamic_sql INTO l_formated_string;
9750: l_date_value := TO_DATE(l_formated_string,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
9751: ELSE
9752: l_date_value := TO_DATE(p_value_to_convert,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

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

9779:
9780: IF (INSTR(UPPER(p_date),'$SYSDATE$') > 0 ) THEN
9781: l_formated_string := TRIM(REPLACE(p_date, '$'));
9782: l_dynamic_sql := 'SELECT TO_CHAR('||l_formated_string||', '''||
9783: 'YYYY-MM-DD HH24:MI:SS'||''') FROM DUAL';
9784: EXECUTE IMMEDIATE l_dynamic_sql INTO l_formated_string;
9785: l_date := TO_DATE(l_formated_string,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
9786: RETURN l_date;
9787: ELSE

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

9832:
9833: IF (INSTR(p_value_to_check,'$SYSDATE$') > 0 ) THEN
9834: l_formated_string := TRIM(REPLACE(p_value_to_check, '$'));
9835: l_dynamic_sql := 'SELECT TO_CHAR('||l_formated_string||', '''||
9836: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') FROM DUAL';--'SYYYY-MM-DD HH24:MI:SS'
9837: EXECUTE IMMEDIATE l_dynamic_sql INTO l_formated_string;
9838: l_date_value := TO_DATE(l_formated_string,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);--'SYYYY-MM-DD HH24:MI:SS'
9839: ELSE
9840: l_date_value := TO_DATE(p_value_to_check,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

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

9842:
9843: IF (INSTR(p_max_value,'$SYSDATE$') > 0 ) THEN
9844: l_formated_string := TRIM(REPLACE(p_max_value, '$'));
9845: l_dynamic_sql := 'SELECT TO_CHAR('||l_formated_string||', '''||
9846: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') FROM DUAL';--'SYYYY-MM-DD HH24:MI:SS'
9847: EXECUTE IMMEDIATE l_dynamic_sql INTO l_formated_string;
9848: l_max_date := TO_DATE(l_formated_string,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);--'YYYY-MM-DD HH24:MI:SS'
9849: ELSE
9850: l_index_max := INSTR(p_max_value,'.');

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

9858:
9859: IF (INSTR(p_min_value,'$SYSDATE$') > 0 ) THEN
9860: l_formated_string := TRIM(REPLACE(p_min_value, '$'));
9861: l_dynamic_sql := 'SELECT TO_CHAR('||l_formated_string||', '''||
9862: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') FROM DUAL';
9863: EXECUTE IMMEDIATE l_dynamic_sql INTO l_formated_string;
9864: l_min_date := TO_DATE(l_formated_string,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
9865: ELSE
9866: l_index_min := INSTR(p_min_value,'.');

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

10289: END LOOP;
10290: END IF; -- l_has_data_level_id
10291:
10292: IF (p_additional_class_Code_query IS NULL) THEN
10293: l_additional_class_Code_query := ' SELECT -2910 FROM DUAL ';
10294: ELSE
10295: l_additional_class_Code_query := p_additional_class_Code_query;
10296: END IF;
10297: code_debug(l_api_name ||' phase 2 ');