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 834: ,coverage_type_code Oks_Cov_Types_B.Code%TYPE

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

Line 836: ,coverage_type_imp_level Oks_Cov_Types_B.Importance_Level%TYPE

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

Line 1042: ,coverage_type_code OKS_Cov_TYPES_B.Code%Type

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

Line 1043: ,coverage_type_imp_level OKS_Cov_TYPES_B.Importance_Level%Type

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

Line 1670: (Code Oks_Cov_Types_B.Code%TYPE

1666: -- This PROCEDURE accepts contract_line_id as an input and returns a record of
1667: -- coverage_type_code , its meaning and the importance level associated to the coverage type.
1668:
1669: TYPE CovType_Rec_Type IS RECORD
1670: (Code Oks_Cov_Types_B.Code%TYPE
1671: ,Meaning Oks_Cov_Types_TL.Meaning%TYPE
1672: ,Importance_Level Oks_Cov_Types_B.Importance_Level%TYPE);
1673:
1674: /*#

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

1668:
1669: TYPE CovType_Rec_Type IS RECORD
1670: (Code Oks_Cov_Types_B.Code%TYPE
1671: ,Meaning Oks_Cov_Types_TL.Meaning%TYPE
1672: ,Importance_Level Oks_Cov_Types_B.Importance_Level%TYPE);
1673:
1674: /*#
1675: * Returns CODE, MEANING, DESCRIPTION, and IMPORTANCE_LEVEL from
1676: * OKS_COV_TYPES_V for a given Contract Line Id (CLE_ID).

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

1763: ,contract_start_date OKC_K_HEADERS_B.start_date%TYPE
1764: ,contract_end_date OKC_K_HEADERS_B.end_date%TYPE
1765: ,contract_amount OKC_K_HEADERS_B.ESTIMATED_AMOUNT%TYPE
1766: ,coverage_type OKS_COV_TYPES_TL.MEANING%TYPE
1767: ,coverage_imp_level OKS_COV_TYPES_B.IMPORTANCE_LEVEL%TYPE);
1768:
1769:
1770: PROCEDURE Get_HighImp_CP_Contract
1771: (P_API_Version IN NUMBER