DBA Data[Home] [Help]

APPS.FII_FINANCIAL_DIMENSION_PKG dependencies on FII_SLG_ASSIGNMENTS

Line 288: where exists (select 'x' from fii_source_ledger_groups x, fii_slg_assignments y

284: l_i number := 0;
285:
286: cursor forDBI is
287: select 'x' from dual
288: where exists (select 'x' from fii_source_ledger_groups x, fii_slg_assignments y
289: where x.source_ledger_group_id = y.source_ledger_group_id and
290: y.chart_of_accounts_id = p_chart_of_accounts_id and
291: x.usage_code='DBI');
292:

Line 302: fii_slg_assignments

298: if p_event = 'D' then
299: delete from fii_dim_mapping_rules
300: where chart_of_accounts_id = p_chart_of_accounts_id and
301: not exists(select 'x' from
302: fii_slg_assignments
303: where chart_of_accounts_id = p_chart_of_accounts_id);
304:
305: fii_change_log_pkg.set_recollection_for_fii(x_status,
306: x_message_count,

Line 446: | fii_slg_assignments. |

442: | je inclusion rules need to be deleted). |
443: | HISTORY |
444: | 21-JUL-03 H.Chung Created |
445: | 05-APR-05 MManasse Bug 4277376: Added update of je_rule_set_id to null in|
446: | fii_slg_assignments. |
447: | |
448: *****************************************************************************/
449: PROCEDURE DeleteJeInclusionRules(p_je_rule_set_id IN NUMBER,
450: x_status OUT nocopy VARCHAR2,

Line 464: UPDATE FII_SLG_ASSIGNMENTS

460:
461: DELETE FROM GL_JE_INCLUSION_RULES
462: WHERE je_rule_set_id = p_je_rule_set_id;
463:
464: UPDATE FII_SLG_ASSIGNMENTS
465: SET JE_RULE_SET_ID = NULL WHERE JE_RULE_SET_ID = p_je_rule_set_id;
466:
467: x_status := FND_API.G_RET_STS_SUCCESS;
468: