APPS.ZPB_PERSONAL_AW dependencies on ZPB_ACCOUNT_STATES

Line 98: from ZPB_ACCOUNT_STATES

94:
95: begin
96: select count(*)
97: into l_msgCnt
98: from ZPB_ACCOUNT_STATES
99: where USER_ID = p_user
100: and BUSINESS_AREA_ID = p_business_area_id
101: and ACCOUNT_STATUS = 0;
102:

Line 235: update ZPB_ACCOUNT_STATES

231: --dbms_output.put_line ('done map create: '||to_char(sysdate,
232: --'HH:MI:SS'));
233:
234: -- set metadata refresh state table to force SECURITY_UPDATE
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,

Line 400: from ZPB_ACCOUNT_STATES

396: select nvl (READ_SCOPE, 0) +
397: nvl(WRITE_SCOPE, 0) +
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:

Line 464: update ZPB_ACCOUNT_STATES

460: end if;
461:
462: if x_return_status <> FND_API.G_RET_STS_UNEXP_ERROR and p_read_only = FND_API.G_FALSE then
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