DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PUB dependencies on OKC_K_LINES_B

Line 286: CONTRACT_LINE_ID OKC_K_LINES_B.ID%TYPE

282: -- This API returns the contract line information for an input of contract line id.
283:
284: TYPE line_rec_type IS RECORD
285: (
286: CONTRACT_LINE_ID OKC_K_LINES_B.ID%TYPE
287: ,COnTRACT_PARENT_LINE_ID OKC_K_LINES_B.CLE_ID%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

Line 287: ,COnTRACT_PARENT_LINE_ID OKC_K_LINES_B.CLE_ID%TYPE

283:
284: TYPE line_rec_type IS RECORD
285: (
286: CONTRACT_LINE_ID OKC_K_LINES_B.ID%TYPE
287: ,COnTRACT_PARENT_LINE_ID OKC_K_LINES_B.CLE_ID%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)

Line 288: ,CONTRACT_ID OKC_K_LINES_B.CHR_ID%TYPE

284: TYPE line_rec_type IS RECORD
285: (
286: CONTRACT_LINE_ID OKC_K_LINES_B.ID%TYPE
287: ,COnTRACT_PARENT_LINE_ID OKC_K_LINES_B.CLE_ID%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

Line 289: ,LINE_STATUS_CODE OKC_K_LINES_B.STS_CODE%TYPE

285: (
286: CONTRACT_LINE_ID OKC_K_LINES_B.ID%TYPE
287: ,COnTRACT_PARENT_LINE_ID OKC_K_LINES_B.CLE_ID%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

Line 300: ,PRICE_NEGOTIATED OKC_K_LINES_B.PRICE_NEGOTIATED%TYPE

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
302: ,BILLING_FREQUENCY Varchar2(25)
303: ,BILLING_METHOD Varchar2(3)
304: ,REGULAR_OFFSET_DAYS Number

Line 423: ,LINE_ID OKC_K_LINES_B.ID%TYPE

419:
420: TYPE clvl_rec_type IS RECORD
421: (
422: ROW_ID ROWID
423: ,LINE_ID OKC_K_LINES_B.ID%TYPE
424: ,HEADER_ID OKC_K_LINES_B.CHR_ID%TYPE
425: ,PARENT_LINE_ID OKC_K_LINES_B.CLE_ID%TYPE
426: ,LINE_LEVEL Varchar2(150)
427: ,CP_ID Number

Line 424: ,HEADER_ID OKC_K_LINES_B.CHR_ID%TYPE

420: TYPE clvl_rec_type IS RECORD
421: (
422: ROW_ID ROWID
423: ,LINE_ID OKC_K_LINES_B.ID%TYPE
424: ,HEADER_ID OKC_K_LINES_B.CHR_ID%TYPE
425: ,PARENT_LINE_ID OKC_K_LINES_B.CLE_ID%TYPE
426: ,LINE_LEVEL Varchar2(150)
427: ,CP_ID Number
428: ,CP_NAME Varchar2(240)

Line 425: ,PARENT_LINE_ID OKC_K_LINES_B.CLE_ID%TYPE

421: (
422: ROW_ID ROWID
423: ,LINE_ID OKC_K_LINES_B.ID%TYPE
424: ,HEADER_ID OKC_K_LINES_B.CHR_ID%TYPE
425: ,PARENT_LINE_ID OKC_K_LINES_B.CLE_ID%TYPE
426: ,LINE_LEVEL Varchar2(150)
427: ,CP_ID Number
428: ,CP_NAME Varchar2(240)
429: ,INV_ITEM_ID Number

Line 441: ,PRICE_NEGOTIATED OKC_K_LINES_B.PRICE_NEGOTIATED%TYPE

437: ,PARTY_ID Number
438: ,PARTY_NAME Varchar2(500)
439: ,QUANTITY Number
440: ,LIST_PRICE Number
441: ,PRICE_NEGOTIATED OKC_K_LINES_B.PRICE_NEGOTIATED%TYPE
442: ,LINE_NAME Varchar2(150)
443: ,DEFAULT_AMCV_FLAG Varchar2(1)
444: ,DEFAULT_QTY Number
445: ,DEFAULT_UOM Varchar2(25)

Line 2890: ,contract_line_number OKC_K_LINES_B.LINE_NUMBER%TYPE

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)
2894: ,line_start_date DATE

Line 2898: ,Service_Id NUMBER --OKC_K_LINES_B.Id%TYPE

2894: ,line_start_date DATE
2895: ,line_end_date DATE
2896: ,contract_line_status_code OKC_STATUSES_TL.MEANING%TYPE --VARCHAR2(30) BUG# 4198718
2897: ,Coverage_Name OKC_K_LINES_TL.Name%TYPE
2898: ,Service_Id NUMBER --OKC_K_LINES_B.Id%TYPE
2899: ,Service_Lse_ID OKC_K_LINES_B.Lse_Id%TYPE
2900: ,CovLevel_Lse_ID OKC_K_LINES_B.Lse_Id%TYPE
2901: ,contract_id number
2902: ,coverage_line_id number

Line 2899: ,Service_Lse_ID OKC_K_LINES_B.Lse_Id%TYPE

2895: ,line_end_date DATE
2896: ,contract_line_status_code OKC_STATUSES_TL.MEANING%TYPE --VARCHAR2(30) BUG# 4198718
2897: ,Coverage_Name OKC_K_LINES_TL.Name%TYPE
2898: ,Service_Id NUMBER --OKC_K_LINES_B.Id%TYPE
2899: ,Service_Lse_ID OKC_K_LINES_B.Lse_Id%TYPE
2900: ,CovLevel_Lse_ID OKC_K_LINES_B.Lse_Id%TYPE
2901: ,contract_id number
2902: ,coverage_line_id number
2903: ,scs_code OKC_STATUSES_B.CODE%TYPE --VARCHAR2(30) BUG# 4198718

Line 2900: ,CovLevel_Lse_ID OKC_K_LINES_B.Lse_Id%TYPE

2896: ,contract_line_status_code OKC_STATUSES_TL.MEANING%TYPE --VARCHAR2(30) BUG# 4198718
2897: ,Coverage_Name OKC_K_LINES_TL.Name%TYPE
2898: ,Service_Id NUMBER --OKC_K_LINES_B.Id%TYPE
2899: ,Service_Lse_ID OKC_K_LINES_B.Lse_Id%TYPE
2900: ,CovLevel_Lse_ID OKC_K_LINES_B.Lse_Id%TYPE
2901: ,contract_id number
2902: ,coverage_line_id number
2903: ,scs_code OKC_STATUSES_B.CODE%TYPE --VARCHAR2(30) BUG# 4198718
2904: ,OPERATING_UNIT NUMBER -- Modified for 12.0 MOAC project (JVARGHES)