APPS.OKI_DBI_NSCM_ACT_PVT dependencies on FND_PROFILE

Line 57: l_balance_logic := nvl(fnd_profile.value('OKI_BAL_IDENT'),'CONTRDATE');

53:
54: l_filter_where := ' (ABS(oki_measure_1)+ABS(oki_pmeasure_1)+ABS(oki_measure_3)) <> 0';
55:
56: /* Balance logic for OI */
57: l_balance_logic := nvl(fnd_profile.value('OKI_BAL_IDENT'),'CONTRDATE');
58:
59: IF (l_balance_logic = 'EVENTDATE') THEN
60: --{
61:

Line 251: l_balance_logic := nvl(fnd_profile.value('OKI_BAL_IDENT'),'CONTRDATE');

247: l_balance_logic VARCHAR2(10);
248: BEGIN
249:
250: /* Balance logic for OI */
251: l_balance_logic := nvl(fnd_profile.value('OKI_BAL_IDENT'),'CONTRDATE');
252:
253: l_viewby_select := OKI_DBI_UTIL_PVT.get_viewby_select_clause(p_view_by_dim, 'SRM', '6.0');
254:
255: -- when view by is Salesrep OKI_DBI_SCM_ACT_DTL_RPT

Line 484: l_balance_logic := nvl(fnd_profile.value('OKI_BAL_IDENT'),'CONTRDATE');

480: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
481: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
482:
483: /* Balance logic for OI */
484: l_balance_logic := nvl(fnd_profile.value('OKI_BAL_IDENT'),'CONTRDATE');
485:
486: IF (l_balance_logic = 'EVENTDATE') THEN
487: --{
488: OKI_DBI_UTIL_PVT.process_parameters (p_param => p_param

Line 646: l_balance_logic := nvl(fnd_profile.value('OKI_BAL_IDENT'),'CONTRDATE');

642:
643: BEGIN
644:
645: /* Balance logic for OI */
646: l_balance_logic := nvl(fnd_profile.value('OKI_BAL_IDENT'),'CONTRDATE');
647:
648: -- OKI_MEASURE_1 : Total Activated Value
649:
650: IF (l_balance_logic = 'EVENTDATE') THEN