APPS.AD_RELEASES_PVT dependencies on AD_RELEASES

Line 1: package body ad_releases_pvt as

1: package body ad_releases_pvt as
2: /* $Header: adphrlsb.pls 120.1 2006/04/10 01:44:35 rahkumar noship $ */
3: procedure CreateRelease
4: (p_major_version number,
5: p_minor_version number,

Line 24: from ad_releases

20:
21: begin
22: select release_id
23: into p_release_id
24: from ad_releases
25: where major_version = p_major_version
26: and minor_version = p_minor_version
27: and tape_version = p_tape_version;
28:

Line 58: -- Do not reference table AD_RELEASES via the schema name APPS as some

54: -- Lock the table exclusively to do further validations
55: -- Major and Minor ids and update thge table
56: -- If somebody has the lock then exit with a error message
57: --
58: -- Do not reference table AD_RELEASES via the schema name APPS as some
59: -- customers do not have an APPS schema. Bug 2042101.
60:
61: lock table ad_releases in exclusive mode nowait;
62:

Line 61: lock table ad_releases in exclusive mode nowait;

57: --
58: -- Do not reference table AD_RELEASES via the schema name APPS as some
59: -- customers do not have an APPS schema. Bug 2042101.
60:
61: lock table ad_releases in exclusive mode nowait;
62:
63: update ad_releases
64: set end_date_active = p_start_dt - 1 / (24*60*60)
65: where release_id in (select release_id

Line 63: update ad_releases

59: -- customers do not have an APPS schema. Bug 2042101.
60:
61: lock table ad_releases in exclusive mode nowait;
62:
63: update ad_releases
64: set end_date_active = p_start_dt - 1 / (24*60*60)
65: where release_id in (select release_id
66: from ad_releases
67: where major_version = p_major_version

Line 66: from ad_releases

62:
63: update ad_releases
64: set end_date_active = p_start_dt - 1 / (24*60*60)
65: where release_id in (select release_id
66: from ad_releases
67: where major_version = p_major_version
68: and minor_version = p_minor_version
69: and sysdate between start_date_active and
70: nvl(end_date_active, sysdate+1));

Line 72: select ad_releases_s.nextval

68: and minor_version = p_minor_version
69: and sysdate between start_date_active and
70: nvl(end_date_active, sysdate+1));
71:
72: select ad_releases_s.nextval
73: into v_release_id
74: from dual;
75:
76: insert into ad_releases

Line 76: insert into ad_releases

72: select ad_releases_s.nextval
73: into v_release_id
74: from dual;
75:
76: insert into ad_releases
77: (
78: RELEASE_ID,
79: MAJOR_VERSION,
80: MINOR_VERSION,

Line 118: end ad_releases_pvt;

114: raise;
115: end CreateRelease;
116:
117:
118: end ad_releases_pvt;