[Home] [Help]
1246: END IF;
1247: END IF;
1248: --get aggregate columns for the time hierarchy based on given hierarchy level code
1249: IF p_exp_time_level IS NOT NULL THEN
1250: SELECT hrchy_lvl_name INTO l_hrchy_lvl_name FROM DDR_WS_METADATA WHERE hrchy_lvl_cd=p_exp_time_level;
1251: get_hrchy_lvl(l_hrchy_lvl_name,p_exp_time_level,l_lvl_rnk,x_return_status,x_msg_count,x_msg_data);
1252: IF x_return_status<>ddr_webservices_constants.g_ret_sts_success THEN
1253: RETURN;
1254: END IF;
1765: -- for RETAIL SALE RETURN ITEM DAY fact
1766: --WHEN ddr_webservices_constants.g_rsrid_cd THEN
1767: --to get the time hierarchy level name(GREGORIAN TIME OR BUSINESS TIME)
1768: IF p_time_dim_lvl_cd IS NOT NULL THEN
1769: SELECT hrchy_lvl_name INTO l_hrchy_lvl_name FROM DDR_WS_METADATA WHERE
1770: hrchy_lvl_cd=p_time_dim_lvl_cd;
1771: get_hrchy_lvl(l_hrchy_lvl_name,p_time_dim_lvl_cd,l_lvl_rnk,x_return_status,x_msg_count,x_msg_data);
1772: ELSIF p_exp_time_level IS NOT NULL THEN
1773: SELECT hrchy_lvl_name INTO l_hrchy_lvl_name FROM DDR_WS_METADATA WHERE
1769: SELECT hrchy_lvl_name INTO l_hrchy_lvl_name FROM DDR_WS_METADATA WHERE
1770: hrchy_lvl_cd=p_time_dim_lvl_cd;
1771: get_hrchy_lvl(l_hrchy_lvl_name,p_time_dim_lvl_cd,l_lvl_rnk,x_return_status,x_msg_count,x_msg_data);
1772: ELSIF p_exp_time_level IS NOT NULL THEN
1773: SELECT hrchy_lvl_name INTO l_hrchy_lvl_name FROM DDR_WS_METADATA WHERE
1774: hrchy_lvl_cd=p_exp_time_level;
1775: get_hrchy_lvl(l_hrchy_lvl_name,p_exp_time_level,l_lvl_rnk,x_return_status,x_msg_count,x_msg_data);
1776: END IF;
1777: IF l_lvl_rnk IS NULL THEN
1972: x_msg_data OUT NOCOPY VARCHAR2)
1973: IS
1974: l_hrchy_lvl NUMBER:=null;
1975: BEGIN
1976: SELECT lvl_rnk INTO l_hrchy_lvl FROM DDR_WS_METADATA WHERE HRCHY_LVL_CD=p_hrchy_lvl_cd AND hrchy_lvl_name=p_hrchy_lvl_name;
1977: -- DBMS_OUTPUT.PUT_LINE('p_hrchy_lvl_name='||p_hrchy_lvl_name||' ,p_hrchy_lvl_cd='||p_hrchy_lvl_cd||' ,x_hrchy_lvl='||l_hrchy_lvl);
1978: x_hrchy_lvl:=l_hrchy_lvl;
1979: EXCEPTION
1980: WHEN NO_DATA_FOUND THEN