APPS.FND_OAM_DS_POLICIES_PKG dependencies on FND_OAM_DS_POLICIES_B

Line 16: cursor C is select ROWID from FND_OAM_DS_POLICIES_B

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

Line 19: insert into FND_OAM_DS_POLICIES_B (

15: ) is
16: cursor C is select ROWID from FND_OAM_DS_POLICIES_B
17: where POLICY_ID = X_POLICY_ID;
18: begin
19: insert into FND_OAM_DS_POLICIES_B (
20: POLICY_ID,
21: START_DATE,
22: END_DATE,
23: CREATED_BY,

Line 100: from FND_OAM_DS_POLICIES_B

96: CREATION_DATE,
97: LAST_UPDATED_BY,
98: LAST_UPDATE_DATE,
99: LAST_UPDATE_LOGIN
100: from FND_OAM_DS_POLICIES_B
101: where POLICY_ID = X_POLICY_ID
102: for update of POLICY_ID nowait;
103: recinfo c%rowtype;
104:

Line 160: update FND_OAM_DS_POLICIES_B set

156: X_LAST_UPDATE_DATE in DATE,
157: X_LAST_UPDATE_LOGIN in NUMBER
158: ) is
159: begin
160: update FND_OAM_DS_POLICIES_B set
161: START_DATE = X_START_DATE,
162: END_DATE =X_END_DATE,
163: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
164: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 198: delete from FND_OAM_DS_POLICIES_B

194: if (sql%notfound) then
195: raise no_data_found;
196: end if;
197:
198: delete from FND_OAM_DS_POLICIES_B
199: where POLICY_ID = X_POLICY_ID;
200:
201: if (sql%notfound) then
202: raise no_data_found;

Line 212: from FND_OAM_DS_POLICIES_B B

208: begin
209: delete from FND_OAM_DS_POLICIES_TL T
210: where not exists
211: (select NULL
212: from FND_OAM_DS_POLICIES_B B
213: where B.POLICY_ID = T.POLICY_ID
214: );
215:
216: update FND_OAM_DS_POLICIES_TL T set (