APPS.FUN_TRX_TYPES_PKG dependencies on FUN_TRX_TYPES_B

Line 37: cursor C is select ROWID from FUN_TRX_TYPES_B

33: X_LAST_UPDATE_DATE in DATE,
34: X_LAST_UPDATED_BY in NUMBER,
35: X_LAST_UPDATE_LOGIN in NUMBER
36: ) is
37: cursor C is select ROWID from FUN_TRX_TYPES_B
38: where TRX_TYPE_ID = X_TRX_TYPE_ID
39: ;
40: begin
41: insert into FUN_TRX_TYPES_B (

Line 41: insert into FUN_TRX_TYPES_B (

37: cursor C is select ROWID from FUN_TRX_TYPES_B
38: where TRX_TYPE_ID = X_TRX_TYPE_ID
39: ;
40: begin
41: insert into FUN_TRX_TYPES_B (
42: ATTRIBUTE3,
43: ATTRIBUTE4,
44: ATTRIBUTE5,
45: ATTRIBUTE6,

Line 191: from FUN_TRX_TYPES_B

187: VAT_TAXABLE_FLAG,
188: ALLOW_INTEREST_ACCRUAL_FLAG,
189: ATTRIBUTE1,
190: ATTRIBUTE2
191: from FUN_TRX_TYPES_B
192: where TRX_TYPE_ID = X_TRX_TYPE_ID
193: for update of TRX_TYPE_ID nowait;
194: recinfo c%rowtype;
195:

Line 311: update FUN_TRX_TYPES_B set

307: X_LAST_UPDATED_BY in NUMBER,
308: X_LAST_UPDATE_LOGIN in NUMBER
309: ) is
310: begin
311: update FUN_TRX_TYPES_B set
312: ATTRIBUTE3 = X_ATTRIBUTE3,
313: ATTRIBUTE4 = X_ATTRIBUTE4,
314: ATTRIBUTE5 = X_ATTRIBUTE5,
315: ATTRIBUTE6 = X_ATTRIBUTE6,

Line 369: delete from FUN_TRX_TYPES_B

365: if (sql%notfound) then
366: raise no_data_found;
367: end if;
368:
369: delete from FUN_TRX_TYPES_B
370: where TRX_TYPE_ID = X_TRX_TYPE_ID;
371:
372: if (sql%notfound) then
373: raise no_data_found;

Line 383: from FUN_TRX_TYPES_B B

379: begin
380: delete from FUN_TRX_TYPES_TL T
381: where not exists
382: (select NULL
383: from FUN_TRX_TYPES_B B
384: where B.TRX_TYPE_ID = T.TRX_TYPE_ID
385: );
386:
387: update FUN_TRX_TYPES_TL T set (