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

Line 199: l_cursorid := DBMS_SQL.open_cursor;

195:
196: /*Insert contract record, use dynamic SQL because Contracts might not be
197: implemented/used */
198:
199: l_cursorid := DBMS_SQL.open_cursor;
200: l_stmt := 'Begin CSL_CONTRACT_HANDLING_PKG.POST_INSERT_SR_CONTRACT_ACC( :1,:2,:3 );'||
201: ' Exception '||
202: ' when others then '||
203: ' null; '||

Line 205: DBMS_SQL.parse (l_cursorid, l_stmt, DBMS_SQL.v7);

201: ' Exception '||
202: ' when others then '||
203: ' null; '||
204: 'end; ';
205: DBMS_SQL.parse (l_cursorid, l_stmt, DBMS_SQL.v7);
206: DBMS_SQL.bind_variable (l_cursorid, ':1', p_incident_id);
207: DBMS_SQL.bind_variable (l_cursorid, ':2', p_resource_id);
208: DBMS_SQL.bind_variable (l_cursorid, ':3', l_status);
209: begin

Line 206: DBMS_SQL.bind_variable (l_cursorid, ':1', p_incident_id);

202: ' when others then '||
203: ' null; '||
204: 'end; ';
205: DBMS_SQL.parse (l_cursorid, l_stmt, DBMS_SQL.v7);
206: DBMS_SQL.bind_variable (l_cursorid, ':1', p_incident_id);
207: DBMS_SQL.bind_variable (l_cursorid, ':2', p_resource_id);
208: DBMS_SQL.bind_variable (l_cursorid, ':3', l_status);
209: begin
210: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 207: DBMS_SQL.bind_variable (l_cursorid, ':2', p_resource_id);

203: ' null; '||
204: 'end; ';
205: DBMS_SQL.parse (l_cursorid, l_stmt, DBMS_SQL.v7);
206: DBMS_SQL.bind_variable (l_cursorid, ':1', p_incident_id);
207: DBMS_SQL.bind_variable (l_cursorid, ':2', p_resource_id);
208: DBMS_SQL.bind_variable (l_cursorid, ':3', l_status);
209: begin
210: l_execute_status := DBMS_SQL.execute (l_cursorid);
211: end;

Line 208: DBMS_SQL.bind_variable (l_cursorid, ':3', l_status);

204: 'end; ';
205: DBMS_SQL.parse (l_cursorid, l_stmt, DBMS_SQL.v7);
206: DBMS_SQL.bind_variable (l_cursorid, ':1', p_incident_id);
207: DBMS_SQL.bind_variable (l_cursorid, ':2', p_resource_id);
208: DBMS_SQL.bind_variable (l_cursorid, ':3', l_status);
209: begin
210: l_execute_status := DBMS_SQL.execute (l_cursorid);
211: end;
212: DBMS_SQL.close_cursor (l_cursorid);

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

206: DBMS_SQL.bind_variable (l_cursorid, ':1', p_incident_id);
207: DBMS_SQL.bind_variable (l_cursorid, ':2', p_resource_id);
208: DBMS_SQL.bind_variable (l_cursorid, ':3', l_status);
209: begin
210: l_execute_status := DBMS_SQL.execute (l_cursorid);
211: end;
212: DBMS_SQL.close_cursor (l_cursorid);
213:
214: /*Done, all packages are called*/

Line 212: DBMS_SQL.close_cursor (l_cursorid);

208: DBMS_SQL.bind_variable (l_cursorid, ':3', l_status);
209: begin
210: l_execute_status := DBMS_SQL.execute (l_cursorid);
211: end;
212: DBMS_SQL.close_cursor (l_cursorid);
213:
214: /*Done, all packages are called*/
215: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
216: jtm_message_log_pkg.Log_Msg

Line 385: l_cursorid := DBMS_SQL.open_cursor;

381:
382:
383: /* Delete contract record, use dynamic SQL because Contracts might not be
384: implemented/used */
385: l_cursorid := DBMS_SQL.open_cursor;
386: l_stmt := 'Begin CSL_CONTRACT_HANDLING_PKG.PRE_DELETE_SR_CONTRACT_ACC( :1,:2,:3 );'||
387: ' Exception '||
388: ' when others then '||
389: ' null; '||

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

387: ' Exception '||
388: ' when others then '||
389: ' null; '||
390: 'end; ';
391: DBMS_SQL.parse (l_cursorid, l_stmt, DBMS_SQL.v7);
392: DBMS_SQL.bind_variable (l_cursorid, ':1', p_incident_id);
393: DBMS_SQL.bind_variable (l_cursorid, ':2', p_resource_id);
394: DBMS_SQL.bind_variable (l_cursorid, ':3', l_status);
395: begin

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

388: ' when others then '||
389: ' null; '||
390: 'end; ';
391: DBMS_SQL.parse (l_cursorid, l_stmt, DBMS_SQL.v7);
392: DBMS_SQL.bind_variable (l_cursorid, ':1', p_incident_id);
393: DBMS_SQL.bind_variable (l_cursorid, ':2', p_resource_id);
394: DBMS_SQL.bind_variable (l_cursorid, ':3', l_status);
395: begin
396: l_execute_status := DBMS_SQL.execute (l_cursorid);

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

389: ' null; '||
390: 'end; ';
391: DBMS_SQL.parse (l_cursorid, l_stmt, DBMS_SQL.v7);
392: DBMS_SQL.bind_variable (l_cursorid, ':1', p_incident_id);
393: DBMS_SQL.bind_variable (l_cursorid, ':2', p_resource_id);
394: DBMS_SQL.bind_variable (l_cursorid, ':3', l_status);
395: begin
396: l_execute_status := DBMS_SQL.execute (l_cursorid);
397: end;

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

390: 'end; ';
391: DBMS_SQL.parse (l_cursorid, l_stmt, DBMS_SQL.v7);
392: DBMS_SQL.bind_variable (l_cursorid, ':1', p_incident_id);
393: DBMS_SQL.bind_variable (l_cursorid, ':2', p_resource_id);
394: DBMS_SQL.bind_variable (l_cursorid, ':3', l_status);
395: begin
396: l_execute_status := DBMS_SQL.execute (l_cursorid);
397: end;
398: DBMS_SQL.close_cursor (l_cursorid);

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

392: DBMS_SQL.bind_variable (l_cursorid, ':1', p_incident_id);
393: DBMS_SQL.bind_variable (l_cursorid, ':2', p_resource_id);
394: DBMS_SQL.bind_variable (l_cursorid, ':3', l_status);
395: begin
396: l_execute_status := DBMS_SQL.execute (l_cursorid);
397: end;
398: DBMS_SQL.close_cursor (l_cursorid);
399:
400:

Line 398: DBMS_SQL.close_cursor (l_cursorid);

394: DBMS_SQL.bind_variable (l_cursorid, ':3', l_status);
395: begin
396: l_execute_status := DBMS_SQL.execute (l_cursorid);
397: end;
398: DBMS_SQL.close_cursor (l_cursorid);
399:
400:
401: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
402: jtm_message_log_pkg.Log_Msg

Line 735: l_tab_resource_id dbms_sql.Number_Table;

731: l_incident_id NUMBER;
732: l_replicate BOOLEAN;
733: l_dummy BOOLEAN;
734:
735: l_tab_resource_id dbms_sql.Number_Table;
736: l_tab_access_id dbms_sql.Number_Table;
737: l_enabled_flag VARCHAR2(30);
738:
739: l_status VARCHAR2(30);

Line 736: l_tab_access_id dbms_sql.Number_Table;

732: l_replicate BOOLEAN;
733: l_dummy BOOLEAN;
734:
735: l_tab_resource_id dbms_sql.Number_Table;
736: l_tab_access_id dbms_sql.Number_Table;
737: l_enabled_flag VARCHAR2(30);
738:
739: l_status VARCHAR2(30);
740: l_stmt VARCHAR2(4000);

Line 901: l_cursorid := DBMS_SQL.open_cursor;

897: , 'Contract line of the incident has changed.'
898: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
899: END IF;
900:
901: l_cursorid := DBMS_SQL.open_cursor;
902: l_stmt := 'Begin CSL_CONTRACT_HANDLING_PKG.POST_UPDATE_SR_CONTRACT_ACC( :1,:2,:3,:4,:5 );'||
903: ' Exception '||
904: ' when others then '||
905: ' null; '||

Line 907: DBMS_SQL.parse (l_cursorid, l_stmt, DBMS_SQL.v7);

903: ' Exception '||
904: ' when others then '||
905: ' null; '||
906: 'end; ';
907: DBMS_SQL.parse (l_cursorid, l_stmt, DBMS_SQL.v7);
908: DBMS_SQL.bind_variable (l_cursorid, ':1', l_incident_id);
909: DBMS_SQL.bind_variable (l_cursorid, ':2', g_cached_rec.contract_service_id);
910: DBMS_SQL.bind_variable (l_cursorid, ':3', r_incident.contract_service_id);
911: DBMS_SQL.bind_variable (l_cursorid, ':4', l_tab_resource_id(i));

Line 908: DBMS_SQL.bind_variable (l_cursorid, ':1', l_incident_id);

