APPS.BIS_BIA_RSG_LOG_MGMNT dependencies on FND_GLOBAL

Line 303: update bis_obj_indexes set INDEX_SQL = l_ddl, LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.User_id, LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID where OBJECT_NAME=p_mv_log_name and OBJECT_TYPE='MVLOG' and INDEX_NAME=l_index_name;

299: exit when c_mv_log_index%NOTFOUND;
300:
301: if l_ddl is not null or l_ddl <> '' then
302: l_count := l_count+1;
303: update bis_obj_indexes set INDEX_SQL = l_ddl, LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.User_id, LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID where OBJECT_NAME=p_mv_log_name and OBJECT_TYPE='MVLOG' and INDEX_NAME=l_index_name;
304: IF SQL%NOTFOUND THEN
305: INSERT INTO bis_obj_indexes( OBJECT_NAME, OBJECT_TYPE, INDEX_NAME, INDEX_SQL, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
306: values(p_mv_log_name, 'MVLOG', l_index_name, l_ddl, sysdate, FND_GLOBAL.User_id, sysdate, FND_GLOBAL.User_id, fnd_global.LOGIN_ID);
307: END IF;

Line 306: values(p_mv_log_name, 'MVLOG', l_index_name, l_ddl, sysdate, FND_GLOBAL.User_id, sysdate, FND_GLOBAL.User_id, fnd_global.LOGIN_ID);

302: l_count := l_count+1;
303: update bis_obj_indexes set INDEX_SQL = l_ddl, LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.User_id, LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID where OBJECT_NAME=p_mv_log_name and OBJECT_TYPE='MVLOG' and INDEX_NAME=l_index_name;
304: IF SQL%NOTFOUND THEN
305: INSERT INTO bis_obj_indexes( OBJECT_NAME, OBJECT_TYPE, INDEX_NAME, INDEX_SQL, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
306: values(p_mv_log_name, 'MVLOG', l_index_name, l_ddl, sysdate, FND_GLOBAL.User_id, sysdate, FND_GLOBAL.User_id, fnd_global.LOGIN_ID);
307: END IF;
308: COMMIT;
309: WRITELOG('Captured Index '|| l_index_name || ' on MVLog ' || form_triplet(p_mv_log_name, P_mv_log_schema, 'MVLog') );
310: end if;

Line 760: l_root_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;

756: WRITELOG( P_OBJ_NAME || 'is not implemented, No further action performed!');
757: return;
758: end if;
759:
760: l_root_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;
761: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.CONC_PRIORITY_REQUEST: ' || l_root_request_id);
762: open c_force_full(l_root_request_id);
763: LOOP
764: fetch c_force_full into l_rs_name, l_opt, l_tmp;

Line 761: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.CONC_PRIORITY_REQUEST: ' || l_root_request_id);

757: return;
758: end if;
759:
760: l_root_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;
761: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.CONC_PRIORITY_REQUEST: ' || l_root_request_id);
762: open c_force_full(l_root_request_id);
763: LOOP
764: fetch c_force_full into l_rs_name, l_opt, l_tmp;
765: exit when c_force_full%NOTFOUND;