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.ZPB_PERSONAL_AW dependencies on FND_GLOBAL

Line 129: FND_GLOBAL.USER_ID,

125: 'N',
126: p_user,
127: 'ZPB'||p_user||'A'||p_business_area_id,
128: sysdate,
129: FND_GLOBAL.USER_ID,
130: sysdate,
131: FND_GLOBAL.USER_ID);
132: end if;
133: end if;

Line 131: FND_GLOBAL.USER_ID);

127: 'ZPB'||p_user||'A'||p_business_area_id,
128: sysdate,
129: FND_GLOBAL.USER_ID,
130: sysdate,
131: FND_GLOBAL.USER_ID);
132: end if;
133: end if;
134:
135: if (l_valid) then

Line 142: FND_GLOBAL.APPS_INITIALIZE (p_user, l_resp, 210);

138: into l_resp
139: from FND_RESPONSIBILITY
140: where RESPONSIBILITY_KEY = 'ZPB_MANAGER_RESP';
141:
142: FND_GLOBAL.APPS_INITIALIZE (p_user, l_resp, 210);
143:
144: zpb_aw.initialize (p_api_version => 1.0,
145: x_return_status => l_retStat,
146: x_msg_count => l_msgCnt,

Line 239: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

235: update ZPB_ACCOUNT_STATES
236: set READ_SCOPE = 1, WRITE_SCOPE = 1, OWNERSHIP = 1,
237: metadata_scope = 1,
238: LAST_UPDATE_DATE = sysdate,
239: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
240: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
241: LAST_LOGIN_DATE = null
242: where USER_ID = p_user
243: and BUSINESS_AREA_ID = p_business_area_id;

Line 240: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

236: set READ_SCOPE = 1, WRITE_SCOPE = 1, OWNERSHIP = 1,
237: metadata_scope = 1,
238: LAST_UPDATE_DATE = sysdate,
239: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
240: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
241: LAST_LOGIN_DATE = null
242: where USER_ID = p_user
243: and BUSINESS_AREA_ID = p_business_area_id;
244:

Line 317: FND_GLOBAL.APPS_INITIALIZE (p_user, l_resp, 210);

313: into l_resp
314: from FND_RESPONSIBILITY
315: where RESPONSIBILITY_KEY = 'ZPB_MANAGER_RESP';
316:
317: FND_GLOBAL.APPS_INITIALIZE (p_user, l_resp, 210);
318: */
319:
320: zpb_aw.initialize (p_api_version => 1.0,
321: x_return_status => l_retStat,

Line 402: and RESP_ID = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID)

398: nvl(OWNERSHIP, 0) +
399: nvl(METADATA_SCOPE, 0) needs_update
400: from ZPB_ACCOUNT_STATES
401: where USER_ID = p_user
402: and RESP_ID = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID)
403: and business_area_id = sys_context('ZPB_CONTEXT', 'business_area_id');
404:
405: l_rdAcc NUMBER;
406: l_wrtAcc NUMBER;

Line 455: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

451: --
452: update ZPB_DC_OBJECTS
453: set CREATE_SOLVE_PROGRAM_FLAG = 'Y',
454: LAST_UPDATE_DATE = sysdate,
455: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
456: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
457: where BUSINESS_AREA_ID = sys_context('ZPB_CONTEXT', 'business_area_id')
458: and OBJECT_USER_ID = p_user
459: and STATUS <> 'SUBMITTED_TO_SHARED';

Line 456: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

452: update ZPB_DC_OBJECTS
453: set CREATE_SOLVE_PROGRAM_FLAG = 'Y',
454: LAST_UPDATE_DATE = sysdate,
455: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
456: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
457: where BUSINESS_AREA_ID = sys_context('ZPB_CONTEXT', 'business_area_id')
458: and OBJECT_USER_ID = p_user
459: and STATUS <> 'SUBMITTED_TO_SHARED';
460: end if;

Line 467: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

