APPS.FND_OAM_DS_PSETS_PKG dependencies on FND_OAM_DS_PSETS_B

Line 14: cursor C is select ROWID from FND_OAM_DS_PSETS_B

10: X_LAST_UPDATED_BY in NUMBER,
11: X_LAST_UPDATE_DATE in DATE,
12: X_LAST_UPDATE_LOGIN in NUMBER
13: ) is
14: cursor C is select ROWID from FND_OAM_DS_PSETS_B
15: where POLICYSET_ID = X_POLICYSET_ID;
16: begin
17: insert into FND_OAM_DS_PSETS_B (
18: POLICYSET_ID,

Line 17: insert into FND_OAM_DS_PSETS_B (

13: ) is
14: cursor C is select ROWID from FND_OAM_DS_PSETS_B
15: where POLICYSET_ID = X_POLICYSET_ID;
16: begin
17: insert into FND_OAM_DS_PSETS_B (
18: POLICYSET_ID,
19: CREATED_BY,
20: CREATION_DATE,
21: LAST_UPDATED_BY,

Line 90: from FND_OAM_DS_PSETS_B

86: CREATION_DATE,
87: LAST_UPDATED_BY,
88: LAST_UPDATE_DATE,
89: LAST_UPDATE_LOGIN
90: from FND_OAM_DS_PSETS_B
91: where POLICYSET_ID = X_POLICYSET_ID
92: for update of POLICYSET_ID nowait;
93: recinfo c%rowtype;
94:

Line 138: update FND_OAM_DS_PSETS_B set

134: X_LAST_UPDATE_DATE in DATE,
135: X_LAST_UPDATE_LOGIN in NUMBER
136: ) is
137: begin
138: update FND_OAM_DS_PSETS_B set
139: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
140: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
141: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
142: where POLICYSET_ID = X_POLICYSET_ID;

Line 174: delete from FND_OAM_DS_PSETS_B

170: if (sql%notfound) then
171: raise no_data_found;
172: end if;
173:
174: delete from FND_OAM_DS_PSETS_B
175: where POLICYSET_ID = X_POLICYSET_ID;
176:
177: if (sql%notfound) then
178: raise no_data_found;

Line 188: from FND_OAM_DS_PSETS_B B

184: begin
185: delete from FND_OAM_DS_PSETS_TL T
186: where not exists
187: (select NULL
188: from FND_OAM_DS_PSETS_B B
189: where B.POLICYSET_ID = T.POLICYSET_ID
190: );
191:
192: update FND_OAM_DS_PSETS_TL T set (