APPS.QPR_PR_SEGMENTS_PKG dependencies on QPR_PR_SEGMENTS_B

Line 20: cursor C is select ROWID from QPR_PR_SEGMENTS_B

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from QPR_PR_SEGMENTS_B
21: where PR_SEGMENT_ID = X_PR_SEGMENT_ID
22: ;
23: begin
24: insert into QPR_PR_SEGMENTS_B (

Line 24: insert into QPR_PR_SEGMENTS_B (

20: cursor C is select ROWID from QPR_PR_SEGMENTS_B
21: where PR_SEGMENT_ID = X_PR_SEGMENT_ID
22: ;
23: begin
24: insert into QPR_PR_SEGMENTS_B (
25: PR_SEGMENT_ID,
26: INSTANCE_ID,
27: DEFAULT_POLICY_ID,
28: POLICY_IMPORTANCE_CODE,

Line 118: from QPR_PR_SEGMENTS_B

114: POLICY_IMPORTANCE_CODE,
115: POLICY_PRECEDENCE,
116: PROGRAM_LOGIN_ID,
117: REQUEST_ID
118: from QPR_PR_SEGMENTS_B
119: where PR_SEGMENT_ID = X_PR_SEGMENT_ID
120: for update of PR_SEGMENT_ID nowait;
121: recinfo c%rowtype;
122:

Line 189: update QPR_PR_SEGMENTS_B set

185: X_LAST_UPDATED_BY in NUMBER,
186: X_LAST_UPDATE_LOGIN in NUMBER
187: ) is
188: begin
189: update QPR_PR_SEGMENTS_B set
190: INSTANCE_ID = X_INSTANCE_ID,
191: DEFAULT_POLICY_ID = X_DEFAULT_POLICY_ID,
192: POLICY_IMPORTANCE_CODE = X_POLICY_IMPORTANCE_CODE,
193: POLICY_PRECEDENCE = X_POLICY_PRECEDENCE,

Line 231: delete from QPR_PR_SEGMENTS_B

227: if (sql%notfound) then
228: raise no_data_found;
229: end if;
230:
231: delete from QPR_PR_SEGMENTS_B
232: where PR_SEGMENT_ID = X_PR_SEGMENT_ID;
233:
234: if (sql%notfound) then
235: raise no_data_found;

Line 245: from QPR_PR_SEGMENTS_B B

241: begin
242: delete from QPR_PR_SEGMENTS_TL T
243: where not exists
244: (select NULL
245: from QPR_PR_SEGMENTS_B B
246: where B.PR_SEGMENT_ID = T.PR_SEGMENT_ID
247: );
248:
249: update QPR_PR_SEGMENTS_TL T set (