463: -- reset metadata refresh state table
464: update ZPB_ACCOUNT_STATES
465: set METADATA_SCOPE = 0, READ_SCOPE = 0, WRITE_SCOPE = 0, OWNERSHIP = 0,
466: LAST_UPDATE_DATE = sysdate,
467: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
468: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
469: where USER_ID = p_user
470: and BUSINESS_AREA_ID = sys_context('ZPB_CONTEXT', 'business_area_id')
471: and nvl(READ_SCOPE, -1) <> G_LOCK_OUT

Line 468: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

464: update ZPB_ACCOUNT_STATES
465: set METADATA_SCOPE = 0, READ_SCOPE = 0, WRITE_SCOPE = 0, OWNERSHIP = 0,
466: LAST_UPDATE_DATE = sysdate,
467: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
468: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
469: where USER_ID = p_user
470: and BUSINESS_AREA_ID = sys_context('ZPB_CONTEXT', 'business_area_id')
471: and nvl(READ_SCOPE, -1) <> G_LOCK_OUT
472: and nvl(WRITE_SCOPE, -1) <> G_LOCK_OUT

Line 718: FND_GLOBAL.RESP_ID||''' '''||

714: zpb_log.write('zpb_personal_aw.measures_shared_update.begin',
715: 'Creating structures for shared measures');
716:
717: l_value := zpb_aw.interp ('call PA.MERGE.INST ('''||p_user||''' '''||
718: FND_GLOBAL.RESP_ID||''' '''||
719: g_personalAW||''' '''||g_sharedAW||''')');
720: if (l_value <> 'S') then
721: ZPB_ERROR_HANDLER.MERGE_STATUS(x_return_status,
722: FND_API.G_RET_STS_UNEXP_ERROR);

Line 1022: FND_GLOBAL.RESP_ID);

1018: from FND_RESPONSIBILITY
1019: where RESPONSIBILITY_KEY = 'ZPB_MANAGER_RESP';
1020:
1021: l_resp := nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')),
1022: FND_GLOBAL.RESP_ID);
1023: --
1024: -- Temp workaround of USER_ID being -1 in OLAP connection:
1025: --
1026: if (FND_GLOBAL.USER_ID = -1) then

Line 1026: if (FND_GLOBAL.USER_ID = -1) then

1022: FND_GLOBAL.RESP_ID);
1023: --
1024: -- Temp workaround of USER_ID being -1 in OLAP connection:
1025: --
1026: if (FND_GLOBAL.USER_ID = -1) then
1027: select APPLICATION_ID
1028: into l_app
1029: from FND_APPLICATION
1030: where APPLICATION_SHORT_NAME = 'ZPB';

Line 1032: FND_GLOBAL.APPS_INITIALIZE(to_number(p_user), l_resp, l_app);

1028: into l_app
1029: from FND_APPLICATION
1030: where APPLICATION_SHORT_NAME = 'ZPB';
1031:
1032: FND_GLOBAL.APPS_INITIALIZE(to_number(p_user), l_resp, l_app);
1033: end if;
1034:
1035: get_aws(p_user);
1036:

Line 1498: l_id_to_set_to := FND_GLOBAL.USER_ID;

1494: begin
1495:
1496: l_id_to_set_to := p_shadow_id;
1497: if l_id_to_set_to is null then
1498: l_id_to_set_to := FND_GLOBAL.USER_ID;
1499: end if;
1500:
1501:
1502: update ZPB_USERS

Line 1504: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1500:
1501:
1502: update ZPB_USERS
1503: set SHADOW_ID = l_id_to_set_to,
1504: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1505: LAST_UPDATE_DATE = sysdate
1506: where USER_ID = FND_GLOBAL.USER_ID
1507: and BUSINESS_AREA_ID = p_business_area_id;
1508: end UPDATE_SHADOW;

Line 1506: where USER_ID = FND_GLOBAL.USER_ID

1502: update ZPB_USERS
1503: set SHADOW_ID = l_id_to_set_to,
1504: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1505: LAST_UPDATE_DATE = sysdate
1506: where USER_ID = FND_GLOBAL.USER_ID
1507: and BUSINESS_AREA_ID = p_business_area_id;
1508: end UPDATE_SHADOW;
1509:
1510: end ZPB_PERSONAL_AW;