eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_ENTITLEMENTS_PUB dependencies on OKC_K_HEADERS_B

Line 151: ORG_ID OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE

147: ,party_id NUMBER);
148:
149: TYPE hdr_rec_type IS RECORD
150: (
151: ORG_ID OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE
152: ,CONTRACT_ID OKC_K_HEADERS_B.ID%TYPE
153: ,CONTRACT_NUMBER OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
154: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
155: ,SHORT_DESCRIPTION OKC_K_HEADERS_TL.SHORT_DESCRIPTION%TYPE

Line 152: ,CONTRACT_ID OKC_K_HEADERS_B.ID%TYPE

148:
149: TYPE hdr_rec_type IS RECORD
150: (
151: ORG_ID OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE
152: ,CONTRACT_ID OKC_K_HEADERS_B.ID%TYPE
153: ,CONTRACT_NUMBER OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
154: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
155: ,SHORT_DESCRIPTION OKC_K_HEADERS_TL.SHORT_DESCRIPTION%TYPE
156: ,CONTRACT_AMOUNT Number(18,2)

Line 153: ,CONTRACT_NUMBER OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

149: TYPE hdr_rec_type IS RECORD
150: (
151: ORG_ID OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE
152: ,CONTRACT_ID OKC_K_HEADERS_B.ID%TYPE
153: ,CONTRACT_NUMBER OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
154: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
155: ,SHORT_DESCRIPTION OKC_K_HEADERS_TL.SHORT_DESCRIPTION%TYPE
156: ,CONTRACT_AMOUNT Number(18,2)
157: ,CONTRACT_STATUS_CODE OKC_K_HEADERS_B.STS_CODE%TYPE

Line 154: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE

150: (
151: ORG_ID OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE
152: ,CONTRACT_ID OKC_K_HEADERS_B.ID%TYPE
153: ,CONTRACT_NUMBER OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
154: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
155: ,SHORT_DESCRIPTION OKC_K_HEADERS_TL.SHORT_DESCRIPTION%TYPE
156: ,CONTRACT_AMOUNT Number(18,2)
157: ,CONTRACT_STATUS_CODE OKC_K_HEADERS_B.STS_CODE%TYPE
158: ,CONTRACT_TYPE OKC_K_HEADERS_B.CHR_TYPE%TYPE

Line 157: ,CONTRACT_STATUS_CODE OKC_K_HEADERS_B.STS_CODE%TYPE

153: ,CONTRACT_NUMBER OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
154: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
155: ,SHORT_DESCRIPTION OKC_K_HEADERS_TL.SHORT_DESCRIPTION%TYPE
156: ,CONTRACT_AMOUNT Number(18,2)
157: ,CONTRACT_STATUS_CODE OKC_K_HEADERS_B.STS_CODE%TYPE
158: ,CONTRACT_TYPE OKC_K_HEADERS_B.CHR_TYPE%TYPE
159: ,PARTY_ID Number
160: ,TEMPLATE_YN OKC_K_HEADERS_B.TEMPLATE_YN%TYPE
161: ,TEMPLATE_USED OKC_K_HEADERS_B.TEMPLATE_USED%TYPE

Line 158: ,CONTRACT_TYPE OKC_K_HEADERS_B.CHR_TYPE%TYPE

154: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
155: ,SHORT_DESCRIPTION OKC_K_HEADERS_TL.SHORT_DESCRIPTION%TYPE
156: ,CONTRACT_AMOUNT Number(18,2)
157: ,CONTRACT_STATUS_CODE OKC_K_HEADERS_B.STS_CODE%TYPE
158: ,CONTRACT_TYPE OKC_K_HEADERS_B.CHR_TYPE%TYPE
159: ,PARTY_ID Number
160: ,TEMPLATE_YN OKC_K_HEADERS_B.TEMPLATE_YN%TYPE
161: ,TEMPLATE_USED OKC_K_HEADERS_B.TEMPLATE_USED%TYPE
162: ,DURATION Number

Line 160: ,TEMPLATE_YN OKC_K_HEADERS_B.TEMPLATE_YN%TYPE

156: ,CONTRACT_AMOUNT Number(18,2)
157: ,CONTRACT_STATUS_CODE OKC_K_HEADERS_B.STS_CODE%TYPE
158: ,CONTRACT_TYPE OKC_K_HEADERS_B.CHR_TYPE%TYPE
159: ,PARTY_ID Number
160: ,TEMPLATE_YN OKC_K_HEADERS_B.TEMPLATE_YN%TYPE
161: ,TEMPLATE_USED OKC_K_HEADERS_B.TEMPLATE_USED%TYPE
162: ,DURATION Number
163: ,PERIOD_CODE Varchar2(25)
164: ,START_DATE_ACTIVE OKC_K_HEADERS_B.START_DATE%TYPE

Line 161: ,TEMPLATE_USED OKC_K_HEADERS_B.TEMPLATE_USED%TYPE

157: ,CONTRACT_STATUS_CODE OKC_K_HEADERS_B.STS_CODE%TYPE
158: ,CONTRACT_TYPE OKC_K_HEADERS_B.CHR_TYPE%TYPE
159: ,PARTY_ID Number
160: ,TEMPLATE_YN OKC_K_HEADERS_B.TEMPLATE_YN%TYPE
161: ,TEMPLATE_USED OKC_K_HEADERS_B.TEMPLATE_USED%TYPE
162: ,DURATION Number
163: ,PERIOD_CODE Varchar2(25)
164: ,START_DATE_ACTIVE OKC_K_HEADERS_B.START_DATE%TYPE
165: ,END_DATE_ACTIVE OKC_K_HEADERS_B.END_DATE%TYPE

Line 164: ,START_DATE_ACTIVE OKC_K_HEADERS_B.START_DATE%TYPE

160: ,TEMPLATE_YN OKC_K_HEADERS_B.TEMPLATE_YN%TYPE
161: ,TEMPLATE_USED OKC_K_HEADERS_B.TEMPLATE_USED%TYPE
162: ,DURATION Number
163: ,PERIOD_CODE Varchar2(25)
164: ,START_DATE_ACTIVE OKC_K_HEADERS_B.START_DATE%TYPE
165: ,END_DATE_ACTIVE OKC_K_HEADERS_B.END_DATE%TYPE
166: ,BILL_TO_SITE_USE_ID Number
167: ,SHIP_TO_SITE_USE_ID Number
168: ,AGREEMENT_ID OKC_K_HEADERS_B.CHR_ID_AWARD%TYPE

Line 165: ,END_DATE_ACTIVE OKC_K_HEADERS_B.END_DATE%TYPE

161: ,TEMPLATE_USED OKC_K_HEADERS_B.TEMPLATE_USED%TYPE
162: ,DURATION Number
163: ,PERIOD_CODE Varchar2(25)
164: ,START_DATE_ACTIVE OKC_K_HEADERS_B.START_DATE%TYPE
165: ,END_DATE_ACTIVE OKC_K_HEADERS_B.END_DATE%TYPE
166: ,BILL_TO_SITE_USE_ID Number
167: ,SHIP_TO_SITE_USE_ID Number
168: ,AGREEMENT_ID OKC_K_HEADERS_B.CHR_ID_AWARD%TYPE
169: ,PRICE_LIST_ID Number

Line 168: ,AGREEMENT_ID OKC_K_HEADERS_B.CHR_ID_AWARD%TYPE

164: ,START_DATE_ACTIVE OKC_K_HEADERS_B.START_DATE%TYPE
165: ,END_DATE_ACTIVE OKC_K_HEADERS_B.END_DATE%TYPE
166: ,BILL_TO_SITE_USE_ID Number
167: ,SHIP_TO_SITE_USE_ID Number
168: ,AGREEMENT_ID OKC_K_HEADERS_B.CHR_ID_AWARD%TYPE
169: ,PRICE_LIST_ID Number
170: ,MODIFIER Number
171: ,CURRENCY_CODE Varchar2(25)
172: ,ACCOUNTING_RULE_ID Number

Line 175: ,PO_NUMBER OKC_K_HEADERS_B.CUST_PO_NUMBER%TYPE

171: ,CURRENCY_CODE Varchar2(25)
172: ,ACCOUNTING_RULE_ID Number
173: ,INVOICING_RULE_ID Number
174: ,TERMS_ID Number
175: ,PO_NUMBER OKC_K_HEADERS_B.CUST_PO_NUMBER%TYPE
176: ,BILLING_PROFILE_ID Number
177: ,BILLING_FREQUENCY Varchar2(25)
178: ,BILLING_METHOD Varchar2(3)
179: ,REGULAR_OFFSET_DAYS Number

Line 182: ,AUTO_RENEW_BEFORE_DAYS OKC_K_HEADERS_B.AUTO_RENEW_DAYS%TYPE

178: ,BILLING_METHOD Varchar2(3)
179: ,REGULAR_OFFSET_DAYS Number
180: ,FIRST_BILL_TO Date
181: ,FIRST_BILL_ON Date
182: ,AUTO_RENEW_BEFORE_DAYS OKC_K_HEADERS_B.AUTO_RENEW_DAYS%TYPE
183: ,QA_CHECK_LIST_ID OKC_K_HEADERS_B.QCL_ID%TYPE
184: ,RENEWAL_NOTE CLOB
185: ,TERMINATION_NOTE CLOB
186: ,TAX_EXEMPTION Varchar2(450)

Line 183: ,QA_CHECK_LIST_ID OKC_K_HEADERS_B.QCL_ID%TYPE

179: ,REGULAR_OFFSET_DAYS Number
180: ,FIRST_BILL_TO Date
181: ,FIRST_BILL_ON Date
182: ,AUTO_RENEW_BEFORE_DAYS OKC_K_HEADERS_B.AUTO_RENEW_DAYS%TYPE
183: ,QA_CHECK_LIST_ID OKC_K_HEADERS_B.QCL_ID%TYPE
184: ,RENEWAL_NOTE CLOB
185: ,TERMINATION_NOTE CLOB
186: ,TAX_EXEMPTION Varchar2(450)
187: ,TAX_STATUS Varchar2(450)

Line 292: ,START_DATE_ACTIVE OKC_K_HEADERS_B.START_DATE%TYPE

288: ,CONTRACT_ID OKC_K_LINES_B.CHR_ID%TYPE
289: ,LINE_STATUS_CODE OKC_K_LINES_B.STS_CODE%TYPE
290: ,DURATION Number
291: ,PERIOD_CODE Varchar2(25)
292: ,START_DATE_ACTIVE OKC_K_HEADERS_B.START_DATE%TYPE
293: ,END_DATE_ACTIVE OKC_K_HEADERS_B.END_DATE%TYPE
294: ,LINE_NAME Varchar2(150)
295: ,BILL_TO_SITE_USE_ID Number
296: ,SHIP_TO_SITE_USE_ID Number

Line 293: ,END_DATE_ACTIVE OKC_K_HEADERS_B.END_DATE%TYPE

289: ,LINE_STATUS_CODE OKC_K_LINES_B.STS_CODE%TYPE
290: ,DURATION Number
291: ,PERIOD_CODE Varchar2(25)
292: ,START_DATE_ACTIVE OKC_K_HEADERS_B.START_DATE%TYPE
293: ,END_DATE_ACTIVE OKC_K_HEADERS_B.END_DATE%TYPE
294: ,LINE_NAME Varchar2(150)
295: ,BILL_TO_SITE_USE_ID Number
296: ,SHIP_TO_SITE_USE_ID Number
297: ,AGREEMENT_ID OKC_K_HEADERS_B.CHR_ID_AWARD%TYPE

Line 297: ,AGREEMENT_ID OKC_K_HEADERS_B.CHR_ID_AWARD%TYPE

293: ,END_DATE_ACTIVE OKC_K_HEADERS_B.END_DATE%TYPE
294: ,LINE_NAME Varchar2(150)
295: ,BILL_TO_SITE_USE_ID Number
296: ,SHIP_TO_SITE_USE_ID Number
297: ,AGREEMENT_ID OKC_K_HEADERS_B.CHR_ID_AWARD%TYPE
298: ,MODIFIER Number
299: ,PRICE_LIST_ID Number
300: ,PRICE_NEGOTIATED OKC_K_LINES_B.PRICE_NEGOTIATED%TYPE
301: ,BILLING_PROFILE_ID Number

Line 595: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

591: -- is done for corresponding service line and entitlement status is just passed
592: -- as an output for the corresponding covered level record
593:
594: TYPE inp_cont_rec IS RECORD
595: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
596: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
597: ,coverage_level_line_id Number
598: ,party_id Number
599: ,site_id Number

Line 596: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE

592: -- as an output for the corresponding covered level record
593:
594: TYPE inp_cont_rec IS RECORD
595: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
596: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
597: ,coverage_level_line_id Number
598: ,party_id Number
599: ,site_id Number
600: ,cust_acct_id Number

Line 609: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

605: ,validate_flag Varchar2(1));
606:
607: TYPE ent_cont_rec IS RECORD
608: (contract_id Number
609: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
610: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
611: ,service_line_id Number
612: ,service_name VARCHAR2(300) --OKC_K_LINES_V.NAME%TYPE
613: ,service_description VARCHAR2(300) --OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE

Line 610: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE

606:
607: TYPE ent_cont_rec IS RECORD
608: (contract_id Number
609: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
610: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
611: ,service_line_id Number
612: ,service_name VARCHAR2(300) --OKC_K_LINES_V.NAME%TYPE
613: ,service_description VARCHAR2(300) --OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE
614: ,coverage_term_line_id Number

Line 804: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

800: -- but entitlement check is done for service line record and entitlement status is just passed
801: -- as an output for the corresponding service line record.
802:
803: TYPE get_contin_rec IS RECORD
804: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
805: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
806: ,service_line_id Number
807: ,party_id Number
808: ,site_id Number

Line 805: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE

801: -- as an output for the corresponding service line record.
802:
803: TYPE get_contin_rec IS RECORD
804: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
805: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
806: ,service_line_id Number
807: ,party_id Number
808: ,site_id Number
809: ,cust_acct_id Number

Line 825: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

821: ,sort_key VARCHAR2(10));
822:
823: TYPE get_contop_rec IS RECORD
824: (contract_id Number
825: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
826: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
827: ,sts_code OKC_K_HEADERS_B.STS_CODE%TYPE
828: ,service_line_id Number
829: ,service_name VARCHAR2(300) --OKX_SYSTEM_ITEMS_V.NAME%TYPE

Line 826: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE

822:
823: TYPE get_contop_rec IS RECORD
824: (contract_id Number
825: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
826: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
827: ,sts_code OKC_K_HEADERS_B.STS_CODE%TYPE
828: ,service_line_id Number
829: ,service_name VARCHAR2(300) --OKX_SYSTEM_ITEMS_V.NAME%TYPE
830: ,service_description VARCHAR2(300) --OKX_SYSTEM_ITEMS_V.DESCRIPTION%TYPE

Line 827: ,sts_code OKC_K_HEADERS_B.STS_CODE%TYPE

823: TYPE get_contop_rec IS RECORD
824: (contract_id Number
825: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
826: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
827: ,sts_code OKC_K_HEADERS_B.STS_CODE%TYPE
828: ,service_line_id Number
829: ,service_name VARCHAR2(300) --OKX_SYSTEM_ITEMS_V.NAME%TYPE
830: ,service_description VARCHAR2(300) --OKX_SYSTEM_ITEMS_V.DESCRIPTION%TYPE
831: ,coverage_term_line_id Number

Line 1015: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

1011: -- is done for corresponding service line and entitlement status is just passed
1012: -- as an output for the corresponding service line record.
1013:
1014: TYPE input_rec_ib IS RECORD
1015: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1016: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1017: ,service_line_id Number
1018: ,party_id Number
1019: ,site_id Number

Line 1016: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

1012: -- as an output for the corresponding service line record.
1013:
1014: TYPE input_rec_ib IS RECORD
1015: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1016: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1017: ,service_line_id Number
1018: ,party_id Number
1019: ,site_id Number
1020: ,cust_acct_id Number

Line 1033: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

1029: ,validate_flag Varchar2(1));
1030:
1031: TYPE output_rec_ib IS RECORD
1032: (contract_id Number
1033: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1034: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
1035: ,sts_code OKC_K_HEADERS_B.STS_CODE%TYPE
1036: ,service_line_id Number
1037: ,service_name VARCHAR2(300) --OKX_SYSTEM_ITEMS_V.NAME%TYPE

Line 1034: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE

1030:
1031: TYPE output_rec_ib IS RECORD
1032: (contract_id Number
1033: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1034: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
1035: ,sts_code OKC_K_HEADERS_B.STS_CODE%TYPE
1036: ,service_line_id Number
1037: ,service_name VARCHAR2(300) --OKX_SYSTEM_ITEMS_V.NAME%TYPE
1038: ,service_description VARCHAR2(300) --OKX_SYSTEM_ITEMS_V.DESCRIPTION%TYPE

Line 1035: ,sts_code OKC_K_HEADERS_B.STS_CODE%TYPE

1031: TYPE output_rec_ib IS RECORD
1032: (contract_id Number
1033: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1034: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
1035: ,sts_code OKC_K_HEADERS_B.STS_CODE%TYPE
1036: ,service_line_id Number
1037: ,service_name VARCHAR2(300) --OKX_SYSTEM_ITEMS_V.NAME%TYPE
1038: ,service_description VARCHAR2(300) --OKX_SYSTEM_ITEMS_V.DESCRIPTION%TYPE
1039: ,coverage_term_line_id Number

Line 1102: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

1098: -- introduced in 11.5.9 , for which Entitlement search UI
1099: -- is also introduced.
1100:
1101: TYPE input_rec_entfrm IS RECORD
1102: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1103: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1104: ,contract_customer_id NUMBER
1105: ,contract_service_item_id NUMBER
1106: ,covlvl_party_id NUMBER

Line 1103: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

1099: -- is also introduced.
1100:
1101: TYPE input_rec_entfrm IS RECORD
1102: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1103: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1104: ,contract_customer_id NUMBER
1105: ,contract_service_item_id NUMBER
1106: ,covlvl_party_id NUMBER
1107: ,covlvl_site_id NUMBER

Line 1117: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

1113: ,validate_effectivity VARCHAR2(1));
1114:
1115: TYPE output_rec_entfrm IS RECORD
1116: (contract_id NUMBER
1117: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1118: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
1119: ,contract_known_as OKC_K_HEADERS_TL.COGNOMEN%TYPE
1120: ,contract_short_description OKC_K_HEADERS_TL.SHORT_DESCRIPTION%TYPE
1121: ,contract_status_code OKC_K_HEADERS_B.STS_CODE%TYPE

Line 1118: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE

1114:
1115: TYPE output_rec_entfrm IS RECORD
1116: (contract_id NUMBER
1117: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1118: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
1119: ,contract_known_as OKC_K_HEADERS_TL.COGNOMEN%TYPE
1120: ,contract_short_description OKC_K_HEADERS_TL.SHORT_DESCRIPTION%TYPE
1121: ,contract_status_code OKC_K_HEADERS_B.STS_CODE%TYPE
1122: ,contract_start_date DATE

Line 1121: ,contract_status_code OKC_K_HEADERS_B.STS_CODE%TYPE

1117: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1118: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
1119: ,contract_known_as OKC_K_HEADERS_TL.COGNOMEN%TYPE
1120: ,contract_short_description OKC_K_HEADERS_TL.SHORT_DESCRIPTION%TYPE
1121: ,contract_status_code OKC_K_HEADERS_B.STS_CODE%TYPE
1122: ,contract_start_date DATE
1123: ,contract_end_date DATE
1124: ,contract_terminated_date DATE);
1125:

Line 1441: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

1437:
1438: TYPE covlvl_id_tbl IS TABLE OF covlvl_id_rec INDEX BY BINARY_INTEGER;
1439:
1440: TYPE inp_cont_rec_type IS RECORD
1441: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1442: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1443: ,contract_status_code VARCHAR2(30)
1444: ,start_date_from DATE
1445: ,start_date_to DATE

Line 1442: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

1438: TYPE covlvl_id_tbl IS TABLE OF covlvl_id_rec INDEX BY BINARY_INTEGER;
1439:
1440: TYPE inp_cont_rec_type IS RECORD
1441: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1442: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1443: ,contract_status_code VARCHAR2(30)
1444: ,start_date_from DATE
1445: ,start_date_to DATE
1446: ,end_date_from DATE

Line 1456: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

1452: ,entitlement_check_YN VARCHAR2(1));
1453:
1454:
1455: TYPE output_rec_contract IS RECORD
1456: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1457: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1458: ,contract_category VARCHAR2(30)
1459: ,contract_status_code VARCHAR2(30)
1460: ,known_as VARCHAR2(300)

Line 1457: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

1453:
1454:
1455: TYPE output_rec_contract IS RECORD
1456: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1457: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1458: ,contract_category VARCHAR2(30)
1459: ,contract_status_code VARCHAR2(30)
1460: ,known_as VARCHAR2(300)
1461: ,short_description VARCHAR2(1995)

Line 1760: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

1756: -- 3.Returns only one row- system picked, even if there are multiple rows selected
1757: -- for the criteria.
1758:
1759: TYPE High_Imp_level_K_rec IS RECORD
1760: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1761: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
1762: ,contract_status_code OKC_K_HEADERS_B.STS_CODE%TYPE
1763: ,contract_start_date OKC_K_HEADERS_B.start_date%TYPE
1764: ,contract_end_date OKC_K_HEADERS_B.end_date%TYPE

Line 1761: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE

1757: -- for the criteria.
1758:
1759: TYPE High_Imp_level_K_rec IS RECORD
1760: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1761: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
1762: ,contract_status_code OKC_K_HEADERS_B.STS_CODE%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

Line 1762: ,contract_status_code OKC_K_HEADERS_B.STS_CODE%TYPE

1758:
1759: TYPE High_Imp_level_K_rec IS RECORD
1760: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1761: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
1762: ,contract_status_code OKC_K_HEADERS_B.STS_CODE%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

Line 1763: ,contract_start_date OKC_K_HEADERS_B.start_date%TYPE

1759: TYPE High_Imp_level_K_rec IS RECORD
1760: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1761: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
1762: ,contract_status_code OKC_K_HEADERS_B.STS_CODE%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);

Line 1764: ,contract_end_date OKC_K_HEADERS_B.end_date%TYPE

1760: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1761: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
1762: ,contract_status_code OKC_K_HEADERS_B.STS_CODE%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:

Line 1765: ,contract_amount OKC_K_HEADERS_B.ESTIMATED_AMOUNT%TYPE

1761: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
1762: ,contract_status_code OKC_K_HEADERS_B.STS_CODE%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:

Line 2848: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

2844: -- p_contract_line_rec are also used to further filter the resultset.
2845:
2846: TYPE srchline_inpcontrec_type IS RECORD
2847: (contract_id number
2848: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
2849: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
2850: ,contract_status_code VARCHAR2(30)
2851: ,start_date_from DATE
2852: ,start_date_to DATE

Line 2849: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

2845:
2846: TYPE srchline_inpcontrec_type IS RECORD
2847: (contract_id number
2848: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
2849: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
2850: ,contract_status_code VARCHAR2(30)
2851: ,start_date_from DATE
2852: ,start_date_to DATE
2853: ,end_date_from DATE

Line 2888: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

2884:
2885: TYPE srchline_covlvl_id_tbl IS TABLE OF srchline_covlvl_id_rec INDEX BY BINARY_INTEGER;
2886:
2887: TYPE output_rec_contractline IS RECORD
2888: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
2889: ,contract_number_modifier OKC_K_HEADERS_B.contract_number_modifier%TYPE
2890: ,contract_line_number OKC_K_LINES_B.LINE_NUMBER%TYPE
2891: ,contract_line_type OKC_LINE_STYLES_TL.NAME%TYPE -- VARCHAR2(80) BUG# 4198718
2892: ,Service_name VARCHAR2(1995)

Line 2889: ,contract_number_modifier OKC_K_HEADERS_B.contract_number_modifier%TYPE

2885: TYPE srchline_covlvl_id_tbl IS TABLE OF srchline_covlvl_id_rec INDEX BY BINARY_INTEGER;
2886:
2887: TYPE output_rec_contractline IS RECORD
2888: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
2889: ,contract_number_modifier OKC_K_HEADERS_B.contract_number_modifier%TYPE
2890: ,contract_line_number OKC_K_LINES_B.LINE_NUMBER%TYPE
2891: ,contract_line_type OKC_LINE_STYLES_TL.NAME%TYPE -- VARCHAR2(80) BUG# 4198718
2892: ,Service_name VARCHAR2(1995)
2893: ,contract_description VARCHAR2(1995)