APPS.BIL_BI_UTIL_PKG dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 16: PROCEDURE GET_CURR_START_DATE (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

12: ,x_parameter_valid OUT NOCOPY BOOLEAN );
13:
14: PROCEDURE GET_CURR_DATE(x_curr_date OUT NOCOPY DATE);
15:
16: PROCEDURE GET_CURR_START_DATE (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
17: p_as_of_date IN DATE,
18: p_period_type IN VARCHAR2,
19: x_curr_start_date OUT NOCOPY DATE);
20:

Line 35: PROCEDURE GET_LATEST_SNAP_DATE(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

31: x_calendar_id OUT NOCOPY VARCHAR2,
32: x_curr_date OUT NOCOPY DATE,
33: x_fii_struct OUT NOCOPY VARCHAR2);
34:
35: PROCEDURE GET_LATEST_SNAP_DATE(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
36: p_as_of_date IN DATE,
37: p_period_type IN VARCHAR2,
38: x_snapshot_date OUT NOCOPY DATE);
39:

Line 45: PROCEDURE GET_PAGE_PARAMS (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

41: PROCEDURE GET_OTHER_PROFILES(x_DebugMode OUT NOCOPY VARCHAR2);
42:
43:
44:
45: PROCEDURE GET_PAGE_PARAMS (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
46: p_region_id IN VARCHAR2,
47: x_as_of_date OUT NOCOPY DATE,
48: x_comp_type OUT NOCOPY VARCHAR2,
49: x_conv_rate_selected OUT NOCOPY VARCHAR2,

Line 76: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

72: x_where_clause OUT NOCOPY VARCHAR2);
73:
74: PROCEDURE GET_TREND_PARAMS (p_comp_type IN VARCHAR2,
75: p_curr_as_of_date IN DATE,
76: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
77: p_page_period_type IN VARCHAR2,
78: x_column_name OUT NOCOPY VARCHAR2,
79: x_curr_eff_end_date OUT NOCOPY DATE,
80: x_curr_start_date OUT NOCOPY DATE,

Line 85: FUNCTION isUserCurrency (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL) RETURN BOOLEAN;

81: x_prev_eff_end_date OUT NOCOPY DATE,
82: x_prev_start_date OUT NOCOPY DATE,
83: x_table_name OUT NOCOPY VARCHAR2);
84:
85: FUNCTION isUserCurrency (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL) RETURN BOOLEAN;
86:
87: FUNCTION GET_UNASSIGNED_PC RETURN VARCHAR2;
88:
89: FUNCTION isLeafNode (p_prodcat_id IN NUMBER) RETURN BOOLEAN;

Line 118: FUNCTION GET_LBL_SGFST (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL) RETURN VARCHAR2;

114: p_resource_id IN VARCHAR2
115: ) RETURN VARCHAR2;
116:
117:
118: FUNCTION GET_LBL_SGFST (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL) RETURN VARCHAR2;
119:
120:
121: PROCEDURE GET_PIPE_SNAP_DATE( p_as_of_date IN DATE,
122: p_prev_date IN DATE,

Line 126: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

122: p_prev_date IN DATE,
123: p_period_type IN VARCHAR2,
124: p_coll_st_date IN DATE,
125: p_coll_end_date IN DATE,
126: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
127: x_snap_date OUT NOCOPY DATE,
128: x_prev_snap_date OUT NOCOPY DATE
129: );
130:

Line 136: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

132: p_asof_date IN DATE,
133: p_period_type IN VARCHAR2,
134: p_compare_to IN VARCHAR2,
135: p_prev_date IN DATE,
136: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
137: x_pipe_mv OUT NOCOPY VARCHAR2,
138: x_snapshot_date OUT NOCOPY DATE,
139: x_prev_snap_date OUT NOCOPY DATE
140: ) ;

Line 157: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

153: PROCEDURE GET_PIPE_TREND_SOURCE (p_as_of_date IN DATE,
154: p_prev_date IN DATE,
155: p_trend_type IN VARCHAR2,
156: p_period_type IN VARCHAR2,
157: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
158: x_pipe_mv OUT NOCOPY VARCHAR2,
159: x_snap_date OUT NOCOPY DATE,
160: x_prev_snap_date OUT NOCOPY DATE);
161: