eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTM_NOTES_VUHK dependencies on DBMS_SQL

Line 125: l_cursorid := DBMS_SQL.open_cursor;

121: l_enable_flag := JTM_PROFILE_UTL_PKG.Get_enable_flag_at_resp
122: (p_app_short_name => Csr1.PRODUCT_CODE);
123:
124: if (l_enable_flag = 'Y') then
125: l_cursorid := DBMS_SQL.open_cursor;
126: l_strBuffer :=
127: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
128: '(:1,:2,:3,:4,:5,:6,:7,:8); ' ||
129: ' exception ' ||

Line 133: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);

129: ' exception ' ||
130: ' when others then ' ||
131: ' null; ' ||
132: ' end; ';
133: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
134: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
135: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
136: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
137: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

Line 134: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);

130: ' when others then ' ||
131: ' null; ' ||
132: ' end; ';
133: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
134: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
135: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
136: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
137: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
138: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);

Line 135: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);

131: ' null; ' ||
132: ' end; ';
133: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
134: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
135: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
136: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
137: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
138: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
139: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);

Line 136: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);

132: ' end; ';
133: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
134: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
135: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
136: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
137: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
138: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
139: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
140: DBMS_SQL.bind_variable (l_cursorid, ':7', x_return_status);

Line 137: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

133: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
134: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
135: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
136: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
137: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
138: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
139: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
140: DBMS_SQL.bind_variable (l_cursorid, ':7', x_return_status);
141: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);

Line 138: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);

134: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
135: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
136: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
137: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
138: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
139: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
140: DBMS_SQL.bind_variable (l_cursorid, ':7', x_return_status);
141: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);
142: /*

Line 139: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);

135: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
136: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
137: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
138: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
139: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
140: DBMS_SQL.bind_variable (l_cursorid, ':7', x_return_status);
141: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);
142: /*
143: l_strBuffer :=

Line 140: DBMS_SQL.bind_variable (l_cursorid, ':7', x_return_status);

136: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
137: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
138: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
139: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
140: DBMS_SQL.bind_variable (l_cursorid, ':7', x_return_status);
141: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);
142: /*
143: l_strBuffer :=
144: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||

Line 141: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);

137: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
138: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
139: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
140: DBMS_SQL.bind_variable (l_cursorid, ':7', x_return_status);
141: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);
142: /*
143: l_strBuffer :=
144: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
145: '(:1,:2,:3,:4,:5,:6,:7,:8' ||

Line 154: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);

150: ' exception ' ||
151: ' when others then ' ||
152: ' null; ' ||
153: ' end; ';
154: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
155: DBMS_SQL.bind_variable (l_cursorid, ':1', p_parent_note_id);
156: DBMS_SQL.bind_variable (l_cursorid, ':2', p_api_version);
157: DBMS_SQL.bind_variable (l_cursorid, ':3', p_init_msg_list);
158: DBMS_SQL.bind_variable (l_cursorid, ':4', p_commit);

Line 155: DBMS_SQL.bind_variable (l_cursorid, ':1', p_parent_note_id);

151: ' when others then ' ||
152: ' null; ' ||
153: ' end; ';
154: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
155: DBMS_SQL.bind_variable (l_cursorid, ':1', p_parent_note_id);
156: DBMS_SQL.bind_variable (l_cursorid, ':2', p_api_version);
157: DBMS_SQL.bind_variable (l_cursorid, ':3', p_init_msg_list);
158: DBMS_SQL.bind_variable (l_cursorid, ':4', p_commit);
159: DBMS_SQL.bind_variable (l_cursorid, ':5', p_validation_level);

Line 156: DBMS_SQL.bind_variable (l_cursorid, ':2', p_api_version);

152: ' null; ' ||
153: ' end; ';
154: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
155: DBMS_SQL.bind_variable (l_cursorid, ':1', p_parent_note_id);
156: DBMS_SQL.bind_variable (l_cursorid, ':2', p_api_version);
157: DBMS_SQL.bind_variable (l_cursorid, ':3', p_init_msg_list);
158: DBMS_SQL.bind_variable (l_cursorid, ':4', p_commit);
159: DBMS_SQL.bind_variable (l_cursorid, ':5', p_validation_level);
160: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_count);

Line 157: DBMS_SQL.bind_variable (l_cursorid, ':3', p_init_msg_list);

153: ' end; ';
154: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
155: DBMS_SQL.bind_variable (l_cursorid, ':1', p_parent_note_id);
156: DBMS_SQL.bind_variable (l_cursorid, ':2', p_api_version);
157: DBMS_SQL.bind_variable (l_cursorid, ':3', p_init_msg_list);
158: DBMS_SQL.bind_variable (l_cursorid, ':4', p_commit);
159: DBMS_SQL.bind_variable (l_cursorid, ':5', p_validation_level);
160: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_count);
161: DBMS_SQL.bind_variable (l_cursorid, ':7', x_msg_data);

Line 158: DBMS_SQL.bind_variable (l_cursorid, ':4', p_commit);

154: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
155: DBMS_SQL.bind_variable (l_cursorid, ':1', p_parent_note_id);
156: DBMS_SQL.bind_variable (l_cursorid, ':2', p_api_version);
157: DBMS_SQL.bind_variable (l_cursorid, ':3', p_init_msg_list);
158: DBMS_SQL.bind_variable (l_cursorid, ':4', p_commit);
159: DBMS_SQL.bind_variable (l_cursorid, ':5', p_validation_level);
160: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_count);
161: DBMS_SQL.bind_variable (l_cursorid, ':7', x_msg_data);
162: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);

Line 159: DBMS_SQL.bind_variable (l_cursorid, ':5', p_validation_level);

155: DBMS_SQL.bind_variable (l_cursorid, ':1', p_parent_note_id);
156: DBMS_SQL.bind_variable (l_cursorid, ':2', p_api_version);
157: DBMS_SQL.bind_variable (l_cursorid, ':3', p_init_msg_list);
158: DBMS_SQL.bind_variable (l_cursorid, ':4', p_commit);
159: DBMS_SQL.bind_variable (l_cursorid, ':5', p_validation_level);
160: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_count);
161: DBMS_SQL.bind_variable (l_cursorid, ':7', x_msg_data);
162: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);
163: DBMS_SQL.bind_variable (l_cursorid, ':8', p_org_id);

Line 160: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_count);

156: DBMS_SQL.bind_variable (l_cursorid, ':2', p_api_version);
157: DBMS_SQL.bind_variable (l_cursorid, ':3', p_init_msg_list);
158: DBMS_SQL.bind_variable (l_cursorid, ':4', p_commit);
159: DBMS_SQL.bind_variable (l_cursorid, ':5', p_validation_level);
160: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_count);
161: DBMS_SQL.bind_variable (l_cursorid, ':7', x_msg_data);
162: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);
163: DBMS_SQL.bind_variable (l_cursorid, ':8', p_org_id);
164: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id);

Line 161: DBMS_SQL.bind_variable (l_cursorid, ':7', x_msg_data);

157: DBMS_SQL.bind_variable (l_cursorid, ':3', p_init_msg_list);
158: DBMS_SQL.bind_variable (l_cursorid, ':4', p_commit);
159: DBMS_SQL.bind_variable (l_cursorid, ':5', p_validation_level);
160: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_count);
161: DBMS_SQL.bind_variable (l_cursorid, ':7', x_msg_data);
162: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);
163: DBMS_SQL.bind_variable (l_cursorid, ':8', p_org_id);
164: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id);
165: DBMS_SQL.bind_variable (l_cursorid, ':10', p_source_object_code);

Line 162: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);

158: DBMS_SQL.bind_variable (l_cursorid, ':4', p_commit);
159: DBMS_SQL.bind_variable (l_cursorid, ':5', p_validation_level);
160: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_count);
161: DBMS_SQL.bind_variable (l_cursorid, ':7', x_msg_data);
162: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);
163: DBMS_SQL.bind_variable (l_cursorid, ':8', p_org_id);
164: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id);
165: DBMS_SQL.bind_variable (l_cursorid, ':10', p_source_object_code);
166: DBMS_SQL.bind_variable (l_cursorid, ':11', p_notes);

Line 163: DBMS_SQL.bind_variable (l_cursorid, ':8', p_org_id);

159: DBMS_SQL.bind_variable (l_cursorid, ':5', p_validation_level);
160: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_count);
161: DBMS_SQL.bind_variable (l_cursorid, ':7', x_msg_data);
162: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);
163: DBMS_SQL.bind_variable (l_cursorid, ':8', p_org_id);
164: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id);
165: DBMS_SQL.bind_variable (l_cursorid, ':10', p_source_object_code);
166: DBMS_SQL.bind_variable (l_cursorid, ':11', p_notes);
167: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes_detail);

Line 164: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id);

160: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_count);
161: DBMS_SQL.bind_variable (l_cursorid, ':7', x_msg_data);
162: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);
163: DBMS_SQL.bind_variable (l_cursorid, ':8', p_org_id);
164: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id);
165: DBMS_SQL.bind_variable (l_cursorid, ':10', p_source_object_code);
166: DBMS_SQL.bind_variable (l_cursorid, ':11', p_notes);
167: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes_detail);
168: DBMS_SQL.bind_variable (l_cursorid, ':13', p_note_status);

Line 165: DBMS_SQL.bind_variable (l_cursorid, ':10', p_source_object_code);

161: DBMS_SQL.bind_variable (l_cursorid, ':7', x_msg_data);
162: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);
163: DBMS_SQL.bind_variable (l_cursorid, ':8', p_org_id);
164: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id);
165: DBMS_SQL.bind_variable (l_cursorid, ':10', p_source_object_code);
166: DBMS_SQL.bind_variable (l_cursorid, ':11', p_notes);
167: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes_detail);
168: DBMS_SQL.bind_variable (l_cursorid, ':13', p_note_status);
169: DBMS_SQL.bind_variable (l_cursorid, ':14', p_entered_by);

Line 166: DBMS_SQL.bind_variable (l_cursorid, ':11', p_notes);

162: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);
163: DBMS_SQL.bind_variable (l_cursorid, ':8', p_org_id);
164: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id);
165: DBMS_SQL.bind_variable (l_cursorid, ':10', p_source_object_code);
166: DBMS_SQL.bind_variable (l_cursorid, ':11', p_notes);
167: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes_detail);
168: DBMS_SQL.bind_variable (l_cursorid, ':13', p_note_status);
169: DBMS_SQL.bind_variable (l_cursorid, ':14', p_entered_by);
170: DBMS_SQL.bind_variable (l_cursorid, ':15', p_entered_date);

Line 167: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes_detail);

163: DBMS_SQL.bind_variable (l_cursorid, ':8', p_org_id);
164: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id);
165: DBMS_SQL.bind_variable (l_cursorid, ':10', p_source_object_code);
166: DBMS_SQL.bind_variable (l_cursorid, ':11', p_notes);
167: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes_detail);
168: DBMS_SQL.bind_variable (l_cursorid, ':13', p_note_status);
169: DBMS_SQL.bind_variable (l_cursorid, ':14', p_entered_by);
170: DBMS_SQL.bind_variable (l_cursorid, ':15', p_entered_date);
171: DBMS_SQL.bind_variable (l_cursorid, ':16', x_jtf_note_id);

Line 168: DBMS_SQL.bind_variable (l_cursorid, ':13', p_note_status);

164: DBMS_SQL.bind_variable (l_cursorid, ':9', p_source_object_id);
165: DBMS_SQL.bind_variable (l_cursorid, ':10', p_source_object_code);
166: DBMS_SQL.bind_variable (l_cursorid, ':11', p_notes);
167: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes_detail);
168: DBMS_SQL.bind_variable (l_cursorid, ':13', p_note_status);
169: DBMS_SQL.bind_variable (l_cursorid, ':14', p_entered_by);
170: DBMS_SQL.bind_variable (l_cursorid, ':15', p_entered_date);
171: DBMS_SQL.bind_variable (l_cursorid, ':16', x_jtf_note_id);
172: DBMS_SQL.bind_variable (l_cursorid, ':17', p_last_update_date);

Line 169: DBMS_SQL.bind_variable (l_cursorid, ':14', p_entered_by);

165: DBMS_SQL.bind_variable (l_cursorid, ':10', p_source_object_code);
166: DBMS_SQL.bind_variable (l_cursorid, ':11', p_notes);
167: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes_detail);
168: DBMS_SQL.bind_variable (l_cursorid, ':13', p_note_status);
169: DBMS_SQL.bind_variable (l_cursorid, ':14', p_entered_by);
170: DBMS_SQL.bind_variable (l_cursorid, ':15', p_entered_date);
171: DBMS_SQL.bind_variable (l_cursorid, ':16', x_jtf_note_id);
172: DBMS_SQL.bind_variable (l_cursorid, ':17', p_last_update_date);
173: DBMS_SQL.bind_variable (l_cursorid, ':18', p_last_updated_by);

Line 170: DBMS_SQL.bind_variable (l_cursorid, ':15', p_entered_date);

166: DBMS_SQL.bind_variable (l_cursorid, ':11', p_notes);
167: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes_detail);
168: DBMS_SQL.bind_variable (l_cursorid, ':13', p_note_status);
169: DBMS_SQL.bind_variable (l_cursorid, ':14', p_entered_by);
170: DBMS_SQL.bind_variable (l_cursorid, ':15', p_entered_date);
171: DBMS_SQL.bind_variable (l_cursorid, ':16', x_jtf_note_id);
172: DBMS_SQL.bind_variable (l_cursorid, ':17', p_last_update_date);
173: DBMS_SQL.bind_variable (l_cursorid, ':18', p_last_updated_by);
174: DBMS_SQL.bind_variable (l_cursorid, ':19', p_creation_date);

Line 171: DBMS_SQL.bind_variable (l_cursorid, ':16', x_jtf_note_id);

167: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes_detail);
168: DBMS_SQL.bind_variable (l_cursorid, ':13', p_note_status);
169: DBMS_SQL.bind_variable (l_cursorid, ':14', p_entered_by);
170: DBMS_SQL.bind_variable (l_cursorid, ':15', p_entered_date);
171: DBMS_SQL.bind_variable (l_cursorid, ':16', x_jtf_note_id);
172: DBMS_SQL.bind_variable (l_cursorid, ':17', p_last_update_date);
173: DBMS_SQL.bind_variable (l_cursorid, ':18', p_last_updated_by);
174: DBMS_SQL.bind_variable (l_cursorid, ':19', p_creation_date);
175: DBMS_SQL.bind_variable (l_cursorid, ':20', p_created_by);

Line 172: DBMS_SQL.bind_variable (l_cursorid, ':17', p_last_update_date);

168: DBMS_SQL.bind_variable (l_cursorid, ':13', p_note_status);
169: DBMS_SQL.bind_variable (l_cursorid, ':14', p_entered_by);
170: DBMS_SQL.bind_variable (l_cursorid, ':15', p_entered_date);
171: DBMS_SQL.bind_variable (l_cursorid, ':16', x_jtf_note_id);
172: DBMS_SQL.bind_variable (l_cursorid, ':17', p_last_update_date);
173: DBMS_SQL.bind_variable (l_cursorid, ':18', p_last_updated_by);
174: DBMS_SQL.bind_variable (l_cursorid, ':19', p_creation_date);
175: DBMS_SQL.bind_variable (l_cursorid, ':20', p_created_by);
176: DBMS_SQL.bind_variable (l_cursorid, ':21', p_last_update_login);

Line 173: DBMS_SQL.bind_variable (l_cursorid, ':18', p_last_updated_by);

169: DBMS_SQL.bind_variable (l_cursorid, ':14', p_entered_by);
170: DBMS_SQL.bind_variable (l_cursorid, ':15', p_entered_date);
171: DBMS_SQL.bind_variable (l_cursorid, ':16', x_jtf_note_id);
172: DBMS_SQL.bind_variable (l_cursorid, ':17', p_last_update_date);
173: DBMS_SQL.bind_variable (l_cursorid, ':18', p_last_updated_by);
174: DBMS_SQL.bind_variable (l_cursorid, ':19', p_creation_date);
175: DBMS_SQL.bind_variable (l_cursorid, ':20', p_created_by);
176: DBMS_SQL.bind_variable (l_cursorid, ':21', p_last_update_login);
177: DBMS_SQL.bind_variable (l_cursorid, ':22', p_attribute1);

Line 174: DBMS_SQL.bind_variable (l_cursorid, ':19', p_creation_date);

170: DBMS_SQL.bind_variable (l_cursorid, ':15', p_entered_date);
171: DBMS_SQL.bind_variable (l_cursorid, ':16', x_jtf_note_id);
172: DBMS_SQL.bind_variable (l_cursorid, ':17', p_last_update_date);
173: DBMS_SQL.bind_variable (l_cursorid, ':18', p_last_updated_by);
174: DBMS_SQL.bind_variable (l_cursorid, ':19', p_creation_date);
175: DBMS_SQL.bind_variable (l_cursorid, ':20', p_created_by);
176: DBMS_SQL.bind_variable (l_cursorid, ':21', p_last_update_login);
177: DBMS_SQL.bind_variable (l_cursorid, ':22', p_attribute1);
178: DBMS_SQL.bind_variable (l_cursorid, ':23', p_attribute2);

Line 175: DBMS_SQL.bind_variable (l_cursorid, ':20', p_created_by);

171: DBMS_SQL.bind_variable (l_cursorid, ':16', x_jtf_note_id);
172: DBMS_SQL.bind_variable (l_cursorid, ':17', p_last_update_date);
173: DBMS_SQL.bind_variable (l_cursorid, ':18', p_last_updated_by);
174: DBMS_SQL.bind_variable (l_cursorid, ':19', p_creation_date);
175: DBMS_SQL.bind_variable (l_cursorid, ':20', p_created_by);
176: DBMS_SQL.bind_variable (l_cursorid, ':21', p_last_update_login);
177: DBMS_SQL.bind_variable (l_cursorid, ':22', p_attribute1);
178: DBMS_SQL.bind_variable (l_cursorid, ':23', p_attribute2);
179: DBMS_SQL.bind_variable (l_cursorid, ':24', p_attribute3);

Line 176: DBMS_SQL.bind_variable (l_cursorid, ':21', p_last_update_login);

172: DBMS_SQL.bind_variable (l_cursorid, ':17', p_last_update_date);
173: DBMS_SQL.bind_variable (l_cursorid, ':18', p_last_updated_by);
174: DBMS_SQL.bind_variable (l_cursorid, ':19', p_creation_date);
175: DBMS_SQL.bind_variable (l_cursorid, ':20', p_created_by);
176: DBMS_SQL.bind_variable (l_cursorid, ':21', p_last_update_login);
177: DBMS_SQL.bind_variable (l_cursorid, ':22', p_attribute1);
178: DBMS_SQL.bind_variable (l_cursorid, ':23', p_attribute2);
179: DBMS_SQL.bind_variable (l_cursorid, ':24', p_attribute3);
180: DBMS_SQL.bind_variable (l_cursorid, ':25', p_attribute4);

Line 177: DBMS_SQL.bind_variable (l_cursorid, ':22', p_attribute1);

173: DBMS_SQL.bind_variable (l_cursorid, ':18', p_last_updated_by);
174: DBMS_SQL.bind_variable (l_cursorid, ':19', p_creation_date);
175: DBMS_SQL.bind_variable (l_cursorid, ':20', p_created_by);
176: DBMS_SQL.bind_variable (l_cursorid, ':21', p_last_update_login);
177: DBMS_SQL.bind_variable (l_cursorid, ':22', p_attribute1);
178: DBMS_SQL.bind_variable (l_cursorid, ':23', p_attribute2);
179: DBMS_SQL.bind_variable (l_cursorid, ':24', p_attribute3);
180: DBMS_SQL.bind_variable (l_cursorid, ':25', p_attribute4);
181: DBMS_SQL.bind_variable (l_cursorid, ':26', p_attribute5);

Line 178: DBMS_SQL.bind_variable (l_cursorid, ':23', p_attribute2);

174: DBMS_SQL.bind_variable (l_cursorid, ':19', p_creation_date);
175: DBMS_SQL.bind_variable (l_cursorid, ':20', p_created_by);
176: DBMS_SQL.bind_variable (l_cursorid, ':21', p_last_update_login);
177: DBMS_SQL.bind_variable (l_cursorid, ':22', p_attribute1);
178: DBMS_SQL.bind_variable (l_cursorid, ':23', p_attribute2);
179: DBMS_SQL.bind_variable (l_cursorid, ':24', p_attribute3);
180: DBMS_SQL.bind_variable (l_cursorid, ':25', p_attribute4);
181: DBMS_SQL.bind_variable (l_cursorid, ':26', p_attribute5);
182: DBMS_SQL.bind_variable (l_cursorid, ':27', p_attribute6);

Line 179: DBMS_SQL.bind_variable (l_cursorid, ':24', p_attribute3);

175: DBMS_SQL.bind_variable (l_cursorid, ':20', p_created_by);
176: DBMS_SQL.bind_variable (l_cursorid, ':21', p_last_update_login);
177: DBMS_SQL.bind_variable (l_cursorid, ':22', p_attribute1);
178: DBMS_SQL.bind_variable (l_cursorid, ':23', p_attribute2);
179: DBMS_SQL.bind_variable (l_cursorid, ':24', p_attribute3);
180: DBMS_SQL.bind_variable (l_cursorid, ':25', p_attribute4);
181: DBMS_SQL.bind_variable (l_cursorid, ':26', p_attribute5);
182: DBMS_SQL.bind_variable (l_cursorid, ':27', p_attribute6);
183: DBMS_SQL.bind_variable (l_cursorid, ':28', p_attribute7);

Line 180: DBMS_SQL.bind_variable (l_cursorid, ':25', p_attribute4);

176: DBMS_SQL.bind_variable (l_cursorid, ':21', p_last_update_login);
177: DBMS_SQL.bind_variable (l_cursorid, ':22', p_attribute1);
178: DBMS_SQL.bind_variable (l_cursorid, ':23', p_attribute2);
179: DBMS_SQL.bind_variable (l_cursorid, ':24', p_attribute3);
180: DBMS_SQL.bind_variable (l_cursorid, ':25', p_attribute4);
181: DBMS_SQL.bind_variable (l_cursorid, ':26', p_attribute5);
182: DBMS_SQL.bind_variable (l_cursorid, ':27', p_attribute6);
183: DBMS_SQL.bind_variable (l_cursorid, ':28', p_attribute7);
184: DBMS_SQL.bind_variable (l_cursorid, ':29', p_attribute8);

Line 181: DBMS_SQL.bind_variable (l_cursorid, ':26', p_attribute5);

177: DBMS_SQL.bind_variable (l_cursorid, ':22', p_attribute1);
178: DBMS_SQL.bind_variable (l_cursorid, ':23', p_attribute2);
179: DBMS_SQL.bind_variable (l_cursorid, ':24', p_attribute3);
180: DBMS_SQL.bind_variable (l_cursorid, ':25', p_attribute4);
181: DBMS_SQL.bind_variable (l_cursorid, ':26', p_attribute5);
182: DBMS_SQL.bind_variable (l_cursorid, ':27', p_attribute6);
183: DBMS_SQL.bind_variable (l_cursorid, ':28', p_attribute7);
184: DBMS_SQL.bind_variable (l_cursorid, ':29', p_attribute8);
185: DBMS_SQL.bind_variable (l_cursorid, ':30', p_attribute9);

Line 182: DBMS_SQL.bind_variable (l_cursorid, ':27', p_attribute6);

178: DBMS_SQL.bind_variable (l_cursorid, ':23', p_attribute2);
179: DBMS_SQL.bind_variable (l_cursorid, ':24', p_attribute3);
180: DBMS_SQL.bind_variable (l_cursorid, ':25', p_attribute4);
181: DBMS_SQL.bind_variable (l_cursorid, ':26', p_attribute5);
182: DBMS_SQL.bind_variable (l_cursorid, ':27', p_attribute6);
183: DBMS_SQL.bind_variable (l_cursorid, ':28', p_attribute7);
184: DBMS_SQL.bind_variable (l_cursorid, ':29', p_attribute8);
185: DBMS_SQL.bind_variable (l_cursorid, ':30', p_attribute9);
186: DBMS_SQL.bind_variable (l_cursorid, ':31', p_attribute10);

Line 183: DBMS_SQL.bind_variable (l_cursorid, ':28', p_attribute7);

179: DBMS_SQL.bind_variable (l_cursorid, ':24', p_attribute3);
180: DBMS_SQL.bind_variable (l_cursorid, ':25', p_attribute4);
181: DBMS_SQL.bind_variable (l_cursorid, ':26', p_attribute5);
182: DBMS_SQL.bind_variable (l_cursorid, ':27', p_attribute6);
183: DBMS_SQL.bind_variable (l_cursorid, ':28', p_attribute7);
184: DBMS_SQL.bind_variable (l_cursorid, ':29', p_attribute8);
185: DBMS_SQL.bind_variable (l_cursorid, ':30', p_attribute9);
186: DBMS_SQL.bind_variable (l_cursorid, ':31', p_attribute10);
187: DBMS_SQL.bind_variable (l_cursorid, ':32', p_attribute11);

Line 184: DBMS_SQL.bind_variable (l_cursorid, ':29', p_attribute8);

180: DBMS_SQL.bind_variable (l_cursorid, ':25', p_attribute4);
181: DBMS_SQL.bind_variable (l_cursorid, ':26', p_attribute5);
182: DBMS_SQL.bind_variable (l_cursorid, ':27', p_attribute6);
183: DBMS_SQL.bind_variable (l_cursorid, ':28', p_attribute7);
184: DBMS_SQL.bind_variable (l_cursorid, ':29', p_attribute8);
185: DBMS_SQL.bind_variable (l_cursorid, ':30', p_attribute9);
186: DBMS_SQL.bind_variable (l_cursorid, ':31', p_attribute10);
187: DBMS_SQL.bind_variable (l_cursorid, ':32', p_attribute11);
188: DBMS_SQL.bind_variable (l_cursorid, ':33', p_attribute12);

Line 185: DBMS_SQL.bind_variable (l_cursorid, ':30', p_attribute9);

181: DBMS_SQL.bind_variable (l_cursorid, ':26', p_attribute5);
182: DBMS_SQL.bind_variable (l_cursorid, ':27', p_attribute6);
183: DBMS_SQL.bind_variable (l_cursorid, ':28', p_attribute7);
184: DBMS_SQL.bind_variable (l_cursorid, ':29', p_attribute8);
185: DBMS_SQL.bind_variable (l_cursorid, ':30', p_attribute9);
186: DBMS_SQL.bind_variable (l_cursorid, ':31', p_attribute10);
187: DBMS_SQL.bind_variable (l_cursorid, ':32', p_attribute11);
188: DBMS_SQL.bind_variable (l_cursorid, ':33', p_attribute12);
189: DBMS_SQL.bind_variable (l_cursorid, ':34', p_attribute13);

Line 186: DBMS_SQL.bind_variable (l_cursorid, ':31', p_attribute10);

182: DBMS_SQL.bind_variable (l_cursorid, ':27', p_attribute6);
183: DBMS_SQL.bind_variable (l_cursorid, ':28', p_attribute7);
184: DBMS_SQL.bind_variable (l_cursorid, ':29', p_attribute8);
185: DBMS_SQL.bind_variable (l_cursorid, ':30', p_attribute9);
186: DBMS_SQL.bind_variable (l_cursorid, ':31', p_attribute10);
187: DBMS_SQL.bind_variable (l_cursorid, ':32', p_attribute11);
188: DBMS_SQL.bind_variable (l_cursorid, ':33', p_attribute12);
189: DBMS_SQL.bind_variable (l_cursorid, ':34', p_attribute13);
190: DBMS_SQL.bind_variable (l_cursorid, ':35', p_attribute14);

Line 187: DBMS_SQL.bind_variable (l_cursorid, ':32', p_attribute11);

183: DBMS_SQL.bind_variable (l_cursorid, ':28', p_attribute7);
184: DBMS_SQL.bind_variable (l_cursorid, ':29', p_attribute8);
185: DBMS_SQL.bind_variable (l_cursorid, ':30', p_attribute9);
186: DBMS_SQL.bind_variable (l_cursorid, ':31', p_attribute10);
187: DBMS_SQL.bind_variable (l_cursorid, ':32', p_attribute11);
188: DBMS_SQL.bind_variable (l_cursorid, ':33', p_attribute12);
189: DBMS_SQL.bind_variable (l_cursorid, ':34', p_attribute13);
190: DBMS_SQL.bind_variable (l_cursorid, ':35', p_attribute14);
191: DBMS_SQL.bind_variable (l_cursorid, ':36', p_attribute15);

Line 188: DBMS_SQL.bind_variable (l_cursorid, ':33', p_attribute12);

184: DBMS_SQL.bind_variable (l_cursorid, ':29', p_attribute8);
185: DBMS_SQL.bind_variable (l_cursorid, ':30', p_attribute9);
186: DBMS_SQL.bind_variable (l_cursorid, ':31', p_attribute10);
187: DBMS_SQL.bind_variable (l_cursorid, ':32', p_attribute11);
188: DBMS_SQL.bind_variable (l_cursorid, ':33', p_attribute12);
189: DBMS_SQL.bind_variable (l_cursorid, ':34', p_attribute13);
190: DBMS_SQL.bind_variable (l_cursorid, ':35', p_attribute14);
191: DBMS_SQL.bind_variable (l_cursorid, ':36', p_attribute15);
192: DBMS_SQL.bind_variable (l_cursorid, ':37', p_context);

Line 189: DBMS_SQL.bind_variable (l_cursorid, ':34', p_attribute13);

185: DBMS_SQL.bind_variable (l_cursorid, ':30', p_attribute9);
186: DBMS_SQL.bind_variable (l_cursorid, ':31', p_attribute10);
187: DBMS_SQL.bind_variable (l_cursorid, ':32', p_attribute11);
188: DBMS_SQL.bind_variable (l_cursorid, ':33', p_attribute12);
189: DBMS_SQL.bind_variable (l_cursorid, ':34', p_attribute13);
190: DBMS_SQL.bind_variable (l_cursorid, ':35', p_attribute14);
191: DBMS_SQL.bind_variable (l_cursorid, ':36', p_attribute15);
192: DBMS_SQL.bind_variable (l_cursorid, ':37', p_context);
193: DBMS_SQL.bind_variable (l_cursorid, ':38', p_note_type);

Line 190: DBMS_SQL.bind_variable (l_cursorid, ':35', p_attribute14);

186: DBMS_SQL.bind_variable (l_cursorid, ':31', p_attribute10);
187: DBMS_SQL.bind_variable (l_cursorid, ':32', p_attribute11);
188: DBMS_SQL.bind_variable (l_cursorid, ':33', p_attribute12);
189: DBMS_SQL.bind_variable (l_cursorid, ':34', p_attribute13);
190: DBMS_SQL.bind_variable (l_cursorid, ':35', p_attribute14);
191: DBMS_SQL.bind_variable (l_cursorid, ':36', p_attribute15);
192: DBMS_SQL.bind_variable (l_cursorid, ':37', p_context);
193: DBMS_SQL.bind_variable (l_cursorid, ':38', p_note_type);
194: --DBMS_SQL.BIND_VARIABLE_RAW (l_cursorid, ':39', p_jtf_note_contexts_tab);

Line 191: DBMS_SQL.bind_variable (l_cursorid, ':36', p_attribute15);

187: DBMS_SQL.bind_variable (l_cursorid, ':32', p_attribute11);
188: DBMS_SQL.bind_variable (l_cursorid, ':33', p_attribute12);
189: DBMS_SQL.bind_variable (l_cursorid, ':34', p_attribute13);
190: DBMS_SQL.bind_variable (l_cursorid, ':35', p_attribute14);
191: DBMS_SQL.bind_variable (l_cursorid, ':36', p_attribute15);
192: DBMS_SQL.bind_variable (l_cursorid, ':37', p_context);
193: DBMS_SQL.bind_variable (l_cursorid, ':38', p_note_type);
194: --DBMS_SQL.BIND_VARIABLE_RAW (l_cursorid, ':39', p_jtf_note_contexts_tab);
195: DBMS_SQL.bind_variable (l_cursorid, ':40', x_return_status);

Line 192: DBMS_SQL.bind_variable (l_cursorid, ':37', p_context);

188: DBMS_SQL.bind_variable (l_cursorid, ':33', p_attribute12);
189: DBMS_SQL.bind_variable (l_cursorid, ':34', p_attribute13);
190: DBMS_SQL.bind_variable (l_cursorid, ':35', p_attribute14);
191: DBMS_SQL.bind_variable (l_cursorid, ':36', p_attribute15);
192: DBMS_SQL.bind_variable (l_cursorid, ':37', p_context);
193: DBMS_SQL.bind_variable (l_cursorid, ':38', p_note_type);
194: --DBMS_SQL.BIND_VARIABLE_RAW (l_cursorid, ':39', p_jtf_note_contexts_tab);
195: DBMS_SQL.bind_variable (l_cursorid, ':40', x_return_status);
196: DBMS_SQL.bind_variable (l_cursorid, ':41', p_jtf_note_id);

Line 193: DBMS_SQL.bind_variable (l_cursorid, ':38', p_note_type);

189: DBMS_SQL.bind_variable (l_cursorid, ':34', p_attribute13);
190: DBMS_SQL.bind_variable (l_cursorid, ':35', p_attribute14);
191: DBMS_SQL.bind_variable (l_cursorid, ':36', p_attribute15);
192: DBMS_SQL.bind_variable (l_cursorid, ':37', p_context);
193: DBMS_SQL.bind_variable (l_cursorid, ':38', p_note_type);
194: --DBMS_SQL.BIND_VARIABLE_RAW (l_cursorid, ':39', p_jtf_note_contexts_tab);
195: DBMS_SQL.bind_variable (l_cursorid, ':40', x_return_status);
196: DBMS_SQL.bind_variable (l_cursorid, ':41', p_jtf_note_id);
197: */

Line 194: --DBMS_SQL.BIND_VARIABLE_RAW (l_cursorid, ':39', p_jtf_note_contexts_tab);

190: DBMS_SQL.bind_variable (l_cursorid, ':35', p_attribute14);
191: DBMS_SQL.bind_variable (l_cursorid, ':36', p_attribute15);
192: DBMS_SQL.bind_variable (l_cursorid, ':37', p_context);
193: DBMS_SQL.bind_variable (l_cursorid, ':38', p_note_type);
194: --DBMS_SQL.BIND_VARIABLE_RAW (l_cursorid, ':39', p_jtf_note_contexts_tab);
195: DBMS_SQL.bind_variable (l_cursorid, ':40', x_return_status);
196: DBMS_SQL.bind_variable (l_cursorid, ':41', p_jtf_note_id);
197: */
198: begin

Line 195: DBMS_SQL.bind_variable (l_cursorid, ':40', x_return_status);

191: DBMS_SQL.bind_variable (l_cursorid, ':36', p_attribute15);
192: DBMS_SQL.bind_variable (l_cursorid, ':37', p_context);
193: DBMS_SQL.bind_variable (l_cursorid, ':38', p_note_type);
194: --DBMS_SQL.BIND_VARIABLE_RAW (l_cursorid, ':39', p_jtf_note_contexts_tab);
195: DBMS_SQL.bind_variable (l_cursorid, ':40', x_return_status);
196: DBMS_SQL.bind_variable (l_cursorid, ':41', p_jtf_note_id);
197: */
198: begin
199: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 196: DBMS_SQL.bind_variable (l_cursorid, ':41', p_jtf_note_id);

192: DBMS_SQL.bind_variable (l_cursorid, ':37', p_context);
193: DBMS_SQL.bind_variable (l_cursorid, ':38', p_note_type);
194: --DBMS_SQL.BIND_VARIABLE_RAW (l_cursorid, ':39', p_jtf_note_contexts_tab);
195: DBMS_SQL.bind_variable (l_cursorid, ':40', x_return_status);
196: DBMS_SQL.bind_variable (l_cursorid, ':41', p_jtf_note_id);
197: */
198: begin
199: l_execute_status := DBMS_SQL.execute (l_cursorid);
200: exception

Line 199: l_execute_status := DBMS_SQL.execute (l_cursorid);

195: DBMS_SQL.bind_variable (l_cursorid, ':40', x_return_status);
196: DBMS_SQL.bind_variable (l_cursorid, ':41', p_jtf_note_id);
197: */
198: begin
199: l_execute_status := DBMS_SQL.execute (l_cursorid);
200: exception
201: when others then
202: null;
203: end;

Line 204: DBMS_SQL.close_cursor (l_cursorid);

200: exception
201: when others then
202: null;
203: end;
204: DBMS_SQL.close_cursor (l_cursorid);
205:
206: end if;
207:
208: END LOOP;

Line 255: l_cursorid := DBMS_SQL.open_cursor;

251: l_enable_flag := JTM_PROFILE_UTL_PKG.Get_enable_flag_at_resp
252: (p_app_short_name => Csr1.PRODUCT_CODE);
253:
254: if (l_enable_flag = 'Y') then
255: l_cursorid := DBMS_SQL.open_cursor;
256: l_strBuffer :=
257: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
258: '(:1,:2,:3,:4,:5,:6,:7,:8); ' ||
259: ' exception ' ||

Line 263: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);

259: ' exception ' ||
260: ' when others then ' ||
261: ' null; ' ||
262: ' end; ';
263: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
264: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
265: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
266: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
267: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

Line 264: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);

260: ' when others then ' ||
261: ' null; ' ||
262: ' end; ';
263: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
264: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
265: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
266: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
267: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
268: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);

Line 265: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);

261: ' null; ' ||
262: ' end; ';
263: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
264: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
265: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
266: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
267: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
268: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
269: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);

Line 266: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);

262: ' end; ';
263: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
264: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
265: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
266: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
267: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
268: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
269: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
270: DBMS_SQL.bind_variable (l_cursorid, ':7', x_return_status);

Line 267: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

263: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
264: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
265: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
266: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
267: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
268: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
269: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
270: DBMS_SQL.bind_variable (l_cursorid, ':7', x_return_status);
271: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);

Line 268: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);

264: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
265: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
266: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
267: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
268: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
269: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
270: DBMS_SQL.bind_variable (l_cursorid, ':7', x_return_status);
271: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);
272:

Line 269: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);

265: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
266: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
267: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
268: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
269: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
270: DBMS_SQL.bind_variable (l_cursorid, ':7', x_return_status);
271: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);
272:
273: /*

Line 270: DBMS_SQL.bind_variable (l_cursorid, ':7', x_return_status);

266: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
267: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
268: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
269: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
270: DBMS_SQL.bind_variable (l_cursorid, ':7', x_return_status);
271: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);
272:
273: /*
274: l_strBuffer :=

Line 271: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);

267: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
268: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
269: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
270: DBMS_SQL.bind_variable (l_cursorid, ':7', x_return_status);
271: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);
272:
273: /*
274: l_strBuffer :=
275: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||

Line 282: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);

278: ' exception ' ||
279: ' when others then ' ||
280: ' null; ' ||
281: ' end; ';
282: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
283: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
284: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
285: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
286: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

Line 283: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);

279: ' when others then ' ||
280: ' null; ' ||
281: ' end; ';
282: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
283: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
284: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
285: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
286: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
287: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);

Line 284: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);

280: ' null; ' ||
281: ' end; ';
282: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
283: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
284: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
285: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
286: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
287: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
288: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);

Line 285: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);

281: ' end; ';
282: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
283: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
284: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
285: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
286: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
287: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
288: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
289: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);

Line 286: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

282: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
283: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
284: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
285: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
286: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
287: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
288: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
289: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
290: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);

Line 287: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);

283: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
284: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
285: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
286: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
287: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
288: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
289: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
290: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
291: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);

Line 288: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);

284: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
285: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
286: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
287: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
288: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
289: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
290: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
291: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
292: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);

Line 289: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);

285: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
286: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
287: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
288: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
289: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
290: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
291: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
292: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
293: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);

Line 290: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);

286: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
287: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
288: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
289: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
290: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
291: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
292: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
293: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
294: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);

Line 291: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);

287: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
288: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
289: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
290: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
291: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
292: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
293: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
294: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
295: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);

Line 292: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);

288: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
289: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
290: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
291: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
292: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
293: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
294: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
295: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
296: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);

Line 293: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);

289: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
290: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
291: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
292: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
293: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
294: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
295: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
296: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
297: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);

Line 294: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);

290: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
291: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
292: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
293: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
294: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
295: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
296: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
297: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
298: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);

Line 295: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);

291: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
292: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
293: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
294: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
295: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
296: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
297: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
298: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
299: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);

Line 296: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);

292: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
293: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
294: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
295: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
296: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
297: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
298: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
299: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);
300: */

