DBA Data[Home] [Help]

APPS.BSC_UPDATE_COLOR dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 782: h_aw_limit_tbl BIS_PMV_PAGE_PARAMETER_TBL;

778: h_data_source VARCHAR2(10);
779: h_sql_stmt VARCHAR2(32700);
780:
781: --AW_INTEGRATION: new variables
782: h_aw_limit_tbl BIS_PMV_PAGE_PARAMETER_TBL;
783: h_aw_limit_rec BIS_PMV_PAGE_PARAMETER_REC;
784: h_calendar_id NUMBER;
785: h_min_per NUMBER;
786: h_max_per NUMBER;

Line 806: h_aw_limit_tbl := BIS_PMV_PAGE_PARAMETER_TBL();

802: h_lst_where := NULL;
803: h_lst_keys_insert := NULL;
804:
805: -- AW_INTEGRATION: init h_aw_limit_tbl
806: h_aw_limit_tbl := BIS_PMV_PAGE_PARAMETER_TBL();
807: h_aw_limit_tbl.delete;
808:
809: -- AW_INTEGRATION: move this line here
810: h_yearly_flag := BSC_UPDATE_UTIL.Get_Periodicity_Yearly_Flag(x_periodicity_id);

Line 2400: x_aw_limit_tbl IN OUT NOCOPY BIS_PMV_PAGE_PARAMETER_TBL --AW_INTEGRATION: new parameter

2396: x_color_by_total IN NUMBER,
2397: x_condition OUT NOCOPY VARCHAR2,
2398: x_bind_vars_values OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,
2399: x_num_bind_vars OUT NOCOPY NUMBER,
2400: x_aw_limit_tbl IN OUT NOCOPY BIS_PMV_PAGE_PARAMETER_TBL --AW_INTEGRATION: new parameter
2401: ) RETURN BOOLEAN IS
2402:
2403: -- BSC-BIS-DIMENSIONS: I have changed the type of x_bind_vars_values to use VARCHAR2
2404: -- This is to support NUMBER/VHARCHAR2 in key columns