APPS.ALR_DBTRIGGER dependencies on DBMS_SQL

Line 89: c := dbms_sql.open_cursor;

85: sqlstmt := 'insert into alr_dbtrigger_debug'||
86: '(type,creation_date,stmt) values('''||
87: DEBUG_SEQ||''',sysdate,'''||TXT||''')';
88:
89: c := dbms_sql.open_cursor;
90:
91: begin
92: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
93: rows_processed := dbms_sql.execute(c);

Line 92: dbms_sql.parse(c, sqlstmt, dbms_sql.native);

88:
89: c := dbms_sql.open_cursor;
90:
91: begin
92: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
93: rows_processed := dbms_sql.execute(c);
94: exception
95: when others then
96: NULL; -- do nothing

Line 93: rows_processed := dbms_sql.execute(c);

89: c := dbms_sql.open_cursor;
90:
91: begin
92: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
93: rows_processed := dbms_sql.execute(c);
94: exception
95: when others then
96: NULL; -- do nothing
97: end;

Line 99: dbms_sql.close_cursor(c);

95: when others then
96: NULL; -- do nothing
97: end;
98:
99: dbms_sql.close_cursor(c);
100: end if;
101:
102: end ALR_DEBUG;
103:

Line 110: c := dbms_sql.open_cursor;

106: procedure ALR_DEBUG_CLEAN is
107: c INTEGER;
108: rows_processed INTEGER;
109: begin
110: c := dbms_sql.open_cursor;
111:
112: begin
113: dbms_sql.parse(c, 'delete alr_dbtrigger_debug', dbms_sql.native);
114: rows_processed := dbms_sql.execute(c);

Line 113: dbms_sql.parse(c, 'delete alr_dbtrigger_debug', dbms_sql.native);

109: begin
110: c := dbms_sql.open_cursor;
111:
112: begin
113: dbms_sql.parse(c, 'delete alr_dbtrigger_debug', dbms_sql.native);
114: rows_processed := dbms_sql.execute(c);
115: exception
116: when others then
117: NULL; -- do nothing

Line 114: rows_processed := dbms_sql.execute(c);

110: c := dbms_sql.open_cursor;
111:
112: begin
113: dbms_sql.parse(c, 'delete alr_dbtrigger_debug', dbms_sql.native);
114: rows_processed := dbms_sql.execute(c);
115: exception
116: when others then
117: NULL; -- do nothing
118: end;

Line 120: dbms_sql.close_cursor(c);

116: when others then
117: NULL; -- do nothing
118: end;
119:
120: dbms_sql.close_cursor(c);
121:
122: end ALR_DEBUG_CLEAN;
123:
124: -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++