[Home] [Help]
43: X_LAST_UPDATE_LOGIN in NUMBER
44: ) is
45:
46: cursor C is
47: select ROWID from XLA_TAB_ACCT_DEFS_B
48: where APPLICATION_ID = X_APPLICATION_ID
49: and AMB_CONTEXT_CODE = X_AMB_CONTEXT_CODE
50: and ACCOUNT_DEFINITION_TYPE_CODE = X_ACCOUNT_DEFINITION_TYPE_CODE
51: and ACCOUNT_DEFINITION_CODE = X_ACCOUNT_DEFINITION_CODE
52: ;
53:
54: BEGIN
55:
56: insert into XLA_TAB_ACCT_DEFS_B (
57: AMB_CONTEXT_CODE,
58: REQUEST_ID,
59: APPLICATION_ID,
60: ACCOUNT_DEFINITION_TYPE_CODE,
160: CHART_OF_ACCOUNTS_ID,
161: COMPILE_STATUS_CODE,
162: LOCKING_STATUS_FLAG,
163: ENABLED_FLAG
164: from XLA_TAB_ACCT_DEFS_B
165: where APPLICATION_ID = X_APPLICATION_ID
166: and AMB_CONTEXT_CODE = X_AMB_CONTEXT_CODE
167: and ACCOUNT_DEFINITION_TYPE_CODE = X_ACCOUNT_DEFINITION_TYPE_CODE
168: and ACCOUNT_DEFINITION_CODE = X_ACCOUNT_DEFINITION_CODE
246: ) is
247:
248: BEGIN
249:
250: UPDATE XLA_TAB_ACCT_DEFS_B set
251: REQUEST_ID = X_REQUEST_ID,
252: CHART_OF_ACCOUNTS_ID = X_CHART_OF_ACCOUNTS_ID,
253: COMPILE_STATUS_CODE = X_COMPILE_STATUS_CODE,
254: LOCKING_STATUS_FLAG = X_LOCKING_STATUS_FLAG,
309: if (sql%notfound) then
310: raise no_data_found;
311: end if;
312:
313: delete from XLA_TAB_ACCT_DEFS_B
314: where APPLICATION_ID = X_APPLICATION_ID
315: and AMB_CONTEXT_CODE = X_AMB_CONTEXT_CODE
316: and ACCOUNT_DEFINITION_TYPE_CODE = X_ACCOUNT_DEFINITION_TYPE_CODE
317: and ACCOUNT_DEFINITION_CODE = X_ACCOUNT_DEFINITION_CODE;
334: BEGIN
335: delete from XLA_TAB_ACCT_DEFS_TL T
336: where not exists
337: (select NULL
338: from XLA_TAB_ACCT_DEFS_B B
339: where B.APPLICATION_ID = T.APPLICATION_ID
340: and B.AMB_CONTEXT_CODE = T.AMB_CONTEXT_CODE
341: and B.ACCOUNT_DEFINITION_TYPE_CODE = T.ACCOUNT_DEFINITION_TYPE_CODE
342: and B.ACCOUNT_DEFINITION_CODE = T.ACCOUNT_DEFINITION_CODE