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 2005/07/02 02:18:40 appldev noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_OBJECT_CAPACITY_ID in NUMBER,

Line 22: cursor C is select ROWID from CAC_SR_OBJECT_CAPACITY

18: X_LAST_UPDATE_DATE in DATE,
19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER
21: ) is
22: cursor C is select ROWID from CAC_SR_OBJECT_CAPACITY
23: where OBJECT_CAPACITY_ID = X_OBJECT_CAPACITY_ID
24: ;
25: begin
26: insert into CAC_SR_OBJECT_CAPACITY (

Line 26: insert into CAC_SR_OBJECT_CAPACITY (

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

Line 96: from CAC_SR_OBJECT_CAPACITY

92: AVAILABLE_HOURS_BEFORE,
93: AVAILABLE_HOURS_AFTER,
94: SCHEDULE_DETAIL_ID,
95: STATUS
96: from CAC_SR_OBJECT_CAPACITY
97: where OBJECT_CAPACITY_ID = X_OBJECT_CAPACITY_ID
98: for update of OBJECT_CAPACITY_ID nowait;
99: recinfo c%rowtype;
100:

Line 150: update CAC_SR_OBJECT_CAPACITY set

146: X_LAST_UPDATED_BY in NUMBER,
147: X_LAST_UPDATE_LOGIN in NUMBER
148: ) is
149: begin
150: update CAC_SR_OBJECT_CAPACITY set
151: OBJECT_CAPACITY_ID = X_OBJECT_CAPACITY_ID,
152: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
153: OBJECT_TYPE = X_OBJECT_TYPE,
154: OBJECT_ID = X_OBJECT_ID,

Line 177: delete from CAC_SR_OBJECT_CAPACITY

173: procedure DELETE_ROW (
174: X_OBJECT_CAPACITY_ID in NUMBER
175: ) is
176: begin
177: delete from CAC_SR_OBJECT_CAPACITY
178: where OBJECT_CAPACITY_ID = X_OBJECT_CAPACITY_ID;
179:
180: if (sql%notfound) then
181: raise no_data_found;

Line 186: end CAC_SR_OBJECT_CAPACITY_PKG;

182: end if;
183:
184: end DELETE_ROW;
185:
186: end CAC_SR_OBJECT_CAPACITY_PKG;