13986: --------------------------------
13987: Function GetSubscriptionFrequency(p_line_id IN NUMBER) RETURN VARCHAR2 IS
13988: CURSOR getFrequency IS
13989: SELECT frequency
13990: FROM OKS_SUBSCR_HEADER_B
13991: WHERE cle_id = p_line_id;
13992:
13993: l_Frequency OKS_SUBSCR_HEADER_B.FREQUENCY%TYPE;
13994:
13989: SELECT frequency
13990: FROM OKS_SUBSCR_HEADER_B
13991: WHERE cle_id = p_line_id;
13992:
13993: l_Frequency OKS_SUBSCR_HEADER_B.FREQUENCY%TYPE;
13994:
13995: Begin
13996: OPEN getFrequency;
13997: FETCH getFrequency INTO l_Frequency;
14282: ,decode(okcB.LSE_ID
14283: ,122
14284: ,oksB.USAGE_PERIOD
14285: ,46
14286: ,(SELECT frequency FROM OKS_SUBSCR_HEADER_B WHERE cle_id = okcB.ID)
14287: ,oksB.PRICE_UOM
14288: )AS PRICE_UOM
14289: -- hkamdar 04-Sep-2006 Added for bug# 5458842.
14290: ,oksB.USAGE_TYPE as USAGE_TYPE
14319: ,decode(okcB.LSE_ID
14320: ,12
14321: ,oksB.USAGE_PERIOD
14322: ,46
14323: ,(SELECT frequency FROM OKS_SUBSCR_HEADER_B WHERE cle_id = okcB.ID)
14324: ,oksB.PRICE_UOM
14325: )AS PRICE_UOM
14326: -- hkamdar 04-Sep-2006 Added for bug# 5458842.
14327: ,oksB.USAGE_TYPE as USAGE_TYPE