APPS.FND_RESUB_PRIVATE dependencies on DBMS_SQL

Line 85: cur_dyn := dbms_sql.open_cursor;

81: begin
82:
83: begin
84:
85: cur_dyn := dbms_sql.open_cursor;
86: exception
87: when others then
88: P_errnum := -1;
89: P_errbuf := 'dbms_sql.open_cursor failed';

Line 89: P_errbuf := 'dbms_sql.open_cursor failed';

85: cur_dyn := dbms_sql.open_cursor;
86: exception
87: when others then
88: P_errnum := -1;
89: P_errbuf := 'dbms_sql.open_cursor failed';
90: return;
91: end;
92:
93: begin

Line 95: dbms_sql.parse(cur_dyn, 'begin ' || P_inc_proc || '; end;',dbms_sql.V7);

91: end;
92:
93: begin
94: /* choosing V7 as language flag as less likely to cause problems */
95: dbms_sql.parse(cur_dyn, 'begin ' || P_inc_proc || '; end;',dbms_sql.V7);
96: exception
97: when others then
98: P_errnum := -1;
99: P_errbuf := 'dbms_sql.parse failed';

Line 99: P_errbuf := 'dbms_sql.parse failed';

95: dbms_sql.parse(cur_dyn, 'begin ' || P_inc_proc || '; end;',dbms_sql.V7);
96: exception
97: when others then
98: P_errnum := -1;
99: P_errbuf := 'dbms_sql.parse failed';
100: return;
101: end;
102:
103: begin

Line 105: row_dyn := dbms_sql.execute(cur_dyn);

101: end;
102:
103: begin
104: /* choosing V7 as language flag as less likely to cause problems */
105: row_dyn := dbms_sql.execute(cur_dyn);
106: exception
107: when others then
108: P_errnum := -1;
109: P_errbuf := 'dbms_sql.execute failed';

Line 109: P_errbuf := 'dbms_sql.execute failed';

105: row_dyn := dbms_sql.execute(cur_dyn);
106: exception
107: when others then
108: P_errnum := -1;
109: P_errbuf := 'dbms_sql.execute failed';
110: return;
111: end;
112:
113: begin

Line 115: dbms_sql.close_cursor(cur_dyn);

111: end;
112:
113: begin
114: /* choosing V7 as language flag as less likely to cause problems */
115: dbms_sql.close_cursor(cur_dyn);
116: exception
117: when others then
118: P_errnum := -1;
119: P_errbuf := 'dbms_sql.close_cursor failed';

Line 119: P_errbuf := 'dbms_sql.close_cursor failed';

115: dbms_sql.close_cursor(cur_dyn);
116: exception
117: when others then
118: P_errnum := -1;
119: P_errbuf := 'dbms_sql.close_cursor failed';
120: return;
121: end;
122:
123: end;