APPS.QP_CURRENCY_LISTS_PKG dependencies on QP_CURRENCY_LISTS_B

Line 33: cursor C is select ROWID from QP_CURRENCY_LISTS_B

29: X_LAST_UPDATED_BY in NUMBER,
30: X_LAST_UPDATE_LOGIN in NUMBER
31: ) is
32: l_rowid VARCHAR2(240);
33: cursor C is select ROWID from QP_CURRENCY_LISTS_B
34: where CURRENCY_HEADER_ID = X_CURRENCY_HEADER_ID
35: ;
36: begin
37: insert into QP_CURRENCY_LISTS_B (

Line 37: insert into QP_CURRENCY_LISTS_B (

33: cursor C is select ROWID from QP_CURRENCY_LISTS_B
34: where CURRENCY_HEADER_ID = X_CURRENCY_HEADER_ID
35: ;
36: begin
37: insert into QP_CURRENCY_LISTS_B (
38: CURRENCY_HEADER_ID,
39: BASE_CURRENCY_CODE,
40: REQUEST_ID,
41: CONTEXT,

Line 172: from QP_CURRENCY_LISTS_B

168: ATTRIBUTE12,
169: ATTRIBUTE13,
170: ATTRIBUTE14,
171: ATTRIBUTE15
172: from QP_CURRENCY_LISTS_B
173: where CURRENCY_HEADER_ID = X_CURRENCY_HEADER_ID
174: for update of CURRENCY_HEADER_ID nowait;
175: recinfo c%rowtype;
176:

Line 279: update QP_CURRENCY_LISTS_B set

275: X_LAST_UPDATED_BY in NUMBER,
276: X_LAST_UPDATE_LOGIN in NUMBER
277: ) is
278: begin
279: update QP_CURRENCY_LISTS_B set
280: BASE_CURRENCY_CODE = X_BASE_CURRENCY_CODE,
281: REQUEST_ID = X_REQUEST_ID,
282: CONTEXT = X_CONTEXT,
283: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 333: delete from QP_CURRENCY_LISTS_B

329: if (sql%notfound) then
330: raise no_data_found;
331: end if;
332:
333: delete from QP_CURRENCY_LISTS_B
334: where CURRENCY_HEADER_ID = X_CURRENCY_HEADER_ID;
335:
336: if (sql%notfound) then
337: raise no_data_found;

Line 347: from QP_CURRENCY_LISTS_B B

343: begin
344: delete from QP_CURRENCY_LISTS_TL T
345: where not exists
346: (select NULL
347: from QP_CURRENCY_LISTS_B B
348: where B.CURRENCY_HEADER_ID = T.CURRENCY_HEADER_ID
349: );
350:
351: update QP_CURRENCY_LISTS_TL T set (