APPS.CN_ATTAIN_TIERS_PKG dependencies on CN_ATTAIN_TIERS

Line 1: package body CN_ATTAIN_TIERS_PKG as

1: package body CN_ATTAIN_TIERS_PKG as
2: /* $Header: cntattrb.pls 115.4 2002/11/21 21:09:07 hlchen ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_ATTAIN_TIER_ID in NUMBER,

Line 31: cursor C is select ROWID from CN_ATTAIN_TIERS

27: X_LAST_UPDATE_DATE in DATE,
28: X_LAST_UPDATED_BY in NUMBER,
29: X_LAST_UPDATE_LOGIN in NUMBER
30: ) is
31: cursor C is select ROWID from CN_ATTAIN_TIERS
32: where ATTAIN_TIER_ID = X_ATTAIN_TIER_ID
33: ;
34: begin
35: insert into CN_ATTAIN_TIERS (

Line 35: insert into CN_ATTAIN_TIERS (

31: cursor C is select ROWID from CN_ATTAIN_TIERS
32: where ATTAIN_TIER_ID = X_ATTAIN_TIER_ID
33: ;
34: begin
35: insert into CN_ATTAIN_TIERS (
36: ATTAIN_TIER_ID,
37: ATTAIN_SCHEDULE_ID,
38: PERCENT,
39: ATTRIBUTE_CATEGORY,

Line 142: from CN_ATTAIN_TIERS

138: ATTRIBUTE13,
139: ATTRIBUTE14,
140: ATTRIBUTE15,
141: OBJECT_VERSION_NUMBER
142: from CN_ATTAIN_TIERS
143: where ATTAIN_TIER_ID = X_ATTAIN_TIER_ID
144: for update of ATTAIN_TIER_ID nowait;
145: begin
146: for tlinfo in c1 loop

Line 218: update CN_ATTAIN_TIERS set

214: X_LAST_UPDATED_BY in NUMBER,
215: X_LAST_UPDATE_LOGIN in NUMBER
216: ) is
217: begin
218: update CN_ATTAIN_TIERS set
219: ATTAIN_SCHEDULE_ID = X_ATTAIN_SCHEDULE_ID,
220: PERCENT = X_PERCENT,
221: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
222: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 253: delete from CN_ATTAIN_TIERS

249: procedure DELETE_ROW (
250: X_ATTAIN_TIER_ID in NUMBER
251: ) is
252: begin
253: delete from CN_ATTAIN_TIERS
254: where ATTAIN_TIER_ID = X_ATTAIN_TIER_ID;
255:
256: if (sql%notfound) then
257: raise no_data_found;

Line 262: end CN_ATTAIN_TIERS_PKG;

258: end if;
259:
260: end DELETE_ROW;
261:
262: end CN_ATTAIN_TIERS_PKG;