APPS.AS_UTILITY_PVT dependencies on AS_CONC_REQUEST_MESSAGES

Line 34: ,indSql as_conc_request_messages.index_text%Type

30: ,pct_free dba_indexes.pct_free%Type
31: ,freelists dba_indexes.freelists%Type
32: ,int_ext number, next_ext number, min_ext number
33: ,max_ext number, pct number, degree number
34: ,indSql as_conc_request_messages.index_text%Type
35: ,processed boolean := false);
36:
37: FUNCTION get_degree_parallelism RETURN NUMBER IS
38: BEGIN

Line 831: UPDATE as_conc_request_messages

827: ' FREELISTS '||p_indRec.freelists||') PARALLEL '||get_degree_parallelism||
828: ' TABLESPACE '||p_indRec.ts;
829: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AS_UTILITY_PVT Processing index: '||p_indRec.index_name );
830:
831: UPDATE as_conc_request_messages
832: SET index_text = p_indRec.indSql
833: WHERE index_name = p_indRec.index_name
834: AND index_owner = p_indRec.index_owner;
835:

Line 837: INSERT INTO as_conc_request_messages

833: WHERE index_name = p_indRec.index_name
834: AND index_owner = p_indRec.index_owner;
835:
836: IF (sql%rowcount <= 0) THEN
837: INSERT INTO as_conc_request_messages
838: (conc_request_message_id, creation_date, created_by, table_name, table_owner, index_name, index_owner, index_text)
839: VALUES (AS_CONC_REQUEST_MESSAGES_S.nextval, sysdate, nvl(fnd_global.user_id,-1), p_indRec.tbl_name, p_indRec.tbl_owner, p_indRec.index_name,p_indRec.index_owner, p_indRec.indSql);
840: END IF;
841:

Line 839: VALUES (AS_CONC_REQUEST_MESSAGES_S.nextval, sysdate, nvl(fnd_global.user_id,-1), p_indRec.tbl_name, p_indRec.tbl_owner, p_indRec.index_name,p_indRec.index_owner, p_indRec.indSql);

835:
836: IF (sql%rowcount <= 0) THEN
837: INSERT INTO as_conc_request_messages
838: (conc_request_message_id, creation_date, created_by, table_name, table_owner, index_name, index_owner, index_text)
839: VALUES (AS_CONC_REQUEST_MESSAGES_S.nextval, sysdate, nvl(fnd_global.user_id,-1), p_indRec.tbl_name, p_indRec.tbl_owner, p_indRec.index_name,p_indRec.index_owner, p_indRec.indSql);
840: END IF;
841:
842: END static_sql;
843:

Line 945: FROM as_conc_request_messages o

941: p_table_owner VARCHAR2) IS
942:
943: CURSOR build_index (p_tbl_name varchar2, p_tbl_owner varchar2) IS
944: SELECT index_name indname, index_owner owner, index_text indSql
945: FROM as_conc_request_messages o
946: WHERE table_name = p_tbl_name
947: AND table_owner = p_tbl_owner
948: AND NOT EXISTS (SELECT 'e' FROM dba_indexes i
949: WHERE i.index_name = o.index_name

Line 954: FROM as_conc_request_messages o

950: AND i.owner = o.index_owner);
951:
952: CURSOR drop_index (p_tbl_name varchar2, p_tbl_owner varchar2) IS
953: SELECT index_name indname, index_owner owner, index_text indSql
954: FROM as_conc_request_messages o
955: WHERE table_name = p_tbl_name
956: AND table_owner = p_tbl_owner
957: AND EXISTS (SELECT 'e' FROM dba_indexes i
958: WHERE i.index_name = o.index_name

Line 976: DELETE FROM as_conc_request_messages where table_name = p_table_name and table_owner = p_table_owner;

972: EXECUTE IMMEDIATE 'ALTER INDEX '||I.owner||'.'||I.indname||' LOGGING NOPARALLEL';
973: END LOOP;
974: --Code commented for performance bug#5802537-- by lester
975: --dbms_stats.gather_table_stats(p_table_owner,p_table_name, estimate_percent=>25, degree=>get_degree_parallelism, granularity=>'GLOBAL', cascade=>TRUE);
976: DELETE FROM as_conc_request_messages where table_name = p_table_name and table_owner = p_table_owner;
977: END IF;
978: IF (p_mode = 'DROP') THEN
979: FOR I in drop_index (p_table_name, p_table_owner) LOOP
980: Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'execute_ind '||'Processing index:' ||I.indname||' with mode: '||p_mode);