APPS.FII_GL_COST_CENTER_PKG2 dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 4: FUNCTION get_revexp_cc (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, l_fin_type IN VARCHAR2) return VARCHAR2

1: PACKAGE BODY fii_gl_cost_center_pkg2 AS
2: /* $Header: FIIGLC2B.pls 120.66 2006/04/22 00:23:57 mmanasse noship $ */
3:
4: FUNCTION get_revexp_cc (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, l_fin_type IN VARCHAR2) return VARCHAR2
5: IS
6:
7: revexp_cc_rec BIS_QUERY_ATTRIBUTES;
8: sqlstmt VARCHAR2(32000);

Line 161: PROCEDURE get_exp_by_cat (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

157: return sqlstmt;
158:
159: END get_revexp_cc;
160:
161: PROCEDURE get_exp_by_cat (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
162: exp_by_cat_sql out NOCOPY VARCHAR2,
163: exp_by_cat_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
164: IS
165:

Line 335: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, exp_cc_sql out NOCOPY VARCHAR2,

331: --
332:
333:
334: PROCEDURE get_exp_cc (
335: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, exp_cc_sql out NOCOPY VARCHAR2,
336: exp_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
337: l_fin_category VARCHAR2(2);
338: sqlstmt VARCHAR2(32000);
339: BEGIN

Line 350: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, rev_cc_sql out NOCOPY VARCHAR2,

346:
347: END get_exp_cc;
348:
349: PROCEDURE get_rev_cc (
350: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, rev_cc_sql out NOCOPY VARCHAR2,
351: rev_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
352: l_fin_category VARCHAR2(1);
353: sqlstmt VARCHAR2(32000);
354: BEGIN

Line 366: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, cgs_cc_sql out NOCOPY VARCHAR2,

362:
363: END get_rev_cc;
364:
365: PROCEDURE get_cogs_cc (
366: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, cgs_cc_sql out NOCOPY VARCHAR2,
367: cgs_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
368: l_fin_category VARCHAR2(3);
369: sqlstmt VARCHAR2(32000);
370: BEGIN

Line 382: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

378: END get_cogs_cc;
379:
380:
381: PROCEDURE get_cont_marg(
382: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
383: cont_marg_sql out NOCOPY VARCHAR2,
384: cont_marg_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL, p_opera_marg IN Char DEFAULT 'N') IS
385:
386: sqlstmt VARCHAR2(32000);

Line 630: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

626: --* Procedure added by Ilavenil.
627: --* Procedure is called by OPERATING MARGIN
628:
629: PROCEDURE get_opera_marg(
630: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
631: cont_marg_sql out NOCOPY VARCHAR2,
632: cont_marg_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
633: Begin
634: get_cont_marg(p_page_parameter_tbl, cont_marg_sql, cont_marg_output, 'Y');