APPS.OKI_DBI_NSCM_BAL_PVT dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 21: p_param IN bis_pmv_page_parameter_tbl

17: , p_exp_type IN VARCHAR2)
18: RETURN VARCHAR2;
19:
20: FUNCTION get_bal_itd_sql (
21: p_param IN bis_pmv_page_parameter_tbl
22: , p_trend_flag in VARCHAR2)
23: RETURN VARCHAR2;
24:
25: FUNCTION get_bal_ytd_sql (

Line 26: p_param IN bis_pmv_page_parameter_tbl

22: , p_trend_flag in VARCHAR2)
23: RETURN VARCHAR2;
24:
25: FUNCTION get_bal_ytd_sql (
26: p_param IN bis_pmv_page_parameter_tbl
27: , p_trend_flag in VARCHAR2)
28: RETURN VARCHAR2;
29:
30: FUNCTION get_trend_query (

Line 36: FUNCTION get_xtd_sql ( p_param IN bis_pmv_page_parameter_tbl

32: ,p_ytd IN VARCHAR2
33: , p_xtd in VARCHAR2
34: ,p_cur_suffix in VARCHAR2)
35: RETURN VARCHAR2;
36: FUNCTION get_xtd_sql ( p_param IN bis_pmv_page_parameter_tbl
37: ,p_ptd in VARCHAR2
38: , p_trend_flag in VARCHAR2)
39: RETURN VARCHAR2;
40: Function get_xtd_sel_clause (p_ptd in VARCHAR2

Line 46: p_param IN bis_pmv_page_parameter_tbl

42: , p_trend_flag in VARCHAR2 )
43: RETURN VARCHAR2;
44: --------------------------------------------------------------------
45: PROCEDURE get_balance_sql (
46: p_param IN bis_pmv_page_parameter_tbl
47: , x_custom_sql OUT NOCOPY VARCHAR2
48: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)
49: IS
50:

Line 128: FUNCTION get_xtd_sql ( p_param IN bis_pmv_page_parameter_tbl

124:
125: END get_balance_sql;
126: --------------------------------------------------------------------
127:
128: FUNCTION get_xtd_sql ( p_param IN bis_pmv_page_parameter_tbl
129: ,p_ptd in VARCHAR2
130: , p_trend_flag in VARCHAR2)
131: RETURN VARCHAR2 IS
132:

Line 724: p_param IN bis_pmv_page_parameter_tbl

720: RETURN l_sel_clause;
721: END get_bal_sel_clause;
722:
723: FUNCTION get_bal_itd_sql (
724: p_param IN bis_pmv_page_parameter_tbl
725: , p_trend_flag in VARCHAR2)
726: RETURN VARCHAR2 IS
727: l_view_by VARCHAR2 (120);
728: l_view_by_col VARCHAR2 (120);

Line 812: p_param IN bis_pmv_page_parameter_tbl

808: END get_bal_itd_sql;
809:
810:
811: FUNCTION Get_bal_ytd_sql (
812: p_param IN bis_pmv_page_parameter_tbl
813: , p_trend_flag in VARCHAR2)
814: RETURN VARCHAR2 IS
815: l_view_by VARCHAR2 (120);
816: l_view_by_col VARCHAR2 (120);

Line 910: p_param IN bis_pmv_page_parameter_tbl

906: -- brrao added
907: *******************************************************************************/
908:
909: PROCEDURE get_balance_trend_sql (
910: p_param IN bis_pmv_page_parameter_tbl
911: , x_custom_sql OUT NOCOPY VARCHAR2
912: , x_custom_output OUT NOCOPY bis_query_attributes_tbl) IS
913:
914: -- Variables associated with the parameter portlet

Line 1066: p_param IN bis_pmv_page_parameter_tbl

1062: Balance Detail Select clause
1063: */
1064:
1065: PROCEDURE get_balance_detail_sql (
1066: p_param IN bis_pmv_page_parameter_tbl
1067: , x_custom_sql OUT NOCOPY VARCHAR2
1068: , x_custom_output OUT NOCOPY bis_query_attributes_tbl)
1069: IS
1070: