3:
4: --This is for the UI Query of Web Referral Analysis report
5: PROCEDURE GET_WEB_REF_SQL
6: (
7: p_param IN BIS_PMV_PAGE_PARAMETER_TBL
8: , x_custom_sql OUT NOCOPY VARCHAR2
9: , x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
10: );
11:
11:
12: --This is for the UI Query of Web Product Interest report
13: PROCEDURE GET_PROD_INT_SQL
14: (
15: p_param IN BIS_PMV_PAGE_PARAMETER_TBL
16: , x_custom_sql OUT NOCOPY VARCHAR2
17: , x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
18: );
19: