APPS.XLA_TAB_ACCT_TYPES_F_PKG dependencies on XLA_TAB_ACCT_TYPES_B

Line 84: cursor C is select ROWID from XLA_TAB_ACCT_TYPES_B

80: X_LAST_UPDATE_DATE in DATE,
81: X_LAST_UPDATED_BY in NUMBER,
82: X_LAST_UPDATE_LOGIN in NUMBER
83: ) is
84: cursor C is select ROWID from XLA_TAB_ACCT_TYPES_B
85: where APPLICATION_ID = X_APPLICATION_ID
86: and ACCOUNT_TYPE_CODE = X_ACCOUNT_TYPE_CODE
87: ;
88: begin

Line 89: insert into XLA_TAB_ACCT_TYPES_B (

85: where APPLICATION_ID = X_APPLICATION_ID
86: and ACCOUNT_TYPE_CODE = X_ACCOUNT_TYPE_CODE
87: ;
88: begin
89: insert into XLA_TAB_ACCT_TYPES_B (
90: APPLICATION_ID,
91: ACCOUNT_TYPE_CODE,
92: ENABLED_FLAG,
93: RULE_ASSIGNMENT_CODE,

Line 180: from XLA_TAB_ACCT_TYPES_B

176: ENABLED_FLAG,
177: RULE_ASSIGNMENT_CODE,
178: COMPILE_STATUS_CODE,
179: OBJECT_NAME_AFFIX
180: from XLA_TAB_ACCT_TYPES_B
181: where APPLICATION_ID = X_APPLICATION_ID
182: and ACCOUNT_TYPE_CODE = X_ACCOUNT_TYPE_CODE
183: for update of APPLICATION_ID nowait;
184: recinfo c%rowtype;

Line 256: update XLA_TAB_ACCT_TYPES_B set

252: X_LAST_UPDATED_BY in NUMBER,
253: X_LAST_UPDATE_LOGIN in NUMBER
254: ) is
255: begin
256: update XLA_TAB_ACCT_TYPES_B set
257: ENABLED_FLAG = X_ENABLED_FLAG,
258: RULE_ASSIGNMENT_CODE = X_RULE_ASSIGNMENT_CODE,
259: COMPILE_STATUS_CODE = X_COMPILE_STATUS_CODE,
260: OBJECT_NAME_AFFIX = X_OBJECT_NAME_AFFIX,

Line 306: delete from XLA_TAB_ACCT_TYPES_B

302: if (sql%notfound) then
303: raise no_data_found;
304: end if;
305:
306: delete from XLA_TAB_ACCT_TYPES_B
307: where APPLICATION_ID = X_APPLICATION_ID
308: and ACCOUNT_TYPE_CODE = X_ACCOUNT_TYPE_CODE;
309:
310: if (sql%notfound) then

Line 328: from XLA_TAB_ACCT_TYPES_B B

324: begin
325: delete from XLA_TAB_ACCT_TYPES_TL T
326: where not exists
327: (select NULL
328: from XLA_TAB_ACCT_TYPES_B B
329: where B.APPLICATION_ID = T.APPLICATION_ID
330: and B.ACCOUNT_TYPE_CODE = T.ACCOUNT_TYPE_CODE
331: );
332: