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.OKL_SEC_AGREEMENT_PVT dependencies on OKC_K_HEADERS_B

Line 24: ID OKC_K_HEADERS_B.ID%TYPE := OKL_API.G_MISS_NUM --NUMBER

20: -- Data Structures
21: ----------------------------------------------------------------------------
22:
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)

Line 25: ,CONTRACT_NUMBER OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(120)

21: ----------------------------------------------------------------------------
22:
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

Line 29: ,START_DATE OKC_K_HEADERS_B.START_DATE%TYPE := OKL_API.G_MISS_DATE --DATE

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
32: ,SECURITIZATION_TYPE OKL_K_HEADERS.SECURITIZATION_TYPE%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(30)
33: ,LESSOR_SERV_ORG_CODE OKL_K_HEADERS.LESSOR_SERV_ORG_CODE%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(30)

Line 30: ,END_DATE OKC_K_HEADERS_B.END_DATE%TYPE := OKL_API.G_MISS_DATE --DATE

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
32: ,SECURITIZATION_TYPE OKL_K_HEADERS.SECURITIZATION_TYPE%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(30)
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)

Line 31: ,DATE_APPROVED OKC_K_HEADERS_B.DATE_APPROVED%TYPE := OKL_API.G_MISS_DATE --DATE

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
32: ,SECURITIZATION_TYPE OKL_K_HEADERS.SECURITIZATION_TYPE%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(30)
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'

Line 36: ,STS_CODE OKC_K_HEADERS_B.STS_CODE%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(30)

32: ,SECURITIZATION_TYPE OKL_K_HEADERS.SECURITIZATION_TYPE%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(30)
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

Line 38: ,CURRENCY_CODE OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(15)

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
42: ,trustee_party_roles_id okc_k_party_roles_b.id%type := OKL_API.G_MISS_NUM -- NUMBER

Line 135: ,p_khr_id IN OKC_K_HEADERS_B.ID%TYPE);

131: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
132: ,x_return_status OUT NOCOPY VARCHAR2
133: ,x_msg_count OUT NOCOPY NUMBER
134: ,x_msg_data OUT NOCOPY VARCHAR2
135: ,p_khr_id IN OKC_K_HEADERS_B.ID%TYPE);
136:
137: ----------------------------------------------------------------------------------
138: -- Start of comments
139: --

Line 154: ,p_sec_agreement_status IN okc_k_headers_b.sts_code%TYPE

150: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
151: ,x_return_status OUT NOCOPY VARCHAR2
152: ,x_msg_count OUT NOCOPY NUMBER
153: ,x_msg_data OUT NOCOPY VARCHAR2
154: ,p_sec_agreement_status IN okc_k_headers_b.sts_code%TYPE
155: ,p_sec_agreement_id IN okc_k_headers_b.id%TYPE)
156: ;
157:
158: --Added by kthiruva on 18-Dec-2007

Line 155: ,p_sec_agreement_id IN okc_k_headers_b.id%TYPE)

151: ,x_return_status OUT NOCOPY VARCHAR2
152: ,x_msg_count OUT NOCOPY NUMBER
153: ,x_msg_data OUT NOCOPY VARCHAR2
154: ,p_sec_agreement_status IN okc_k_headers_b.sts_code%TYPE
155: ,p_sec_agreement_id IN okc_k_headers_b.id%TYPE)
156: ;
157:
158: --Added by kthiruva on 18-Dec-2007
159: -- New method to validate an add request on an active investor agreement

Line 175: ,p_khr_id IN OKC_K_HEADERS_B.ID%TYPE);

171: ,p_init_msg_list IN VARCHAR2
172: ,x_return_status OUT NOCOPY VARCHAR2
173: ,x_msg_count OUT NOCOPY NUMBER
174: ,x_msg_data OUT NOCOPY VARCHAR2
175: ,p_khr_id IN OKC_K_HEADERS_B.ID%TYPE);
176:
177: -- Bug 6691554 - End of Changes
178:
179: /*

Line 222: ,p_chr_id IN OKC_K_HEADERS_B.ID%TYPE);

218: ,p_init_msg_list IN VARCHAR2
219: ,x_return_status OUT NOCOPY VARCHAR2
220: ,x_msg_count OUT NOCOPY NUMBER
221: ,x_msg_data OUT NOCOPY VARCHAR2
222: ,p_chr_id IN OKC_K_HEADERS_B.ID%TYPE);
223:
224: /* sosharma end changes */
225:
226: