[Home] [Help]
23: TYPE secAgreement_rec_type IS RECORD (
24: ID OKC_K_HEADERS_B.ID%TYPE := OKL_API.G_MISS_NUM --NUMBER
25: ,CONTRACT_NUMBER OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(120)
26: ,PDT_ID OKL_K_HEADERS.PDT_ID%TYPE := OKL_API.G_MISS_NUM--NUMBER
27: ,POL_ID OKL_POOLS.ID%TYPE := OKL_API.G_MISS_NUM --NUMBER
28: ,SHORT_DESCRIPTION OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(600)
29: ,START_DATE OKC_K_HEADERS_B.START_DATE%TYPE := OKL_API.G_MISS_DATE --DATE
30: ,END_DATE OKC_K_HEADERS_B.END_DATE%TYPE := OKL_API.G_MISS_DATE --DATE
31: ,DATE_APPROVED OKC_K_HEADERS_B.DATE_APPROVED%TYPE := OKL_API.G_MISS_DATE --DATE
33: ,LESSOR_SERV_ORG_CODE OKL_K_HEADERS.LESSOR_SERV_ORG_CODE%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(30)
34: ,RECOURSE_CODE OKL_K_HEADERS.RECOURSE_CODE%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(30)
35: -- defualt to 'NEW'
36: ,STS_CODE OKC_K_HEADERS_B.STS_CODE%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(30)
37: -- default currency code from okl_pools.currency_code
38: ,CURRENCY_CODE OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(15)
39: ,CURRENCY_CONVERSION_TYPE OKL_K_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(30)
40: ,CURRENCY_CONVERSION_RATE OKL_K_HEADERS.CURRENCY_CONVERSION_RATE%TYPE := OKL_API.G_MISS_NUM--NUMBER
41: ,CURRENCY_CONVERSION_DATE OKL_K_HEADERS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE--DATE
201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
203: x_msg_data OUT NOCOPY VARCHAR2,
204: p_agreement_id IN OKC_K_HEADERS_V.ID%TYPE,
205: p_pool_id IN OKL_POOLS.ID%TYPE,
206: x_pool_trx_status OUT NOCOPY OKL_POOL_TRANSACTIONS.TRANSACTION_STATUS%TYPE);
207: /*
208: 19-Dec-2007, ankushar Bug# 6691554
209: end changes