DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_DATA_PVT dependencies on FND_GLOBAL

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

3452: ------------------------------------------------------
3453: -- In case the where clause has new line or tabs --
3454: -- we need to remove it BugFix:4101091 --
3455: ------------------------------------------------------
3456: SELECT REPLACE(l_vs_where_clause,FND_GLOBAL.LOCAL_CHR(10),FND_GLOBAL.LOCAL_CHR(32)) INTO l_vs_where_clause FROM dual; --replacing new line character
3457: SELECT REPLACE(l_vs_where_clause,FND_GLOBAL.LOCAL_CHR(13),FND_GLOBAL.LOCAL_CHR(32)) INTO l_vs_where_clause FROM dual; --removing carriage return
3458: -------------------------------------------------------------------------
3459: -- well if there is still some special character left we cant help it. --
3460: -------------------------------------------------------------------------

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

3453: -- In case the where clause has new line or tabs --
3454: -- we need to remove it BugFix:4101091 --
3455: ------------------------------------------------------
3456: SELECT REPLACE(l_vs_where_clause,FND_GLOBAL.LOCAL_CHR(10),FND_GLOBAL.LOCAL_CHR(32)) INTO l_vs_where_clause FROM dual; --replacing new line character
3457: SELECT REPLACE(l_vs_where_clause,FND_GLOBAL.LOCAL_CHR(13),FND_GLOBAL.LOCAL_CHR(32)) INTO l_vs_where_clause FROM dual; --removing carriage return
3458: -------------------------------------------------------------------------
3459: -- well if there is still some special character left we cant help it. --
3460: -------------------------------------------------------------------------
3461:

Line 6864: l_token_table(1).TOKEN_VALUE := FND_GLOBAL.USER_NAME;

6860: -----------------------------------------------------------------------
6861: IF (l_error_message_name IS NOT NULL) THEN
6862:
6863: l_token_table(1).TOKEN_NAME := 'USER_NAME';
6864: l_token_table(1).TOKEN_VALUE := FND_GLOBAL.USER_NAME;
6865: l_token_table(2).TOKEN_NAME := 'AG_NAME';
6866: l_token_table(2).TOKEN_VALUE := p_attr_group_metadata_obj.ATTR_GROUP_DISP_NAME;
6867:
6868: ERROR_HANDLER.Add_Error_Message(

Line 7340: l_current_user_id NUMBER := FND_GLOBAL.User_Id;

7336: l_extra_col_names VARCHAR2(10000);
7337: l_extra_col_values VARCHAR2(10000);
7338: l_index NUMBER;
7339:
7340: l_current_user_id NUMBER := FND_GLOBAL.User_Id;
7341: l_current_login_id NUMBER := FND_GLOBAL.Login_Id;
7342: l_data_level_id NUMBER;
7343: l_dl_col_mdata_array EGO_COL_METADATA_ARRAY;
7344:

Line 7341: l_current_login_id NUMBER := FND_GLOBAL.Login_Id;

7337: l_extra_col_values VARCHAR2(10000);
7338: l_index NUMBER;
7339:
7340: l_current_user_id NUMBER := FND_GLOBAL.User_Id;
7341: l_current_login_id NUMBER := FND_GLOBAL.Login_Id;
7342: l_data_level_id NUMBER;
7343: l_dl_col_mdata_array EGO_COL_METADATA_ARRAY;
7344:
7345: l_column_exists VARCHAR2(1); -- Bug 10097738

Line 8238: l_current_user_id NUMBER := FND_GLOBAL.User_Id;

8234: --End 4105841
8235: ctr NUMBER;
8236: l_index NUMBER;
8237:
8238: l_current_user_id NUMBER := FND_GLOBAL.User_Id;
8239: l_current_login_id NUMBER := FND_GLOBAL.Login_Id;
8240: --Start Bug 5211171
8241: l_col_value VARCHAR2(1000);
8242: l_col_name VARCHAR2(1000);

Line 8239: l_current_login_id NUMBER := FND_GLOBAL.Login_Id;

8235: ctr NUMBER;
8236: l_index NUMBER;
8237:
8238: l_current_user_id NUMBER := FND_GLOBAL.User_Id;
8239: l_current_login_id NUMBER := FND_GLOBAL.Login_Id;
8240: --Start Bug 5211171
8241: l_col_value VARCHAR2(1000);
8242: l_col_name VARCHAR2(1000);
8243: l_col_values_index NUMBER;

Line 14338: l_current_user_id NUMBER := FND_GLOBAL.User_Id;

14334: l_dynamic_sql VARCHAR2(500);
14335: l_b_table_col_names_list VARCHAR2(3000);
14336: l_tl_table_col_names_list VARCHAR2(3000);
14337:
14338: l_current_user_id NUMBER := FND_GLOBAL.User_Id;
14339: l_current_login_id NUMBER := FND_GLOBAL.Login_Id;
14340: l_dummy INTEGER;
14341: l_pk_cursor INTEGER;
14342: l_pk_array dbms_sql.Varchar2_Table;

Line 14339: l_current_login_id NUMBER := FND_GLOBAL.Login_Id;

14335: l_b_table_col_names_list VARCHAR2(3000);
14336: l_tl_table_col_names_list VARCHAR2(3000);
14337:
14338: l_current_user_id NUMBER := FND_GLOBAL.User_Id;
14339: l_current_login_id NUMBER := FND_GLOBAL.Login_Id;
14340: l_dummy INTEGER;
14341: l_pk_cursor INTEGER;
14342: l_pk_array dbms_sql.Varchar2_Table;
14343: l_dt_array dbms_sql.Varchar2_Table;