APPS.FII_AR_BILL_ACT_TREND_PKG dependencies on FII_AR_UTIL_PKG

Line 10: IF (fii_ar_util_pkg.g_page_period_type = 'FII_TIME_WEEK') THEN

6:
7: FUNCTION get_view_by return VARCHAR2 IS
8: BEGIN
9:
10: IF (fii_ar_util_pkg.g_page_period_type = 'FII_TIME_WEEK') THEN
11: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_WEEK');
12: ELSIF (fii_ar_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD') THEN
13: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_MONTH');
14: ELSIF (fii_ar_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR') THEN

Line 12: ELSIF (fii_ar_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD') THEN

8: BEGIN
9:
10: IF (fii_ar_util_pkg.g_page_period_type = 'FII_TIME_WEEK') THEN
11: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_WEEK');
12: ELSIF (fii_ar_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD') THEN
13: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_MONTH');
14: ELSIF (fii_ar_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR') THEN
15: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_QUARTER');
16: ELSE

Line 14: ELSIF (fii_ar_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR') THEN

10: IF (fii_ar_util_pkg.g_page_period_type = 'FII_TIME_WEEK') THEN
11: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_WEEK');
12: ELSIF (fii_ar_util_pkg.g_page_period_type = 'FII_TIME_ENT_PERIOD') THEN
13: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_MONTH');
14: ELSIF (fii_ar_util_pkg.g_page_period_type = 'FII_TIME_ENT_QTR') THEN
15: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_QUARTER');
16: ELSE
17: return FND_MESSAGE.GET_STRING('FII','FII_AR_DBI_YEAR');
18: END IF;

Line 45: fii_ar_util_pkg.reset_globals;

41: BEGIN
42:
43:
44: /* Reset Global Variables */
45: fii_ar_util_pkg.reset_globals;
46:
47: /* Get the parameters that the user has selected */
48: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
49:

Line 48: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);

44: /* Reset Global Variables */
45: fii_ar_util_pkg.reset_globals;
46:
47: /* Get the parameters that the user has selected */
48: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
49:
50: /* Populate the dimension combination(s) that the user has access to */
51: fii_ar_util_pkg.populate_summary_gt_tables;
52:

Line 51: fii_ar_util_pkg.populate_summary_gt_tables;

47: /* Get the parameters that the user has selected */
48: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
49:
50: /* Populate the dimension combination(s) that the user has access to */
51: fii_ar_util_pkg.populate_summary_gt_tables;
52:
53:
54:
55: IF (fii_ar_util_pkg.g_party_id <> '-111') THEN

Line 55: IF (fii_ar_util_pkg.g_party_id <> '-111') THEN

51: fii_ar_util_pkg.populate_summary_gt_tables;
52:
53:
54:
55: IF (fii_ar_util_pkg.g_party_id <> '-111') THEN
56: l_child_party_where := ' AND f.party_id = cal.party_id ';
57: END IF;
58:
59:

Line 60: IF fii_ar_util_pkg.g_industry_id <> '-111' THEN

56: l_child_party_where := ' AND f.party_id = cal.party_id ';
57: END IF;
58:
59:
60: IF fii_ar_util_pkg.g_industry_id <> '-111' THEN
61:
62: l_industry_where := ' and f.class_code=cal.class_code and f.class_category=cal.class_category';
63:
64: END IF;

Line 73: l_period_type := fii_ar_util_pkg.g_page_period_type;

69: l_where_clause := l_child_party_where||l_org_where||l_industry_where;
70:
71: /* Find out which time dimension level table needs to be hit.
72: This is based on the period type chosen */
73: l_period_type := fii_ar_util_pkg.g_page_period_type;
74:
75:
76: IF ( l_period_type = 'FII_TIME_WEEK') THEN
77: l_time_dim_ltc := 'FII_TIME_WEEK';

Line 125: IF fii_ar_util_pkg.g_time_comp = 'SEQUENTIAL' THEN

121: +f.br_ba_count+f.dep_ba_count + f.cm_ba_count
122: ELSE
123: NULL
124: END FII_AR_BILL_ACT_COUNT, ';
125: IF fii_ar_util_pkg.g_time_comp = 'SEQUENTIAL' THEN
126: l_sql_stmt := l_sql_stmt || 'NULL FII_AR_BILL_ACT_AMT_PRIOR,
127: NULL FII_AR_BILL_ACT_COUNT_PRIOR ';
128: l_start_date := ' :SD_PRIOR ';
129: ELSE

Line 146: l_sql_stmt:= l_sql_stmt || ' FROM fii_ar_billing_act'||fii_ar_util_pkg.g_cust_suffix ||'_mv'|| fii_ar_util_pkg.g_curr_suffix ||' f,

142: END IF;
143: l_start_date := ' :SD_PRIOR_PRIOR ';
144: END IF;
145:
146: l_sql_stmt:= l_sql_stmt || ' FROM fii_ar_billing_act'||fii_ar_util_pkg.g_cust_suffix ||'_mv'|| fii_ar_util_pkg.g_curr_suffix ||' f,
147: (SELECT /*+no_merge INDEX(cal FII_TIME_STRUCTURES_N1) leading(gt) cardinality(gt 1)*/ *
148: FROM fii_ar_summary_gt gt,
149: fii_time_structures cal,
150: '||l_time_dim_ltc||' per

Line 156: IF fii_ar_util_pkg.g_as_of_date = fii_ar_util_pkg.g_curr_per_end THEN

152: BITAND(cal.record_type_id, :BITAND) = :BITAND
153: and per.end_date = cal.report_date
154: and per.start_date < ';
155:
156: IF fii_ar_util_pkg.g_as_of_date = fii_ar_util_pkg.g_curr_per_end THEN
157: l_end_date := ' :ASOF_DATE';
158: ELSE
159: l_end_date := ' :CURR_PERIOD_START';
160: END IF;

Line 168: IF fii_ar_util_pkg.g_as_of_date <> fii_ar_util_pkg.g_curr_per_end THEN

164: l_sql_stmt := l_sql_stmt ||' WHERE f.time_id=cal.time_id
165: AND f.period_type_id=cal.period_type_id ' ||l_where_clause;
166:
167:
168: IF fii_ar_util_pkg.g_as_of_date <> fii_ar_util_pkg.g_curr_per_end THEN
169: l_sql_stmt := l_sql_stmt||' UNION ALL
170: SELECT per.name NAME,
171: per.end_date END_DATE,
172: per.start_date START_DATE,

Line 181: fii_ar_billing_act'||fii_ar_util_pkg.g_cust_suffix ||'_mv'|| fii_ar_util_pkg.g_curr_suffix ||' f,

177: +f.br_ba_count+f.dep_ba_count + f.cm_ba_count FII_AR_BILL_ACT_COUNT,
178: NULL FII_AR_BILL_ACT_AMT_PRIOR,
179: NULL FII_AR_BILL_ACT_COUNT_PRIOR
180: FROM '||l_time_dim_ltc ||' per,
181: fii_ar_billing_act'||fii_ar_util_pkg.g_cust_suffix ||'_mv'|| fii_ar_util_pkg.g_curr_suffix ||' f,
182: ( SELECT /*+no_merge leading(gt) cardinality(gt 1)*/ *
183: FROM fii_time_structures cal,
184: fii_ar_summary_gt gt
185: WHERE cal.report_date = :ASOF_DATE

Line 200: fii_ar_util_pkg.bind_variable(l_sql_stmt, p_page_parameter_tbl, bill_act_trend_sql, bill_trend_output);

196: GROUP BY per.name,per.end_date,per.start_date
197: ORDER BY per.start_date ';
198:
199: /* Pass back the pmv sql along with bind variables to PMV */
200: fii_ar_util_pkg.bind_variable(l_sql_stmt, p_page_parameter_tbl, bill_act_trend_sql, bill_trend_output);
201:
202:
203:
204: