APPS.AD_PATCH_HIST_MIGR_PKG dependencies on AD_PATCH_RUNS

Line 545: from ad_patch_runs

541:
542: begin
543: select patch_run_id
544: into l_patch_run_id
545: from ad_patch_runs
546: where start_date = p_start_date
547: and appl_top_id = l_at_id
548: and patch_driver_id = l_patch_driver_id;
549:

Line 593: from ad_patch_runs

589: -- using l_upd_to_rlse_id to populate UPDTD-TO-RLSE-ID for this patch.
590: begin
591: select null
592: into l_upd_to_rlse_id
593: from ad_patch_runs
594: where updated_to_release_id = l_upd_to_rlse_id;
595: exception when no_data_found then
596: null;
597: end;

Line 605: insert into ad_patch_runs

601: l_upd_to_rlse_id := null;
602: end;
603: end if;
604:
605: insert into ad_patch_runs
606: (
607: patch_run_id,
608: release_id,
609: session_id,

Line 626: ad_patch_runs_s.nextval,

622: creation_date, last_update_date, last_updated_by, created_by
623: )
624: values
625: (
626: ad_patch_runs_s.nextval,
627: l_rec_this_ptch_on_rlse_id,
628: ad_sessions_s.nextval,
629: p_rapid_install_flag,
630: l_upd_to_rlse_id,

Line 696: from ad_patch_runs

692: end if;
693:
694: select patch_run_id
695: into l_pr_id
696: from ad_patch_runs
697: where start_date = p_start_date
698: and appl_top_id = l_at_id
699: and patch_driver_id = l_pd_id;
700: