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

1767: THEN
1768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1769: END IF;
1770:
1771: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;
1772: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;
1773: G_USER_NAME := FND_GLOBAL.USER_NAME;
1774:
1775: --ER 9489112, to get data_level_id for item revision level

Line 1772: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;

1768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1769: END IF;
1770:
1771: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;
1772: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;
1773: G_USER_NAME := FND_GLOBAL.USER_NAME;
1774:
1775: --ER 9489112, to get data_level_id for item revision level
1776: --and get 'Add All Imported Items to Change Order' option when change order option enabled

Line 1773: G_USER_NAME := FND_GLOBAL.USER_NAME;

1769: END IF;
1770:
1771: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;
1772: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;
1773: G_USER_NAME := FND_GLOBAL.USER_NAME;
1774:
1775: --ER 9489112, to get data_level_id for item revision level
1776: --and get 'Add All Imported Items to Change Order' option when change order option enabled
1777: l_add_all_to_cm := EGO_IMPORT_PVT.getAddAllToChangeFlag(p_batch_id => p_data_set_id);

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 5214: FND_GLOBAL.USER_ID,

5210: NULL),
5211: '''|| EGO_USER_ATTRS_DATA_PVT.G_CREATE_MODE||''',
5212: '|| l_concat_pk_cols_sel ||'
5213: ATTR_GROUP_ID,
5214: FND_GLOBAL.USER_ID,
5215: SYSDATE,
5216: FND_GLOBAL.USER_ID,
5217: SYSDATE' || l_extra_column_val || '
5218: FROM (SELECT /*+ NO_MERGE index(A,EGO_ITM_USR_ATTR_INTRFC_N1) */

Line 5216: FND_GLOBAL.USER_ID,

5212: '|| l_concat_pk_cols_sel ||'
5213: ATTR_GROUP_ID,
5214: FND_GLOBAL.USER_ID,
5215: SYSDATE,
5216: FND_GLOBAL.USER_ID,
5217: SYSDATE' || l_extra_column_val || '
5218: FROM (SELECT /*+ NO_MERGE index(A,EGO_ITM_USR_ATTR_INTRFC_N1) */
5219: MAX(TRANSACTION_ID) TRANSACTION_ID,
5220: DATA_SET_ID,

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

10484: --Bug No:5386049
10485: --Getting the currnet userid and loginid
10486: --if not initialised.so that they are not inserted as null
10487: IF (G_CURRENT_USER_ID IS NULL ) THEN
10488: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;
10489: END IF;
10490: IF (G_CURRENT_LOGIN_ID IS NULL ) THEN
10491: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;
10492: END IF;

Line 10491: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;

10487: IF (G_CURRENT_USER_ID IS NULL ) THEN
10488: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;
10489: END IF;
10490: IF (G_CURRENT_LOGIN_ID IS NULL ) THEN
10491: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;
10492: END IF;
10493:
10494: l_dynamic_sql := ' INSERT INTO '||p_interface_table_name||
10495: ' ( '||l_col_to_insert_list ||' ) '||

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

10497: l_object_id := EGO_USER_ATTRS_DATA_PVT.Get_Object_Id_From_Name(p_object_name);
10498:
10499: code_debug(l_api_name ||' Final SQL ');
10500: code_debug(l_api_name ||l_dynamic_sql);
10501: code_debug(l_api_name ||'params 1: '||p_data_Set_id||' 2: '||FND_GLOBAL.CONC_REQUEST_ID||
10502: ' 3: '||l_max_row_id||' 4: '||G_CURRENT_USER_ID||
10503: ' 5: '||G_CURRENT_USER_ID||' 6: '||G_CURRENT_LOGIN_ID||
10504: ' 7: '||p_attr_group_type||' 8: '||p_application_id||
10505: ' 9: '||l_object_id||' 10: '||p_data_set_id||

Line 10513: FND_GLOBAL.CONC_REQUEST_ID,

10509: /* Begin Bug 13729672*/
10510: IF p_datalevel_id IS NULL THEN
10511: EXECUTE IMMEDIATE l_dynamic_sql
10512: USING p_data_Set_id,
10513: FND_GLOBAL.CONC_REQUEST_ID,
10514: l_max_row_id,
10515: G_CURRENT_USER_ID,
10516: G_CURRENT_USER_ID,
10517: G_CURRENT_LOGIN_ID,

Line 10527: FND_GLOBAL.CONC_REQUEST_ID,

10523: p_attr_group_type;
10524: ELSE
10525: EXECUTE IMMEDIATE l_dynamic_sql
10526: USING p_data_Set_id,
10527: FND_GLOBAL.CONC_REQUEST_ID,
10528: l_max_row_id,
10529: G_CURRENT_USER_ID,
10530: G_CURRENT_USER_ID,
10531: G_CURRENT_LOGIN_ID,