APPS.FND_PURPOSE_ATTRIBUTES_PKG dependencies on FND_PURPOSE_ATTRIBUTES

Line 1: package body FND_PURPOSE_ATTRIBUTES_PKG as

1: package body FND_PURPOSE_ATTRIBUTES_PKG as
2: /* $Header: fndpipab.pls 120.1 2005/07/02 03:34:53 appldev noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_PURPOSE_ATTRIBUTE_ID in NUMBER,

Line 16: cursor C is select ROWID from FND_PURPOSE_ATTRIBUTES

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from FND_PURPOSE_ATTRIBUTES
17: where PURPOSE_ATTRIBUTE_ID = X_PURPOSE_ATTRIBUTE_ID
18: ;
19: begin
20: insert into FND_PURPOSE_ATTRIBUTES (

Line 20: insert into FND_PURPOSE_ATTRIBUTES (

16: cursor C is select ROWID from FND_PURPOSE_ATTRIBUTES
17: where PURPOSE_ATTRIBUTE_ID = X_PURPOSE_ATTRIBUTE_ID
18: ;
19: begin
20: insert into FND_PURPOSE_ATTRIBUTES (
21: PURPOSE_ATTRIBUTE_ID,
22: PRIVACY_ATTRIBUTE_CODE,
23: PURPOSE_CODE,
24: ATTRIBUTE_DEFAULT_CODE,

Line 46: from FND_PURPOSE_ATTRIBUTES T

42: /* from FND_LANGUAGES L
43: where L.INSTALLED_FLAG in ('I', 'B')
44: and not exists
45: (select NULL
46: from FND_PURPOSE_ATTRIBUTES T
47: where T.PURPOSE_ATTRIBUTE_ID = X_PURPOSE_ATTRIBUTE_ID);
48: */
49:
50: open c;

Line 74: from FND_PURPOSE_ATTRIBUTES

70: PURPOSE_CODE,
71: ATTRIBUTE_DEFAULT_CODE,
72: OBJECT_VERSION_NUMBER,
73: CREATED_BY
74: from FND_PURPOSE_ATTRIBUTES
75: where PURPOSE_ATTRIBUTE_ID = X_PURPOSE_ATTRIBUTE_ID
76: for update of PURPOSE_ATTRIBUTE_ID nowait;
77: begin
78: for tlinfo in c1 loop

Line 105: update FND_PURPOSE_ATTRIBUTES set

101: X_LAST_UPDATED_BY in NUMBER,
102: X_LAST_UPDATE_LOGIN in NUMBER
103: ) is
104: begin
105: update FND_PURPOSE_ATTRIBUTES set
106: PRIVACY_ATTRIBUTE_CODE = X_PRIVACY_ATTRIBUTE_CODE,
107: PURPOSE_CODE = X_PURPOSE_CODE,
108: ATTRIBUTE_DEFAULT_CODE = X_ATTRIBUTE_DEFAULT_CODE,
109: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 124: delete from FND_PURPOSE_ATTRIBUTES

120: procedure DELETE_ROW (
121: X_PURPOSE_ATTRIBUTE_ID in NUMBER
122: ) is
123: begin
124: delete from FND_PURPOSE_ATTRIBUTES
125: where PURPOSE_ATTRIBUTE_ID = X_PURPOSE_ATTRIBUTE_ID;
126:
127: if (sql%notfound) then
128: raise no_data_found;

Line 133: end FND_PURPOSE_ATTRIBUTES_PKG;

129: end if;
130:
131: end DELETE_ROW;
132:
133: end FND_PURPOSE_ATTRIBUTES_PKG;