APPS.ZPB_BUSAREA_VAL dependencies on FND_GLOBAL

Line 65: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

61: IF p_queryType = G_READ_RULE
62: THEN
63: UPDATE ZPB_ACCOUNT_STATES
64: SET READ_SCOPE = G_LOCK_OUT,
65: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
66: LAST_UPDATE_DATE = SYSDATE,
67: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
68: WHERE USER_ID = p_userId AND
69: BUSINESS_AREA_ID = p_baId;

Line 67: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID

63: UPDATE ZPB_ACCOUNT_STATES
64: SET READ_SCOPE = G_LOCK_OUT,
65: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
66: LAST_UPDATE_DATE = SYSDATE,
67: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
68: WHERE USER_ID = p_userId AND
69: BUSINESS_AREA_ID = p_baId;
70: ELSIF p_queryType = G_WRITE_RULE
71: THEN

Line 74: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

70: ELSIF p_queryType = G_WRITE_RULE
71: THEN
72: UPDATE ZPB_ACCOUNT_STATES
73: SET WRITE_SCOPE = G_LOCK_OUT,
74: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
75: LAST_UPDATE_DATE = SYSDATE,
76: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
77: WHERE USER_ID = p_userId AND
78: BUSINESS_AREA_ID = p_baId;

Line 76: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID

72: UPDATE ZPB_ACCOUNT_STATES
73: SET WRITE_SCOPE = G_LOCK_OUT,
74: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
75: LAST_UPDATE_DATE = SYSDATE,
76: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
77: WHERE USER_ID = p_userId AND
78: BUSINESS_AREA_ID = p_baId;
79: ELSIF p_queryType = G_OWNER_RULE
80: THEN

Line 83: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

79: ELSIF p_queryType = G_OWNER_RULE
80: THEN
81: UPDATE ZPB_ACCOUNT_STATES
82: SET OWNERSHIP = G_LOCK_OUT,
83: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
84: LAST_UPDATE_DATE = SYSDATE,
85: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
86: WHERE USER_ID = p_userId AND
87: BUSINESS_AREA_ID = p_baId;

Line 85: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID

81: UPDATE ZPB_ACCOUNT_STATES
82: SET OWNERSHIP = G_LOCK_OUT,
83: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
84: LAST_UPDATE_DATE = SYSDATE,
85: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
86: WHERE USER_ID = p_userId AND
87: BUSINESS_AREA_ID = p_baId;
88: END IF;
89:

Line 97: p_queryPath || fnd_global.newline()|| p_queryName,

93: VALUE,
94: STATUS_SQL_ID)
95: VALUES (p_baId,
96: p_queryErrorType,
97: p_queryPath || fnd_global.newline()|| p_queryName,
98: p_statusSqlId);
99:
100: COMMIT;
101:

Line 196: p_queryPath || fnd_global.newline()|| p_queryName,

192: VALUE,
193: ANALYSIS_CYCLE_ID)
194: VALUES (p_baId,
195: p_queryErrorType ,
196: p_queryPath || fnd_global.newline()|| p_queryName,
197: p_acID);
198:
199: IF (p_AcID IS NOT NULL) THEN
200: BEGIN

Line 626: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

622: 'OBJ_TYPE', 'ZPB_DEFAULT_HIERARCHY', 'Y');
623: update ZPB_BUSAREA_DIMENSIONS
624: set DEFAULT_HIERARCHY_ID = null,
625: LAST_UPDATE_DATE = sysdate,
626: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
627: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
628: where VERSION_ID = p_version_id
629: and LOGICAL_DIM_ID = each.LOGICAL_DIM_ID
630: and DIMENSION_ID = each.DIMENSION_ID;

Line 627: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

623: update ZPB_BUSAREA_DIMENSIONS
624: set DEFAULT_HIERARCHY_ID = null,
625: LAST_UPDATE_DATE = sysdate,
626: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
627: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
628: where VERSION_ID = p_version_id
629: and LOGICAL_DIM_ID = each.LOGICAL_DIM_ID
630: and DIMENSION_ID = each.DIMENSION_ID;
631: end loop;

Line 3078: l_codeAW := zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(FND_GLOBAL.USER_ID);

3074: end;
3075:
3076:
3077: BEGIN
3078: l_codeAW := zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(FND_GLOBAL.USER_ID);
3079: l_sharedAW := 'ZPB.ZPBDATA'||l_ba_id;
3080: ATTACH_AWS(l_codeAW, l_sharedAW);
3081:
3082: SELECT SHAR_TABLE_ID INTO l_tableID FROM zpb_dimensions