904: ' when others then '||
905: ' null; '||
906: 'end; ';
907: DBMS_SQL.parse (l_cursorid, l_stmt, DBMS_SQL.v7);
908: DBMS_SQL.bind_variable (l_cursorid, ':1', l_incident_id);
909: DBMS_SQL.bind_variable (l_cursorid, ':2', g_cached_rec.contract_service_id);
910: DBMS_SQL.bind_variable (l_cursorid, ':3', r_incident.contract_service_id);
911: DBMS_SQL.bind_variable (l_cursorid, ':4', l_tab_resource_id(i));
912: DBMS_SQL.bind_variable (l_cursorid, ':5', l_status);

Line 909: DBMS_SQL.bind_variable (l_cursorid, ':2', g_cached_rec.contract_service_id);

905: ' null; '||
906: 'end; ';
907: DBMS_SQL.parse (l_cursorid, l_stmt, DBMS_SQL.v7);
908: DBMS_SQL.bind_variable (l_cursorid, ':1', l_incident_id);
909: DBMS_SQL.bind_variable (l_cursorid, ':2', g_cached_rec.contract_service_id);
910: DBMS_SQL.bind_variable (l_cursorid, ':3', r_incident.contract_service_id);
911: DBMS_SQL.bind_variable (l_cursorid, ':4', l_tab_resource_id(i));
912: DBMS_SQL.bind_variable (l_cursorid, ':5', l_status);
913: begin

Line 910: DBMS_SQL.bind_variable (l_cursorid, ':3', r_incident.contract_service_id);

906: 'end; ';
907: DBMS_SQL.parse (l_cursorid, l_stmt, DBMS_SQL.v7);
908: DBMS_SQL.bind_variable (l_cursorid, ':1', l_incident_id);
909: DBMS_SQL.bind_variable (l_cursorid, ':2', g_cached_rec.contract_service_id);
910: DBMS_SQL.bind_variable (l_cursorid, ':3', r_incident.contract_service_id);
911: DBMS_SQL.bind_variable (l_cursorid, ':4', l_tab_resource_id(i));
912: DBMS_SQL.bind_variable (l_cursorid, ':5', l_status);
913: begin
914: l_execute_status := DBMS_SQL.execute (l_cursorid);

Line 911: DBMS_SQL.bind_variable (l_cursorid, ':4', l_tab_resource_id(i));

907: DBMS_SQL.parse (l_cursorid, l_stmt, DBMS_SQL.v7);
908: DBMS_SQL.bind_variable (l_cursorid, ':1', l_incident_id);
909: DBMS_SQL.bind_variable (l_cursorid, ':2', g_cached_rec.contract_service_id);
910: DBMS_SQL.bind_variable (l_cursorid, ':3', r_incident.contract_service_id);
911: DBMS_SQL.bind_variable (l_cursorid, ':4', l_tab_resource_id(i));
912: DBMS_SQL.bind_variable (l_cursorid, ':5', l_status);
913: begin
914: l_execute_status := DBMS_SQL.execute (l_cursorid);
915: end;

Line 912: DBMS_SQL.bind_variable (l_cursorid, ':5', l_status);

908: DBMS_SQL.bind_variable (l_cursorid, ':1', l_incident_id);
909: DBMS_SQL.bind_variable (l_cursorid, ':2', g_cached_rec.contract_service_id);
910: DBMS_SQL.bind_variable (l_cursorid, ':3', r_incident.contract_service_id);
911: DBMS_SQL.bind_variable (l_cursorid, ':4', l_tab_resource_id(i));
912: DBMS_SQL.bind_variable (l_cursorid, ':5', l_status);
913: begin
914: l_execute_status := DBMS_SQL.execute (l_cursorid);
915: end;
916: DBMS_SQL.close_cursor (l_cursorid);

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

910: DBMS_SQL.bind_variable (l_cursorid, ':3', r_incident.contract_service_id);
911: DBMS_SQL.bind_variable (l_cursorid, ':4', l_tab_resource_id(i));
912: DBMS_SQL.bind_variable (l_cursorid, ':5', l_status);
913: begin
914: l_execute_status := DBMS_SQL.execute (l_cursorid);
915: end;
916: DBMS_SQL.close_cursor (l_cursorid);
917: END IF;--contract check
918:

Line 916: DBMS_SQL.close_cursor (l_cursorid);

912: DBMS_SQL.bind_variable (l_cursorid, ':5', l_status);
913: begin
914: l_execute_status := DBMS_SQL.execute (l_cursorid);
915: end;
916: DBMS_SQL.close_cursor (l_cursorid);
917: END IF;--contract check
918:
919: END LOOP;
920: END IF;