APPS.OKS_ENTITLEMENTS_PUB dependencies on OKS_COV_TYPES_B

Line 617: ,coverage_type_code Oks_Cov_Types_B.Code%TYPE

613: ,service_description VARCHAR2(300) --OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE
614: ,coverage_term_line_id Number
615: ,Coverage_term_name OKC_K_LINES_V.NAME%TYPE
616: ,coverage_term_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE
617: ,coverage_type_code Oks_Cov_Types_B.Code%TYPE
618: ,coverage_type_meaning Oks_Cov_Types_TL.Meaning%TYPE
619: ,coverage_type_imp_level Oks_Cov_Types_B.Importance_Level%TYPE
620: ,coverage_level_line_id Number
621: ,coverage_level OKC_LINE_STYLES_TL.NAME%TYPE

Line 619: ,coverage_type_imp_level Oks_Cov_Types_B.Importance_Level%TYPE

615: ,Coverage_term_name OKC_K_LINES_V.NAME%TYPE
616: ,coverage_term_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE
617: ,coverage_type_code Oks_Cov_Types_B.Code%TYPE
618: ,coverage_type_meaning Oks_Cov_Types_TL.Meaning%TYPE
619: ,coverage_type_imp_level Oks_Cov_Types_B.Importance_Level%TYPE
620: ,coverage_level_line_id Number
621: ,coverage_level OKC_LINE_STYLES_TL.NAME%TYPE
622: ,coverage_level_code OKC_LINE_STYLES_B.LTY_CODE%TYPE
623: ,coverage_level_start_date Date

Line 838: ,coverage_type_code Oks_Cov_Types_B.Code%TYPE

834: ,service_description VARCHAR2(300) --OKX_SYSTEM_ITEMS_V.DESCRIPTION%TYPE
835: ,coverage_term_line_id Number
836: ,coverage_term_name OKC_K_LINES_V.NAME%TYPE
837: ,coverage_term_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE
838: ,coverage_type_code Oks_Cov_Types_B.Code%TYPE
839: ,coverage_type_meaning Oks_Cov_Types_TL.Meaning%TYPE
840: ,coverage_type_imp_level Oks_Cov_Types_B.Importance_Level%TYPE
841: ,service_start_date Date
842: ,service_end_date Date

Line 840: ,coverage_type_imp_level Oks_Cov_Types_B.Importance_Level%TYPE

836: ,coverage_term_name OKC_K_LINES_V.NAME%TYPE
837: ,coverage_term_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE
838: ,coverage_type_code Oks_Cov_Types_B.Code%TYPE
839: ,coverage_type_meaning Oks_Cov_Types_TL.Meaning%TYPE
840: ,coverage_type_imp_level Oks_Cov_Types_B.Importance_Level%TYPE
841: ,service_start_date Date
842: ,service_end_date Date
843: ,warranty_flag Varchar2(1)
844: ,eligible_for_entitlement Varchar2(1)

Line 1046: ,coverage_type_code OKS_Cov_TYPES_B.Code%Type

1042: ,service_description VARCHAR2(300) --OKX_SYSTEM_ITEMS_V.DESCRIPTION%TYPE
1043: ,coverage_term_line_id Number
1044: ,coverage_term_name OKC_K_LINES_V.NAME%TYPE
1045: ,coverage_term_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE
1046: ,coverage_type_code OKS_Cov_TYPES_B.Code%Type
1047: ,coverage_type_imp_level OKS_Cov_TYPES_B.Importance_Level%Type
1048: ,service_start_date Date
1049: ,service_end_date Date
1050: ,warranty_flag Varchar2(1)

Line 1047: ,coverage_type_imp_level OKS_Cov_TYPES_B.Importance_Level%Type

1043: ,coverage_term_line_id Number
1044: ,coverage_term_name OKC_K_LINES_V.NAME%TYPE
1045: ,coverage_term_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE
1046: ,coverage_type_code OKS_Cov_TYPES_B.Code%Type
1047: ,coverage_type_imp_level OKS_Cov_TYPES_B.Importance_Level%Type
1048: ,service_start_date Date
1049: ,service_end_date Date
1050: ,warranty_flag Varchar2(1)
1051: ,eligible_for_entitlement Varchar2(1)

Line 1677: (Code Oks_Cov_Types_B.Code%TYPE

1673: -- This PROCEDURE accepts contract_line_id as an input and returns a record of
1674: -- coverage_type_code , its meaning and the importance level associated to the coverage type.
1675:
1676: TYPE CovType_Rec_Type IS RECORD
1677: (Code Oks_Cov_Types_B.Code%TYPE
1678: ,Meaning Oks_Cov_Types_TL.Meaning%TYPE
1679: ,Importance_Level Oks_Cov_Types_B.Importance_Level%TYPE);
1680:
1681: /*#

Line 1679: ,Importance_Level Oks_Cov_Types_B.Importance_Level%TYPE);

1675:
1676: TYPE CovType_Rec_Type IS RECORD
1677: (Code Oks_Cov_Types_B.Code%TYPE
1678: ,Meaning Oks_Cov_Types_TL.Meaning%TYPE
1679: ,Importance_Level Oks_Cov_Types_B.Importance_Level%TYPE);
1680:
1681: /*#
1682: * Returns CODE, MEANING, DESCRIPTION, and IMPORTANCE_LEVEL from
1683: * OKS_COV_TYPES_V for a given Contract Line Id (CLE_ID).

Line 1774: ,coverage_imp_level OKS_COV_TYPES_B.IMPORTANCE_LEVEL%TYPE);

1770: ,contract_start_date OKC_K_HEADERS_B.start_date%TYPE
1771: ,contract_end_date OKC_K_HEADERS_B.end_date%TYPE
1772: ,contract_amount OKC_K_HEADERS_B.ESTIMATED_AMOUNT%TYPE
1773: ,coverage_type OKS_COV_TYPES_TL.MEANING%TYPE
1774: ,coverage_imp_level OKS_COV_TYPES_B.IMPORTANCE_LEVEL%TYPE);
1775:
1776:
1777: PROCEDURE Get_HighImp_CP_Contract
1778: (P_API_Version IN NUMBER