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 FND_GLOBAL

Line 49: G_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

45: G_ENTITY_CODE VARCHAR2(30);
46:
47: G_PK_COLS_TABLE PK_COL_TABLE;
48:
49: G_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
50:
51: G_FND_RET_STS_WARNING VARCHAR2(1):= 'W';
52:
53: -------------------------

Line 70: IF NVL(FND_GLOBAL.conc_request_id, -1) <> -1 THEN

66: -- END IF;
67: -- EGO_USER_ATTRS_DATA_PVT.Debug_Msg(msg , debug_level);
68:
69: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
70: IF NVL(FND_GLOBAL.conc_request_id, -1) <> -1 THEN
71:
72: FND_FILE.put_line(which => FND_FILE.LOG
73: ,buff => '[EGOVBUAB] '||msg);
74: END IF;

Line 1467: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;

1463: THEN
1464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1465: END IF;
1466:
1467: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;
1468: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;
1469: G_USER_NAME := FND_GLOBAL.USER_NAME;
1470:
1471: ---------------------------------

Line 1468: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;

1464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1465: END IF;
1466:
1467: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;
1468: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;
1469: G_USER_NAME := FND_GLOBAL.USER_NAME;
1470:
1471: ---------------------------------
1472: -- Error Handler Initialization --

Line 1469: G_USER_NAME := FND_GLOBAL.USER_NAME;

1465: END IF;
1466:
1467: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;
1468: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;
1469: G_USER_NAME := FND_GLOBAL.USER_NAME;
1470:
1471: ---------------------------------
1472: -- Error Handler Initialization --
1473: ---------------------------------

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 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 8751: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;

8747: --Bug No:5386049
8748: --Getting the currnet userid and loginid
8749: --if not initialised.so that they are not inserted as null
8750: IF (G_CURRENT_USER_ID IS NULL ) THEN
8751: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;
8752: END IF;
8753: IF (G_CURRENT_LOGIN_ID IS NULL ) THEN
8754: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;
8755: END IF;

Line 8754: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;

8750: IF (G_CURRENT_USER_ID IS NULL ) THEN
8751: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;
8752: END IF;
8753: IF (G_CURRENT_LOGIN_ID IS NULL ) THEN
8754: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;
8755: END IF;
8756:
8757: l_dynamic_sql := ' INSERT INTO '||p_interface_table_name||
8758: ' ( '||l_col_to_insert_list ||' ) '||

Line 8764: code_debug(l_api_name ||'params 1: '||p_data_Set_id||' 2: '||FND_GLOBAL.CONC_REQUEST_ID||

8760: l_object_id := EGO_USER_ATTRS_DATA_PVT.Get_Object_Id_From_Name(p_object_name);
8761:
8762: code_debug(l_api_name ||' Final SQL ');
8763: code_debug(l_api_name ||l_dynamic_sql);
8764: code_debug(l_api_name ||'params 1: '||p_data_Set_id||' 2: '||FND_GLOBAL.CONC_REQUEST_ID||
8765: ' 3: '||l_max_row_id||' 4: '||G_CURRENT_USER_ID||
8766: ' 5: '||G_CURRENT_USER_ID||' 6: '||G_CURRENT_LOGIN_ID||
8767: ' 7: '||p_attr_group_type||' 8: '||p_application_id||
8768: ' 9: '||l_object_id||' 10: '||p_data_set_id||

Line 8774: FND_GLOBAL.CONC_REQUEST_ID,

8770: );
8771:
8772: EXECUTE IMMEDIATE l_dynamic_sql
8773: USING p_data_Set_id,
8774: FND_GLOBAL.CONC_REQUEST_ID,
8775: l_max_row_id,
8776: G_CURRENT_USER_ID,
8777: G_CURRENT_USER_ID,
8778: G_CURRENT_LOGIN_ID,