DBA Data[Home] [Help]

APPS.FII_GL_COST_CENTER_PKG2 dependencies on BIS_QUERY_ATTRIBUTES

Line 7: revexp_cc_rec BIS_QUERY_ATTRIBUTES;

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);
9: l_prior_or_budget VARCHAR2(5000);
10: l_hint VARCHAR2(300);
11: l_url VARCHAR2(300);

Line 163: exp_by_cat_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

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:
166: sqlstmt VARCHAR2(32000);
167: l_time_comp VARCHAR2(20);

Line 336: exp_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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
340:

Line 351: rev_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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
355:

Line 367: cgs_cc_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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
371:

Line 384: cont_marg_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL, p_opera_marg IN Char DEFAULT 'N') IS

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);
387: l_prior_or_budget VARCHAR2(10000);
388: l_hint VARCHAR2(300);

Line 632: cont_marg_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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');
635: End get_opera_marg;
636: