APPS.AD_PATCH dependencies on AD_SNAPSHOT_BUGFIXES_S

Line 709: l_patch_succ ad_snapshot_bugfixes.success_flag%TYPE;

705: p_flag in varchar2,
706: p_reason_text in varchar2)
707: is
708: l_bug_id ad_bugs.bug_id%TYPE;
709: l_patch_succ ad_snapshot_bugfixes.success_flag%TYPE;
710:
711: begin
712:
713: -- get bug id from ad_bugs for the passed bug number and aru_release_name.

Line 832: l_snapshot_bug_id ad_snapshot_bugfixes.snapshot_bug_id%TYPE;

828: p_bug_status in varchar2)
829: is
830: l_bug_id ad_bugs.bug_id%TYPE;
831: l_snapshot_id ad_snapshots.snapshot_id%TYPE;
832: l_snapshot_bug_id ad_snapshot_bugfixes.snapshot_bug_id%TYPE;
833:
834: begin
835:
836: -- CASE I: On create, when there are no entries in AD_BUGS for the

Line 936: values (ad_snapshot_bugfixes_s.nextval,

932: creation_date,
933: last_update_date,
934: last_updated_by,
935: created_by)
936: values (ad_snapshot_bugfixes_s.nextval,
937: l_snapshot_id,
938: l_bug_id,
939: p_bug_status,
940: 'Y',