Line 297: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);

293: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
294: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
295: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
296: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
297: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
298: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
299: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);
300: */
301: begin

Line 298: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);

294: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
295: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
296: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
297: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
298: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
299: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);
300: */
301: begin
302: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 299: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);

295: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
296: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
297: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
298: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
299: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);
300: */
301: begin
302: l_execute_status := DBMS_SQL.execute (l_cursorid);
303: exception

Line 302: l_execute_status := DBMS_SQL.execute (l_cursorid);

298: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
299: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);
300: */
301: begin
302: l_execute_status := DBMS_SQL.execute (l_cursorid);
303: exception
304: when others then
305: null;
306: end;

Line 307: DBMS_SQL.close_cursor (l_cursorid);

303: exception
304: when others then
305: null;
306: end;
307: DBMS_SQL.close_cursor (l_cursorid);
308: end if;
309:
310: END LOOP;
311:

Line 358: l_cursorid := DBMS_SQL.open_cursor;

354: l_enable_flag := JTM_PROFILE_UTL_PKG.Get_enable_flag_at_resp
355: (p_app_short_name => Csr1.PRODUCT_CODE);
356:
357: if (l_enable_flag = 'Y') then
358: l_cursorid := DBMS_SQL.open_cursor;
359: l_strBuffer :=
360: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||
361: '(:1,:2,:3,:4,:5,:6,:7,:8); ' ||
362: ' exception ' ||

Line 366: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);

362: ' exception ' ||
363: ' when others then ' ||
364: ' null; ' ||
365: ' end; ';
366: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
367: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
368: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
369: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
370: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

Line 367: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);

363: ' when others then ' ||
364: ' null; ' ||
365: ' end; ';
366: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
367: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
368: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
369: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
370: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
371: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);

Line 368: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);

364: ' null; ' ||
365: ' end; ';
366: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
367: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
368: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
369: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
370: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
371: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
372: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);

Line 369: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);

365: ' end; ';
366: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
367: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
368: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
369: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
370: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
371: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
372: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
373: DBMS_SQL.bind_variable (l_cursorid, ':7', x_return_status);

Line 370: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

366: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
367: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
368: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
369: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
370: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
371: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
372: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
373: DBMS_SQL.bind_variable (l_cursorid, ':7', x_return_status);
374: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);

Line 371: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);

367: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
368: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
369: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
370: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
371: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
372: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
373: DBMS_SQL.bind_variable (l_cursorid, ':7', x_return_status);
374: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);
375:

Line 372: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);

368: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
369: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
370: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
371: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
372: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
373: DBMS_SQL.bind_variable (l_cursorid, ':7', x_return_status);
374: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);
375:
376: /*

Line 373: DBMS_SQL.bind_variable (l_cursorid, ':7', x_return_status);

369: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
370: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
371: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
372: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
373: DBMS_SQL.bind_variable (l_cursorid, ':7', x_return_status);
374: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);
375:
376: /*
377: l_strBuffer :=

Line 374: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);

370: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
371: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
372: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
373: DBMS_SQL.bind_variable (l_cursorid, ':7', x_return_status);
374: DBMS_SQL.bind_variable (l_cursorid, ':8', p_jtf_note_id);
375:
376: /*
377: l_strBuffer :=
378: ' begin ' || Csr1.HOOK_PACKAGE || '.' || Csr1.HOOK_API ||

Line 385: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);

381: ' exception ' ||
382: ' when others then ' ||
383: ' null; ' ||
384: ' end; ';
385: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
386: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
387: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
388: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
389: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

Line 386: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);

382: ' when others then ' ||
383: ' null; ' ||
384: ' end; ';
385: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
386: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
387: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
388: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
389: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
390: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);

Line 387: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);

383: ' null; ' ||
384: ' end; ';
385: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
386: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
387: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
388: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
389: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
390: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
391: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);

Line 388: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);

384: ' end; ';
385: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
386: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
387: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
388: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
389: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
390: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
391: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
392: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);

Line 389: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

385: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
386: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
387: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
388: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
389: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
390: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
391: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
392: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
393: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);

Line 390: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);

386: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
387: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
388: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
389: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
390: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
391: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
392: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
393: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
394: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);

Line 391: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);

387: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
388: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
389: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
390: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
391: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
392: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
393: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
394: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
395: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);

Line 392: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);

388: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
389: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
390: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
391: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
392: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
393: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
394: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
395: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
396: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);

Line 393: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);

389: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
390: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
391: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
392: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
393: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
394: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
395: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
396: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
397: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);

Line 394: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);

390: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
391: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
392: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
393: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
394: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
395: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
396: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
397: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
398: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);

Line 395: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);

391: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
392: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
393: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
394: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
395: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
396: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
397: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
398: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
399: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);

Line 396: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);

392: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
393: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
394: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
395: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
396: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
397: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
398: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
399: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
400: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);

Line 397: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);

393: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
394: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
395: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
396: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
397: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
398: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
399: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
400: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
401: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);

Line 398: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);

394: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
395: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
396: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
397: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
398: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
399: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
400: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
401: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
402: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);

Line 399: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);

395: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
396: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
397: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
398: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
399: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
400: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
401: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
402: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);
403: */

Line 400: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);

396: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
397: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
398: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
399: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
400: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
401: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
402: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);
403: */
404: begin

Line 401: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);

397: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
398: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
399: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
400: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
401: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
402: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);
403: */
404: begin
405: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 402: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);

398: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
399: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
400: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
401: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
402: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);
403: */
404: begin
405: l_execute_status := DBMS_SQL.execute (l_cursorid);
406: exception

Line 405: l_execute_status := DBMS_SQL.execute (l_cursorid);

401: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
402: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);
403: */
404: begin
405: l_execute_status := DBMS_SQL.execute (l_cursorid);
406: exception
407: when others then
408: null;
409: end;

Line 410: DBMS_SQL.close_cursor (l_cursorid);

406: exception
407: when others then
408: null;
409: end;
410: DBMS_SQL.close_cursor (l_cursorid);
411: end if;
412:
413: END LOOP;
414: