DBA Data[Home] [Help]

APPS.FND_ADG_SUPPORT dependencies on FND_ADG_CONCURRENT_PROGRAM

Line 260: function init_program_change_rec return fnd_adg_concurrent_program%rowtype

256: /*==========================================================================*/
257:
258: /*==========================================================================*/
259:
260: function init_program_change_rec return fnd_adg_concurrent_program%rowtype
261: as
262: l_cp_rec fnd_adg_concurrent_program%rowtype;
263: begin
264:

Line 262: l_cp_rec fnd_adg_concurrent_program%rowtype;

258: /*==========================================================================*/
259:
260: function init_program_change_rec return fnd_adg_concurrent_program%rowtype
261: as
262: l_cp_rec fnd_adg_concurrent_program%rowtype;
263: begin
264:
265: l_cp_rec.Application_Id := null;
266: l_cp_rec.Concurrent_Program_Id := null;

Line 284: procedure update_conc_program_rec(p_cp_rec fnd_adg_concurrent_program%rowtype,

280: end;
281:
282: /*==========================================================================*/
283:
284: procedure update_conc_program_rec(p_cp_rec fnd_adg_concurrent_program%rowtype,
285: p_cp_chng_rec
286: fnd_adg_concurrent_program%rowtype,
287: p_util_caller boolean default false)
288: as

Line 286: fnd_adg_concurrent_program%rowtype,

282: /*==========================================================================*/
283:
284: procedure update_conc_program_rec(p_cp_rec fnd_adg_concurrent_program%rowtype,
285: p_cp_chng_rec
286: fnd_adg_concurrent_program%rowtype,
287: p_util_caller boolean default false)
288: as
289: PRAGMA AUTONOMOUS_TRANSACTION;
290: l_curr_cp_rec fnd_adg_concurrent_program%rowtype;

Line 290: l_curr_cp_rec fnd_adg_concurrent_program%rowtype;

286: fnd_adg_concurrent_program%rowtype,
287: p_util_caller boolean default false)
288: as
289: PRAGMA AUTONOMOUS_TRANSACTION;
290: l_curr_cp_rec fnd_adg_concurrent_program%rowtype;
291: begin
292:
293: select a.*
294: into l_curr_cp_rec

Line 295: from fnd_adg_concurrent_program a

291: begin
292:
293: select a.*
294: into l_curr_cp_rec
295: from fnd_adg_concurrent_program a
296: where a.Application_Id = p_cp_rec.Application_Id
297: and a.Concurrent_Program_Id = p_cp_rec.Concurrent_Program_Id
298: for update of a.Application_Id;
299:

Line 363: update fnd_adg_concurrent_program a

359: l_curr_cp_rec.use_automatic_redirection :=
360: p_cp_chng_rec.use_automatic_redirection;
361: end if;
362:
363: update fnd_adg_concurrent_program a
364: set row = l_curr_cp_rec
365: where a.Application_Id = p_cp_rec.Application_Id
366: and a.Concurrent_Program_Id = p_cp_rec.Concurrent_Program_Id;
367:

Line 374: function is_standalone_executable(p_cp_rec fnd_adg_concurrent_program%rowtype)

370: end;
371:
372: /*==========================================================================*/
373:
374: function is_standalone_executable(p_cp_rec fnd_adg_concurrent_program%rowtype)
375: return boolean
376: as
377: begin
378:

Line 424: return fnd_adg_concurrent_program%rowtype

420: /*==========================================================================*/
421:
422: function create_conc_program_rec(p_program_application_id number,
423: p_concurrent_program_id number)
424: return fnd_adg_concurrent_program%rowtype
425: as
426: PRAGMA AUTONOMOUS_TRANSACTION;
427: l_new_cp_rec fnd_adg_concurrent_program%rowtype;
428: l_is_supported_exe_type boolean;

Line 427: l_new_cp_rec fnd_adg_concurrent_program%rowtype;

423: p_concurrent_program_id number)
424: return fnd_adg_concurrent_program%rowtype
425: as
426: PRAGMA AUTONOMOUS_TRANSACTION;
427: l_new_cp_rec fnd_adg_concurrent_program%rowtype;
428: l_is_supported_exe_type boolean;
429: begin
430:
431: l_is_supported_exe_type :=

Line 459: insert into fnd_adg_concurrent_program values l_new_cp_rec ;

455: l_new_cp_rec.use_automatic_redirection := boolean_to_yn(false);
456:
457: begin
458:
459: insert into fnd_adg_concurrent_program values l_new_cp_rec ;
460:
461: commit;
462:
463: exception

Line 469: from fnd_adg_concurrent_program a

465: when DUP_VAL_ON_INDEX then -- somebody got there first
466:
467: select a.*
468: into l_new_cp_rec
469: from fnd_adg_concurrent_program a
470: where a.Application_Id = p_program_application_id
471: and a.Concurrent_Program_Id = p_concurrent_program_id;
472:
473: end;

Line 483: return fnd_adg_concurrent_program%rowtype

479: /*==========================================================================*/
480:
481: function get_conc_program_rec(p_program_application_id number,
482: p_concurrent_program_id number)
483: return fnd_adg_concurrent_program%rowtype
484: as
485: l_cp_rec fnd_adg_concurrent_program%rowtype;
486: begin
487:

Line 485: l_cp_rec fnd_adg_concurrent_program%rowtype;

481: function get_conc_program_rec(p_program_application_id number,
482: p_concurrent_program_id number)
483: return fnd_adg_concurrent_program%rowtype
484: as
485: l_cp_rec fnd_adg_concurrent_program%rowtype;
486: begin
487:
488: begin
489:

Line 492: from fnd_adg_concurrent_program a

488: begin
489:
490: select a.*
491: into l_cp_rec
492: from fnd_adg_concurrent_program a
493: where a.Application_Id = p_program_application_id
494: and a.Concurrent_Program_Id = p_concurrent_program_id;
495:
496: exception

Line 511: fnd_adg_concurrent_program%rowtype)

507:
508: /*==========================================================================*/
509:
510: function is_conc_program_changes(p_cp_chng_rec
511: fnd_adg_concurrent_program%rowtype)
512: return boolean
513: as
514: begin
515:

Line 541: fnd_adg_concurrent_program%rowtype,

537:
538: /*==========================================================================*/
539:
540: procedure do_handle_request_row_update(p_cp_rec
541: fnd_adg_concurrent_program%rowtype,
542: p_cp_chng_rec in out nocopy
543: fnd_adg_concurrent_program%rowtype,
544: p_connstr1 in out nocopy varchar2,
545: p_phase_code varchar2,

Line 543: fnd_adg_concurrent_program%rowtype,

539:
540: procedure do_handle_request_row_update(p_cp_rec
541: fnd_adg_concurrent_program%rowtype,
542: p_cp_chng_rec in out nocopy
543: fnd_adg_concurrent_program%rowtype,
544: p_connstr1 in out nocopy varchar2,
545: p_phase_code varchar2,
546: p_status_code varchar2
547: )

Line 656: fnd_adg_concurrent_program%rowtype,

652:
653: /*==========================================================================*/
654:
655: procedure do_handle_request_row_insert(p_cp_rec
656: fnd_adg_concurrent_program%rowtype,
657: p_cp_chng_rec in out nocopy
658: fnd_adg_concurrent_program%rowtype,
659: p_connstr1 in out nocopy varchar2,
660: p_nodename1 in out nocopy varchar2,

Line 658: fnd_adg_concurrent_program%rowtype,

654:
655: procedure do_handle_request_row_insert(p_cp_rec
656: fnd_adg_concurrent_program%rowtype,
657: p_cp_chng_rec in out nocopy
658: fnd_adg_concurrent_program%rowtype,
659: p_connstr1 in out nocopy varchar2,
660: p_nodename1 in out nocopy varchar2,
661: p_request_class_application_id
662: in out nocopy number,

Line 954: l_cp_chng_rec fnd_adg_concurrent_program%rowtype;

950: p_always_redirect_if_valid boolean default null,
951: p_use_automatic_redirection boolean default null
952: )
953: as
954: l_cp_chng_rec fnd_adg_concurrent_program%rowtype;
955: l_cp_rec fnd_adg_concurrent_program%rowtype;
956: begin
957:
958: l_cp_rec := get_conc_program_rec(p_application_id,

Line 955: l_cp_rec fnd_adg_concurrent_program%rowtype;

951: p_use_automatic_redirection boolean default null
952: )
953: as
954: l_cp_chng_rec fnd_adg_concurrent_program%rowtype;
955: l_cp_rec fnd_adg_concurrent_program%rowtype;
956: begin
957:
958: l_cp_rec := get_conc_program_rec(p_application_id,
959: p_concurrent_program_id);

Line 1159: l_cp_chng_rec fnd_adg_concurrent_program%rowtype;

1155: p_phase_code varchar2,
1156: p_status_code varchar2
1157: )
1158: as
1159: l_cp_chng_rec fnd_adg_concurrent_program%rowtype;
1160: l_cp_rec fnd_adg_concurrent_program%rowtype;
1161: l_cache_state boolean := null;
1162: begin
1163:

Line 1160: l_cp_rec fnd_adg_concurrent_program%rowtype;

1156: p_status_code varchar2
1157: )
1158: as
1159: l_cp_chng_rec fnd_adg_concurrent_program%rowtype;
1160: l_cp_rec fnd_adg_concurrent_program%rowtype;
1161: l_cache_state boolean := null;
1162: begin
1163:
1164: -- Use the control cache to avoid repeated reads.

Line 1263: l_cp_chng_rec fnd_adg_concurrent_program%rowtype;

1259: p_use_automatic_redirection boolean default null
1260: )
1261: as
1262: l_access_code number;
1263: l_cp_chng_rec fnd_adg_concurrent_program%rowtype;
1264: l_cp_rec fnd_adg_concurrent_program%rowtype;
1265: begin
1266:
1267: l_access_code := fnd_adg_utility.get_program_access_code;

Line 1264: l_cp_rec fnd_adg_concurrent_program%rowtype;

1260: )
1261: as
1262: l_access_code number;
1263: l_cp_chng_rec fnd_adg_concurrent_program%rowtype;
1264: l_cp_rec fnd_adg_concurrent_program%rowtype;
1265: begin
1266:
1267: l_access_code := fnd_adg_utility.get_program_access_code;
1268:

Line 1298: l_cp_rec fnd_adg_concurrent_program%rowtype;

1294: p_simulation boolean,
1295: p_logoff boolean,
1296: p_error_count number)
1297: as
1298: l_cp_rec fnd_adg_concurrent_program%rowtype;
1299: l_run_on_standby boolean;
1300: l_No_Standby_Failures number;
1301: l_No_Simulated_Failures number;
1302: begin