DBA Data[Home] [Help]

APPS.ZPB_DVAC_WF dependencies on FND_GLOBAL

Line 96: CREATED_BY = fnd_global.USER_ID,

92:
93: -- bug 5842494: replaced with l_instance_ac_id
94: update ZPB_MEASURE_SCOPE
95: set INSTANCE_AC_ID = l_instance_ac_id,
96: CREATED_BY = fnd_global.USER_ID,
97: CREATION_DATE = SYSDATE,
98: LAST_UPDATED_BY = fnd_global.USER_ID,
99: LAST_UPDATE_DATE = SYSDATE,
100: LAST_UPDATE_LOGIN = fnd_global.USER_ID

Line 98: LAST_UPDATED_BY = fnd_global.USER_ID,

94: update ZPB_MEASURE_SCOPE
95: set INSTANCE_AC_ID = l_instance_ac_id,
96: CREATED_BY = fnd_global.USER_ID,
97: CREATION_DATE = SYSDATE,
98: LAST_UPDATED_BY = fnd_global.USER_ID,
99: LAST_UPDATE_DATE = SYSDATE,
100: LAST_UPDATE_LOGIN = fnd_global.USER_ID
101: where INSTANCE_AC_ID = BP_ID;
102:

Line 100: LAST_UPDATE_LOGIN = fnd_global.USER_ID

96: CREATED_BY = fnd_global.USER_ID,
97: CREATION_DATE = SYSDATE,
98: LAST_UPDATED_BY = fnd_global.USER_ID,
99: LAST_UPDATE_DATE = SYSDATE,
100: LAST_UPDATE_LOGIN = fnd_global.USER_ID
101: where INSTANCE_AC_ID = BP_ID;
102:
103: -- delete current list of exempt users for instanceId
104: -- bug 5842494: replaced with l_instance_ac_id

Line 117: fnd_global.USER_ID, SYSDATE, fnd_global.USER_ID,

113: (user_id, exemption_id, business_process_entity_id,
114: business_process_entity_type, created_by, creation_date,
115: last_updated_by, last_update_date, last_update_login)
116: values(each.user_id, each.exemption_id, l_instance_ac_id, 'I',
117: fnd_global.USER_ID, SYSDATE, fnd_global.USER_ID,
118: SYSDATE, fnd_global.LOGIN_ID);
119:
120: end loop;
121:

Line 118: SYSDATE, fnd_global.LOGIN_ID);

114: business_process_entity_type, created_by, creation_date,
115: last_updated_by, last_update_date, last_update_login)
116: values(each.user_id, each.exemption_id, l_instance_ac_id, 'I',
117: fnd_global.USER_ID, SYSDATE, fnd_global.USER_ID,
118: SYSDATE, fnd_global.LOGIN_ID);
119:
120: end loop;
121:
122: ZPB_AW.INITIALIZE_FOR_AC(1.0, FND_API.G_FALSE, x_validation_level, x_return_status, x_msg_count, x_msg_data, BP_ID, FND_API.G_TRUE, FND_API.G_FALSE);