APPS.QPR_POLICIES_PKG dependencies on QPR_POLICIES_B

Line 17: cursor C is select ROWID from QPR_POLICIES_B

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

Line 21: insert into QPR_POLICIES_B (

17: cursor C is select ROWID from QPR_POLICIES_B
18: where POLICY_ID = X_POLICY_ID
19: ;
20: begin
21: insert into QPR_POLICIES_B (
22: POLICY_ID,
23: ACTIVE_FLAG,
24: PROGRAM_LOGIN_ID,
25: REQUEST_ID,

Line 102: from QPR_POLICIES_B

98: cursor c is select
99: ACTIVE_FLAG,
100: PROGRAM_LOGIN_ID,
101: REQUEST_ID
102: from QPR_POLICIES_B
103: where POLICY_ID = X_POLICY_ID
104: for update of POLICY_ID nowait;
105: recinfo c%rowtype;
106:

Line 162: update QPR_POLICIES_B set

158: X_LAST_UPDATED_BY in NUMBER,
159: X_LAST_UPDATE_LOGIN in NUMBER
160: ) is
161: begin
162: update QPR_POLICIES_B set
163: ACTIVE_FLAG = X_ACTIVE_FLAG,
164: PROGRAM_LOGIN_ID = X_PROGRAM_LOGIN_ID,
165: REQUEST_ID = X_REQUEST_ID,
166: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 201: delete from QPR_POLICIES_B

197: if (sql%notfound) then
198: raise no_data_found;
199: end if;
200:
201: delete from QPR_POLICIES_B
202: where POLICY_ID = X_POLICY_ID;
203:
204: if (sql%notfound) then
205: raise no_data_found;

Line 215: from QPR_POLICIES_B B

211: begin
212: delete from QPR_POLICIES_TL T
213: where not exists
214: (select NULL
215: from QPR_POLICIES_B B
216: where B.POLICY_ID = T.POLICY_ID
217: );
218:
219: update QPR_POLICIES_TL T set (