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 805: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

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

Line 806: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE

802:
803: /*vgujarat - modified for access hour ER 9675504*/
804: TYPE get_contin_rec IS RECORD
805: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
806: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
807: ,service_line_id Number
808: ,party_id Number
809: ,site_id Number
810: ,cust_acct_id Number

Line 829: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

825: ,cust_loc_id NUMBER DEFAULT NULL); --access hour
826:
827: TYPE get_contop_rec IS RECORD
828: (contract_id Number
829: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
830: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
831: ,sts_code OKC_K_HEADERS_B.STS_CODE%TYPE
832: ,service_line_id Number
833: ,service_name VARCHAR2(300) --OKX_SYSTEM_ITEMS_V.NAME%TYPE

Line 830: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE

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

Line 831: ,sts_code OKC_K_HEADERS_B.STS_CODE%TYPE

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

Line 1019: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

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

Line 1020: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

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

Line 1037: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

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

Line 1038: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE

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

Line 1039: ,sts_code OKC_K_HEADERS_B.STS_CODE%TYPE

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

Line 1106: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

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

Line 1107: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

1103: -- is also introduced.
1104:
1105: TYPE input_rec_entfrm IS RECORD
1106: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1107: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1108: ,contract_customer_id NUMBER
1109: ,contract_service_item_id NUMBER
1110: ,covlvl_party_id NUMBER
1111: ,covlvl_site_id NUMBER

Line 1121: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

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

Line 1122: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE

1118:
1119: TYPE output_rec_entfrm IS RECORD
1120: (contract_id NUMBER
1121: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1122: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
1123: ,contract_known_as OKC_K_HEADERS_TL.COGNOMEN%TYPE
1124: ,contract_short_description OKC_K_HEADERS_TL.SHORT_DESCRIPTION%TYPE
1125: ,contract_status_code OKC_K_HEADERS_B.STS_CODE%TYPE
1126: ,contract_start_date DATE

Line 1125: ,contract_status_code OKC_K_HEADERS_B.STS_CODE%TYPE

1121: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1122: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
1123: ,contract_known_as OKC_K_HEADERS_TL.COGNOMEN%TYPE
1124: ,contract_short_description OKC_K_HEADERS_TL.SHORT_DESCRIPTION%TYPE
1125: ,contract_status_code OKC_K_HEADERS_B.STS_CODE%TYPE
1126: ,contract_start_date DATE
1127: ,contract_end_date DATE
1128: ,contract_terminated_date DATE);
1129:

Line 1445: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

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

Line 1446: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

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

Line 1460: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

1456: ,entitlement_check_YN VARCHAR2(1));
1457:
1458:
1459: TYPE output_rec_contract IS RECORD
1460: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1461: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1462: ,contract_category VARCHAR2(30)
1463: ,contract_status_code VARCHAR2(30)
1464: ,known_as VARCHAR2(300)

Line 1461: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

1457:
1458:
1459: TYPE output_rec_contract IS RECORD
1460: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1461: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1462: ,contract_category VARCHAR2(30)
1463: ,contract_status_code VARCHAR2(30)
1464: ,known_as VARCHAR2(300)
1465: ,short_description VARCHAR2(1995)

Line 1767: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

1763: -- 3.Returns only one row- system picked, even if there are multiple rows selected
1764: -- for the criteria.
1765:
1766: TYPE High_Imp_level_K_rec IS RECORD
1767: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1768: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
1769: ,contract_status_code OKC_K_HEADERS_B.STS_CODE%TYPE
1770: ,contract_start_date OKC_K_HEADERS_B.start_date%TYPE
1771: ,contract_end_date OKC_K_HEADERS_B.end_date%TYPE

Line 1768: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE

1764: -- for the criteria.
1765:
1766: TYPE High_Imp_level_K_rec IS RECORD
1767: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1768: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
1769: ,contract_status_code OKC_K_HEADERS_B.STS_CODE%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

Line 1769: ,contract_status_code OKC_K_HEADERS_B.STS_CODE%TYPE

1765:
1766: TYPE High_Imp_level_K_rec IS RECORD
1767: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1768: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
1769: ,contract_status_code OKC_K_HEADERS_B.STS_CODE%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

Line 1770: ,contract_start_date OKC_K_HEADERS_B.start_date%TYPE

1766: TYPE High_Imp_level_K_rec IS RECORD
1767: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1768: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
1769: ,contract_status_code OKC_K_HEADERS_B.STS_CODE%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);

Line 1771: ,contract_end_date OKC_K_HEADERS_B.end_date%TYPE

1767: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
1768: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
1769: ,contract_status_code OKC_K_HEADERS_B.STS_CODE%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:

Line 1772: ,contract_amount OKC_K_HEADERS_B.ESTIMATED_AMOUNT%TYPE

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

Line 2859: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

2855: -- p_contract_line_rec are also used to further filter the resultset.
2856:
2857: TYPE srchline_inpcontrec_type IS RECORD
2858: (contract_id number
2859: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
2860: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
2861: ,contract_status_code VARCHAR2(30)
2862: ,start_date_from DATE
2863: ,start_date_to DATE

Line 2860: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

2856:
2857: TYPE srchline_inpcontrec_type IS RECORD
2858: (contract_id number
2859: ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
2860: ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
2861: ,contract_status_code VARCHAR2(30)
2862: ,start_date_from DATE
2863: ,start_date_to DATE
2864: ,end_date_from DATE

Line 2899: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

2895:
2896: TYPE srchline_covlvl_id_tbl IS TABLE OF srchline_covlvl_id_rec INDEX BY BINARY_INTEGER;
2897:
2898: TYPE output_rec_contractline IS RECORD
2899: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
2900: ,contract_number_modifier OKC_K_HEADERS_B.contract_number_modifier%TYPE
2901: ,contract_line_number OKC_K_LINES_B.LINE_NUMBER%TYPE
2902: ,contract_line_type OKC_LINE_STYLES_TL.NAME%TYPE -- VARCHAR2(80) BUG# 4198718
2903: ,Service_name VARCHAR2(1995)

Line 2900: ,contract_number_modifier OKC_K_HEADERS_B.contract_number_modifier%TYPE

2896: TYPE srchline_covlvl_id_tbl IS TABLE OF srchline_covlvl_id_rec INDEX BY BINARY_INTEGER;
2897:
2898: TYPE output_rec_contractline IS RECORD
2899: (contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
2900: ,contract_number_modifier OKC_K_HEADERS_B.contract_number_modifier%TYPE
2901: ,contract_line_number OKC_K_LINES_B.LINE_NUMBER%TYPE
2902: ,contract_line_type OKC_LINE_STYLES_TL.NAME%TYPE -- VARCHAR2(80) BUG# 4198718
2903: ,Service_name VARCHAR2(1995)
2904: ,contract_description VARCHAR2(1995)