APPS.PRP_TOKENS_PKG dependencies on PRP_TOKENS_B

Line 41: cursor C is select ROWID from PRP_TOKENS_B

37: X_LAST_UPDATE_DATE in DATE,
38: X_LAST_UPDATED_BY in NUMBER,
39: X_LAST_UPDATE_LOGIN in NUMBER
40: ) is
41: cursor C is select ROWID from PRP_TOKENS_B
42: where TOKEN_ID = X_TOKEN_ID
43: ;
44: begin
45: insert into PRP_TOKENS_B (

Line 45: insert into PRP_TOKENS_B (

41: cursor C is select ROWID from PRP_TOKENS_B
42: where TOKEN_ID = X_TOKEN_ID
43: ;
44: begin
45: insert into PRP_TOKENS_B (
46: ATTRIBUTE15,
47: TOKEN_ID,
48: OBJECT_VERSION_NUMBER,
49: TOKEN_CODE,

Line 214: from PRP_TOKENS_B

210: ATTRIBUTE11,
211: ATTRIBUTE12,
212: ATTRIBUTE13,
213: ATTRIBUTE14
214: from PRP_TOKENS_B
215: where TOKEN_ID = X_TOKEN_ID
216: for update of TOKEN_ID nowait;
217: recinfo c%rowtype;
218:

Line 346: update PRP_TOKENS_B set

342: X_LAST_UPDATED_BY in NUMBER,
343: X_LAST_UPDATE_LOGIN in NUMBER
344: ) is
345: begin
346: update PRP_TOKENS_B set
347: ATTRIBUTE15 = X_ATTRIBUTE15,
348: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
349: TOKEN_CODE = X_TOKEN_CODE,
350: TOKEN_TYPE = X_TOKEN_TYPE,

Line 409: delete from PRP_TOKENS_B

405: if (sql%notfound) then
406: raise no_data_found;
407: end if;
408:
409: delete from PRP_TOKENS_B
410: where TOKEN_ID = X_TOKEN_ID;
411:
412: if (sql%notfound) then
413: raise no_data_found;

Line 423: from PRP_TOKENS_B B

419: begin
420: delete from PRP_TOKENS_TL T
421: where not exists
422: (select NULL
423: from PRP_TOKENS_B B
424: where B.TOKEN_ID = T.TOKEN_ID
425: );
426:
427: update PRP_TOKENS_TL T set (