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.CAC_SR_OBJECT_CAPACITY_PKG dependencies on CAC_SR_OBJECT_CAPACITY

Line 1: package body CAC_SR_OBJECT_CAPACITY_PKG as

1: package body CAC_SR_OBJECT_CAPACITY_PKG as
2: /* $Header: cacsroctb.pls 120.1.12010000.3 2009/06/01 08:49:24 anangupt ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_OBJECT_CAPACITY_ID in NUMBER,

Line 21: X_AVAILABILITY_TYPE IN VARCHAR2 DEFAULT CAC_SR_OBJECT_CAPACITY_PUB.DEFAULT_AVAILABILITY_TYPE,

17: X_CREATED_BY in NUMBER,
18: X_LAST_UPDATE_DATE in DATE,
19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER,
21: X_AVAILABILITY_TYPE IN VARCHAR2 DEFAULT CAC_SR_OBJECT_CAPACITY_PUB.DEFAULT_AVAILABILITY_TYPE,
22: X_SOURCE_TYPE IN VARCHAR2
23: ) is
24: cursor C is select ROWID from CAC_SR_OBJECT_CAPACITY
25: where OBJECT_CAPACITY_ID = X_OBJECT_CAPACITY_ID

Line 24: cursor C is select ROWID from CAC_SR_OBJECT_CAPACITY

20: X_LAST_UPDATE_LOGIN in NUMBER,
21: X_AVAILABILITY_TYPE IN VARCHAR2 DEFAULT CAC_SR_OBJECT_CAPACITY_PUB.DEFAULT_AVAILABILITY_TYPE,
22: X_SOURCE_TYPE IN VARCHAR2
23: ) is
24: cursor C is select ROWID from CAC_SR_OBJECT_CAPACITY
25: where OBJECT_CAPACITY_ID = X_OBJECT_CAPACITY_ID
26: ;
27: begin
28: insert into CAC_SR_OBJECT_CAPACITY (

Line 28: insert into CAC_SR_OBJECT_CAPACITY (

24: cursor C is select ROWID from CAC_SR_OBJECT_CAPACITY
25: where OBJECT_CAPACITY_ID = X_OBJECT_CAPACITY_ID
26: ;
27: begin
28: insert into CAC_SR_OBJECT_CAPACITY (
29: OBJECT_CAPACITY_ID,
30: OBJECT_VERSION_NUMBER,
31: OBJECT_TYPE,
32: OBJECT_ID,

Line 102: from CAC_SR_OBJECT_CAPACITY

98: AVAILABLE_HOURS_BEFORE,
99: AVAILABLE_HOURS_AFTER,
100: SCHEDULE_DETAIL_ID,
101: STATUS
102: from CAC_SR_OBJECT_CAPACITY
103: where OBJECT_CAPACITY_ID = X_OBJECT_CAPACITY_ID
104: for update of OBJECT_CAPACITY_ID nowait;
105: recinfo c%rowtype;
106:

Line 154: X_AVAILABILITY_TYPE IN VARCHAR2 DEFAULT CAC_SR_OBJECT_CAPACITY_PUB.DEFAULT_AVAILABILITY_TYPE,

150: X_CREATED_BY in NUMBER,
151: X_LAST_UPDATE_DATE in DATE,
152: X_LAST_UPDATED_BY in NUMBER,
153: X_LAST_UPDATE_LOGIN in NUMBER,
154: X_AVAILABILITY_TYPE IN VARCHAR2 DEFAULT CAC_SR_OBJECT_CAPACITY_PUB.DEFAULT_AVAILABILITY_TYPE,
155: X_SOURCE_TYPE IN VARCHAR2
156: ) is
157: begin
158: update CAC_SR_OBJECT_CAPACITY set

Line 158: update CAC_SR_OBJECT_CAPACITY set

154: X_AVAILABILITY_TYPE IN VARCHAR2 DEFAULT CAC_SR_OBJECT_CAPACITY_PUB.DEFAULT_AVAILABILITY_TYPE,
155: X_SOURCE_TYPE IN VARCHAR2
156: ) is
157: begin
158: update CAC_SR_OBJECT_CAPACITY set
159: OBJECT_CAPACITY_ID = X_OBJECT_CAPACITY_ID,
160: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
161: OBJECT_TYPE = X_OBJECT_TYPE,
162: OBJECT_ID = X_OBJECT_ID,

Line 187: delete from CAC_SR_OBJECT_CAPACITY

183: procedure DELETE_ROW (
184: X_OBJECT_CAPACITY_ID in NUMBER
185: ) is
186: begin
187: delete from CAC_SR_OBJECT_CAPACITY
188: where OBJECT_CAPACITY_ID = X_OBJECT_CAPACITY_ID;
189:
190: if (sql%notfound) then
191: raise no_data_found;

Line 196: end CAC_SR_OBJECT_CAPACITY_PKG;

192: end if;
193:
194: end DELETE_ROW;
195:
196: end CAC_SR_OBJECT_CAPACITY_PKG;