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.JTF_NOTES_VUHK dependencies on DBMS_SQL

Line 141: l_cursorid := DBMS_SQL.open_cursor;

137: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
138: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
139:
140: if (l_JTM_enable_prof_value = 'Y') then
141: l_cursorid := DBMS_SQL.open_cursor;
142: l_strBuffer :=
143: ' begin ' || 'JTM_NOTES_VUHK' || '.' || 'CREATE_NOTE_POST' ||
144: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,' ||
145: ' :11,:12,:13,:14,:15,:16,:17,:18,:19,:20,' ||

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

192: DBMS_SQL.bind_variable (l_cursorid, ':40', x_return_status);
193: DBMS_SQL.bind_variable (l_cursorid, ':41', p_jtf_note_id);
194:
195: begin
196: l_execute_status := DBMS_SQL.execute (l_cursorid);
197: exception
198: when others then
199: EXECUTE IMMEDIATE l_strLogBuffer;
200: end;

Line 201: DBMS_SQL.close_cursor (l_cursorid);

197: exception
198: when others then
199: EXECUTE IMMEDIATE l_strLogBuffer;
200: end;
201: DBMS_SQL.close_cursor (l_cursorid);
202:
203: end if;
204: EXCEPTION
205: WHEN OTHERS THEN

Line 275: l_cursorid := DBMS_SQL.open_cursor;

271: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
272: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
273:
274: if (l_JTM_enable_prof_value = 'Y') then
275: l_cursorid := DBMS_SQL.open_cursor;
276: l_strBuffer :=
277: ' begin ' || 'JTM_NOTES_VUHK' || '.' || 'update_note_pre' ||
278: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,' ||
279: ' :11,:12,:13,:14,:15,:16,:17); ' ||

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

297: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
298: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
299: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
300: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
301: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);
302: begin
303: l_execute_status := DBMS_SQL.execute (l_cursorid);
304: exception
305: when others then

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

299: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
300: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
301: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);
302: begin
303: l_execute_status := DBMS_SQL.execute (l_cursorid);
304: exception
305: when others then
306: EXECUTE IMMEDIATE l_strLogBuffer;
307: end;

Line 308: DBMS_SQL.close_cursor (l_cursorid);

304: exception
305: when others then
306: EXECUTE IMMEDIATE l_strLogBuffer;
307: end;
308: DBMS_SQL.close_cursor (l_cursorid);
309: end if;
310:
311: EXCEPTION
312: WHEN OTHERS THEN

Line 382: l_cursorid := DBMS_SQL.open_cursor;

378: l_JTM_enable_prof_value := fnd_profile.VALUE_SPECIFIC(
379: Name => 'JTM_MOB_APPS_ENABLED', APPLICATION_ID => 874);
380:
381: if (l_JTM_enable_prof_value = 'Y') then
382: l_cursorid := DBMS_SQL.open_cursor;
383: l_strBuffer :=
384: ' begin ' || 'JTM_NOTES_VUHK' || '.' || 'update_note_post' ||
385: '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,' ||
386: ' :11,:12,:13,:14,:15,:16,:17); ' ||

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

387: ' exception ' ||
388: ' when others then ' ||
389: l_strLogBuffer ||
390: ' end; ';
391: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
392: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
393: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
394: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
395: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);

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

388: ' when others then ' ||
389: l_strLogBuffer ||
390: ' end; ';
391: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
392: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
393: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
394: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
395: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
396: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);

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

389: l_strLogBuffer ||
390: ' end; ';
391: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
392: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
393: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
394: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
395: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
396: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
397: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);

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

390: ' end; ';
391: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
392: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
393: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
394: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
395: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
396: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
397: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
398: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);

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

391: DBMS_SQL.parse (l_cursorid, l_strBuffer, DBMS_SQL.v7);
392: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
393: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
394: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
395: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
396: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
397: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
398: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
399: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);

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

392: DBMS_SQL.bind_variable (l_cursorid, ':1', p_api_version);
393: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
394: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
395: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
396: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
397: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
398: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
399: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
400: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);

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

393: DBMS_SQL.bind_variable (l_cursorid, ':2', p_init_msg_list);
394: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
395: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
396: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
397: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
398: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
399: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
400: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
401: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);

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

394: DBMS_SQL.bind_variable (l_cursorid, ':3', p_commit);
395: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
396: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
397: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
398: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
399: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
400: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
401: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
402: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);

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

395: DBMS_SQL.bind_variable (l_cursorid, ':4', p_validation_level);
396: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
397: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
398: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
399: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
400: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
401: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
402: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
403: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);

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

396: DBMS_SQL.bind_variable (l_cursorid, ':5', x_msg_count);
397: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
398: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
399: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
400: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
401: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
402: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
403: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
404: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);

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

397: DBMS_SQL.bind_variable (l_cursorid, ':6', x_msg_data);
398: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
399: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
400: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
401: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
402: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
403: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
404: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
405: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);

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

398: DBMS_SQL.bind_variable (l_cursorid, ':7', p_jtf_note_id);
399: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
400: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
401: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
402: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
403: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
404: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
405: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
406: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);

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

399: DBMS_SQL.bind_variable (l_cursorid, ':8', p_entered_by);
400: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
401: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
402: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
403: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
404: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
405: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
406: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
407: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);

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

400: DBMS_SQL.bind_variable (l_cursorid, ':9', p_last_updated_by);
401: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
402: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
403: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
404: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
405: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
406: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
407: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
408: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);

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

401: DBMS_SQL.bind_variable (l_cursorid, ':10', p_last_update_date);
402: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
403: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
404: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
405: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
406: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
407: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
408: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);
409:

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

402: DBMS_SQL.bind_variable (l_cursorid, ':11', p_last_update_login);
403: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
404: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
405: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
406: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
407: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
408: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);
409:
410: begin

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

403: DBMS_SQL.bind_variable (l_cursorid, ':12', p_notes);
404: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
405: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
406: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
407: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
408: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);
409:
410: begin
411: l_execute_status := DBMS_SQL.execute (l_cursorid);

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

404: DBMS_SQL.bind_variable (l_cursorid, ':13', p_notes_detail);
405: DBMS_SQL.bind_variable (l_cursorid, ':14', p_append_flag);
406: DBMS_SQL.bind_variable (l_cursorid, ':15', p_note_status);
407: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
408: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);
409:
410: begin
411: l_execute_status := DBMS_SQL.execute (l_cursorid);
412: exception

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

407: DBMS_SQL.bind_variable (l_cursorid, ':16', p_note_type);
408: DBMS_SQL.bind_variable (l_cursorid, ':17', x_return_status);
409:
410: begin
411: l_execute_status := DBMS_SQL.execute (l_cursorid);
412: exception
413: when others then
414: EXECUTE IMMEDIATE l_strLogBuffer;
415: end;

Line 416: DBMS_SQL.close_cursor (l_cursorid);

412: exception
413: when others then
414: EXECUTE IMMEDIATE l_strLogBuffer;
415: end;
416: DBMS_SQL.close_cursor (l_cursorid);
417: end if;
418:
419: EXCEPTION
420: WHEN OTHERS THEN