APPS.PA_CI_TYPES_PKG dependencies on PA_CI_TYPES_B

Line 44: cursor C is select ROWID from PA_CI_TYPES_B

40: X_LAST_UPDATE_DATE in DATE,
41: X_LAST_UPDATED_BY in NUMBER,
42: X_LAST_UPDATE_LOGIN in NUMBER
43: ) is
44: cursor C is select ROWID from PA_CI_TYPES_B
45: where CI_TYPE_ID = X_CI_TYPE_ID
46: ;
47: l_rowid rowid; --Added for bug#4565156
48: begin

Line 51: insert into PA_CI_TYPES_B (

47: l_rowid rowid; --Added for bug#4565156
48: begin
49:
50: l_rowid := x_rowid; --Added for bug#4565156
51: insert into PA_CI_TYPES_B (
52: CI_TYPE_ID,
53: CI_TYPE_CLASS_CODE,
54: AUTO_NUMBER_FLAG,
55: RESOLUTION_REQUIRED_FLAG,

Line 233: from PA_CI_TYPES_B

229: ATTRIBUTE12,
230: ATTRIBUTE13,
231: ATTRIBUTE14,
232: ATTRIBUTE15
233: from PA_CI_TYPES_B
234: where CI_TYPE_ID = X_CI_TYPE_ID
235: for update of CI_TYPE_ID nowait;
236: recinfo c%rowtype;
237:

Line 366: update PA_CI_TYPES_B set

362: X_LAST_UPDATED_BY in NUMBER,
363: X_LAST_UPDATE_LOGIN in NUMBER
364: ) is
365: begin
366: update PA_CI_TYPES_B set
367: CI_TYPE_CLASS_CODE = X_CI_TYPE_CLASS_CODE,
368: AUTO_NUMBER_FLAG = X_AUTO_NUMBER_FLAG,
369: RESOLUTION_REQUIRED_FLAG = X_RESOLUTION_REQUIRED_FLAG,
370: APPROVAL_REQUIRED_FLAG = X_APPROVAL_REQUIRED_FLAG,

Line 431: delete from PA_CI_TYPES_B

427: if (sql%notfound) then
428: raise no_data_found;
429: end if;
430:
431: delete from PA_CI_TYPES_B
432: where CI_TYPE_ID = X_CI_TYPE_ID;
433:
434: if (sql%notfound) then
435: raise no_data_found;

Line 445: from PA_CI_TYPES_B B

441: begin
442: delete from PA_CI_TYPES_TL T
443: where not exists
444: (select NULL
445: from PA_CI_TYPES_B B
446: where B.CI_TYPE_ID = T.CI_TYPE_ID
447: );
448:
449: update PA_CI_TYPES_TL T set (