DBA Data[Home] [Help]

APPS.POA_DBI_INV_PKG dependencies on POA_DBI_CALENDAR_PKG

Line 83: l_prev_prev_as_of_date := poa_dbi_calendar_pkg.previous_period_asof_date(l_prev_as_of_date, l_xtd, l_comparison_type);

79: p_version => '6.0',
80: p_role => 'COM',
81: p_mv_set => 'API');
82:
83: l_prev_prev_as_of_date := poa_dbi_calendar_pkg.previous_period_asof_date(l_prev_as_of_date, l_xtd, l_comparison_type);
84: IF(l_sec_context = 'OU' or l_sec_context = 'SUPPLIER') THEN
85: l_to_date_type := 'RLX';
86: poa_dbi_util_pkg.add_column(l_col_tbl, 'amount_' || l_cur_suffix, 'amount','Y',p_to_date_type => l_to_date_type);
87: ELSE

Line 166: l_prev_prev_as_of_date := poa_dbi_calendar_pkg.previous_period_asof_date(l_prev_as_of_date, l_xtd, l_comparison_type);

162: p_mv_set => 'APIB');
163: end if;
164:
165:
166: l_prev_prev_as_of_date := poa_dbi_calendar_pkg.previous_period_asof_date(l_prev_as_of_date, l_xtd, l_comparison_type);
167:
168: poa_dbi_util_pkg.add_column(l_col_tbl, 'amount_' || l_cur_suffix, 'amount','Y',poa_dbi_util_pkg.PREV_PREV);
169:
170: IF(l_view_by='ITEM+ENI_ITEM_PO_CAT') THEN