APPS.FII_PL_PAGE_PKG dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 5: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, pl_graph_sql out NOCOPY VARCHAR2,

1: PACKAGE BODY fii_pl_page_pkg AS
2: /* $Header: FIIPLPGB.pls 120.5.12000000.2 2007/04/16 06:42:17 dhmehra ship $ */
3:
4: PROCEDURE get_pl_graph (
5: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, pl_graph_sql out NOCOPY VARCHAR2,
6: pl_graph_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
7:
8: sqlstmt VARCHAR2(30000);
9:

Line 21: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2 IS

17: END get_pl_graph;
18:
19:
20: FUNCTION get_pl_graph_val (
21: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL) return VARCHAR2 IS
22:
23: sqlstmt VARCHAR2(15000);
24:
25: p_aggrt_viewby_id VARCHAR2(30);

Line 122: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

118: END get_pl_graph_val;
119:
120:
121: PROCEDURE get_rev_trend (
122: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
123: expense_sum_sql out NOCOPY VARCHAR2,
124: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
125:
126: BEGIN

Line 136: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

132: expense_sum_output);
133: END get_rev_trend;
134:
135: PROCEDURE get_exp_trend (
136: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
137: expense_sum_sql out NOCOPY VARCHAR2,
138: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
139:
140: BEGIN

Line 150: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

146: expense_sum_output);
147: END get_exp_trend;
148:
149: PROCEDURE get_cogs_trend (
150: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
151: expense_sum_sql out NOCOPY VARCHAR2,
152: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
153:
154: BEGIN

Line 164: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

160: expense_sum_output);
161: END get_cogs_trend;
162:
163: PROCEDURE get_mar_trend (
164: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
165: expense_sum_sql out NOCOPY VARCHAR2,
166: expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
167:
168: BEGIN

Line 176: PROCEDURE get_expense_sum (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

172: expense_sum_sql,
173: expense_sum_output);
174: END get_mar_trend;
175:
176: PROCEDURE get_expense_sum (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
177: expense_sum_sql out NOCOPY VARCHAR2, expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
178: IS
179: sqlstmt VARCHAR2(32000);
180: l_pk VARCHAR2(30);

Line 496: PROCEDURE get_margin_sum (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

492: expense_sum_sql, expense_sum_output);
493: END get_expense_sum;
494:
495:
496: PROCEDURE get_margin_sum (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
497: expense_sum_sql out NOCOPY VARCHAR2, expense_sum_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
498: IS
499: sqlstmt VARCHAR2(32000);
500: l_pk VARCHAR2(30);

Line 860: PROCEDURE get_gross_margin( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

856: ---------------------------------------------------------------------------------
857: -- Following procedure is used to form PMV SQL, which is used to retrieve data
858: -- for Gross Margin Table portlet and Gross Margin Summary report
859:
860: PROCEDURE get_gross_margin( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
861: ,p_gross_margin_sql OUT NOCOPY VARCHAR2
862: ,p_gross_margin_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
863: )
864:

Line 1872: PROCEDURE get_oper_margin( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

1868: ---------------------------------------------------------------------------------
1869: -- Following procedure is used to form PMV SQL, which is used to retrieve data
1870: -- for Operating Margin Table portlet and Operating Margin Summary report
1871:
1872: PROCEDURE get_oper_margin( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
1873: ,p_oper_margin_sql OUT NOCOPY VARCHAR2
1874: ,p_oper_margin_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
1875: )
1876: