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 OKL_API

Line 7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

3: ----------------------------------------------------------------------------
4: -- GLOBAL VARIABLES
5: ----------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SEC_AGREEMENT_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;

Line 9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

5: ----------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SEC_AGREEMENT_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12: G_EXCEPTION_ERROR EXCEPTION;
13: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;

Line 10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;

6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SEC_AGREEMENT_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12: G_EXCEPTION_ERROR EXCEPTION;
13: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
14:

Line 11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;

7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12: G_EXCEPTION_ERROR EXCEPTION;
13: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
14:
15: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKL_UNEXPECTED_ERROR';

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 26: ,PDT_ID OKL_K_HEADERS.PDT_ID%TYPE := OKL_API.G_MISS_NUM--NUMBER

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
30: ,END_DATE OKC_K_HEADERS_B.END_DATE%TYPE := OKL_API.G_MISS_DATE --DATE

Line 27: ,POL_ID OKL_POOLS.ID%TYPE := OKL_API.G_MISS_NUM --NUMBER

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

Line 28: ,SHORT_DESCRIPTION OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(600)

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

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

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'
36: ,STS_CODE OKC_K_HEADERS_B.STS_CODE%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(30)

Line 33: ,LESSOR_SERV_ORG_CODE OKL_K_HEADERS.LESSOR_SERV_ORG_CODE%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(30)

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'
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

Line 34: ,RECOURSE_CODE OKL_K_HEADERS.RECOURSE_CODE%TYPE := OKL_API.G_MISS_CHAR --VARCHAR2(30)

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'
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)

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 39: ,CURRENCY_CONVERSION_TYPE OKL_K_HEADERS.CURRENCY_CONVERSION_TYPE%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
43: ,trustee_object1_id1 okc_k_party_roles_b.object1_id1%type := OKL_API.G_MISS_CHAR -- VARCHAR2(40)

Line 40: ,CURRENCY_CONVERSION_RATE OKL_K_HEADERS.CURRENCY_CONVERSION_RATE%TYPE := OKL_API.G_MISS_NUM--NUMBER

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
43: ,trustee_object1_id1 okc_k_party_roles_b.object1_id1%type := OKL_API.G_MISS_CHAR -- VARCHAR2(40)
44: ,trustee_object1_id2 okc_k_party_roles_b.object1_id1%type := OKL_API.G_MISS_CHAR -- VARCHAR2(200)

Line 41: ,CURRENCY_CONVERSION_DATE OKL_K_HEADERS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE--DATE

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
43: ,trustee_object1_id1 okc_k_party_roles_b.object1_id1%type := OKL_API.G_MISS_CHAR -- VARCHAR2(40)
44: ,trustee_object1_id2 okc_k_party_roles_b.object1_id1%type := OKL_API.G_MISS_CHAR -- VARCHAR2(200)
45: ,trustee_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%type := OKL_API.G_MISS_CHAR -- VARCHAR2(30)

Line 42: ,trustee_party_roles_id okc_k_party_roles_b.id%type := OKL_API.G_MISS_NUM -- NUMBER

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
43: ,trustee_object1_id1 okc_k_party_roles_b.object1_id1%type := OKL_API.G_MISS_CHAR -- VARCHAR2(40)
44: ,trustee_object1_id2 okc_k_party_roles_b.object1_id1%type := OKL_API.G_MISS_CHAR -- VARCHAR2(200)
45: ,trustee_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%type := OKL_API.G_MISS_CHAR -- VARCHAR2(30)
46: -- akjain,v115.6

Line 43: ,trustee_object1_id1 okc_k_party_roles_b.object1_id1%type := OKL_API.G_MISS_CHAR -- VARCHAR2(40)

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
43: ,trustee_object1_id1 okc_k_party_roles_b.object1_id1%type := OKL_API.G_MISS_CHAR -- VARCHAR2(40)
44: ,trustee_object1_id2 okc_k_party_roles_b.object1_id1%type := OKL_API.G_MISS_CHAR -- VARCHAR2(200)
45: ,trustee_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%type := OKL_API.G_MISS_CHAR -- VARCHAR2(30)
46: -- akjain,v115.6
47: ,AFTER_TAX_YIELD OKL_K_HEADERS.AFTER_TAX_YIELD%TYPE := OKL_API.G_MISS_NUM --NUMBER

Line 44: ,trustee_object1_id2 okc_k_party_roles_b.object1_id1%type := OKL_API.G_MISS_CHAR -- VARCHAR2(200)

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
43: ,trustee_object1_id1 okc_k_party_roles_b.object1_id1%type := OKL_API.G_MISS_CHAR -- VARCHAR2(40)
44: ,trustee_object1_id2 okc_k_party_roles_b.object1_id1%type := OKL_API.G_MISS_CHAR -- VARCHAR2(200)
45: ,trustee_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%type := OKL_API.G_MISS_CHAR -- VARCHAR2(30)
46: -- akjain,v115.6
47: ,AFTER_TAX_YIELD OKL_K_HEADERS.AFTER_TAX_YIELD%TYPE := OKL_API.G_MISS_NUM --NUMBER
48: -- arajagop Begin added for Flexfield Support

Line 45: ,trustee_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%type := OKL_API.G_MISS_CHAR -- VARCHAR2(30)

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
43: ,trustee_object1_id1 okc_k_party_roles_b.object1_id1%type := OKL_API.G_MISS_CHAR -- VARCHAR2(40)
44: ,trustee_object1_id2 okc_k_party_roles_b.object1_id1%type := OKL_API.G_MISS_CHAR -- VARCHAR2(200)
45: ,trustee_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%type := OKL_API.G_MISS_CHAR -- VARCHAR2(30)
46: -- akjain,v115.6
47: ,AFTER_TAX_YIELD OKL_K_HEADERS.AFTER_TAX_YIELD%TYPE := OKL_API.G_MISS_NUM --NUMBER
48: -- arajagop Begin added for Flexfield Support
49: ,ATTRIBUTE_CATEGORY OKL_K_HEADERS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

Line 47: ,AFTER_TAX_YIELD OKL_K_HEADERS.AFTER_TAX_YIELD%TYPE := OKL_API.G_MISS_NUM --NUMBER

43: ,trustee_object1_id1 okc_k_party_roles_b.object1_id1%type := OKL_API.G_MISS_CHAR -- VARCHAR2(40)
44: ,trustee_object1_id2 okc_k_party_roles_b.object1_id1%type := OKL_API.G_MISS_CHAR -- VARCHAR2(200)
45: ,trustee_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%type := OKL_API.G_MISS_CHAR -- VARCHAR2(30)
46: -- akjain,v115.6
47: ,AFTER_TAX_YIELD OKL_K_HEADERS.AFTER_TAX_YIELD%TYPE := OKL_API.G_MISS_NUM --NUMBER
48: -- arajagop Begin added for Flexfield Support
49: ,ATTRIBUTE_CATEGORY OKL_K_HEADERS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
50: ,ATTRIBUTE1 OKL_K_HEADERS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
51: ,ATTRIBUTE2 OKL_K_HEADERS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

Line 49: ,ATTRIBUTE_CATEGORY OKL_K_HEADERS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

45: ,trustee_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%type := OKL_API.G_MISS_CHAR -- VARCHAR2(30)
46: -- akjain,v115.6
47: ,AFTER_TAX_YIELD OKL_K_HEADERS.AFTER_TAX_YIELD%TYPE := OKL_API.G_MISS_NUM --NUMBER
48: -- arajagop Begin added for Flexfield Support
49: ,ATTRIBUTE_CATEGORY OKL_K_HEADERS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
50: ,ATTRIBUTE1 OKL_K_HEADERS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
51: ,ATTRIBUTE2 OKL_K_HEADERS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
52: ,ATTRIBUTE3 OKL_K_HEADERS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
53: ,ATTRIBUTE4 OKL_K_HEADERS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

Line 50: ,ATTRIBUTE1 OKL_K_HEADERS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

46: -- akjain,v115.6
47: ,AFTER_TAX_YIELD OKL_K_HEADERS.AFTER_TAX_YIELD%TYPE := OKL_API.G_MISS_NUM --NUMBER
48: -- arajagop Begin added for Flexfield Support
49: ,ATTRIBUTE_CATEGORY OKL_K_HEADERS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
50: ,ATTRIBUTE1 OKL_K_HEADERS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
51: ,ATTRIBUTE2 OKL_K_HEADERS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
52: ,ATTRIBUTE3 OKL_K_HEADERS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
53: ,ATTRIBUTE4 OKL_K_HEADERS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
54: ,ATTRIBUTE5 OKL_K_HEADERS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

Line 51: ,ATTRIBUTE2 OKL_K_HEADERS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

47: ,AFTER_TAX_YIELD OKL_K_HEADERS.AFTER_TAX_YIELD%TYPE := OKL_API.G_MISS_NUM --NUMBER
48: -- arajagop Begin added for Flexfield Support
49: ,ATTRIBUTE_CATEGORY OKL_K_HEADERS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
50: ,ATTRIBUTE1 OKL_K_HEADERS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
51: ,ATTRIBUTE2 OKL_K_HEADERS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
52: ,ATTRIBUTE3 OKL_K_HEADERS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
53: ,ATTRIBUTE4 OKL_K_HEADERS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
54: ,ATTRIBUTE5 OKL_K_HEADERS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
55: ,ATTRIBUTE6 OKL_K_HEADERS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

Line 52: ,ATTRIBUTE3 OKL_K_HEADERS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

48: -- arajagop Begin added for Flexfield Support
49: ,ATTRIBUTE_CATEGORY OKL_K_HEADERS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
50: ,ATTRIBUTE1 OKL_K_HEADERS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
51: ,ATTRIBUTE2 OKL_K_HEADERS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
52: ,ATTRIBUTE3 OKL_K_HEADERS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
53: ,ATTRIBUTE4 OKL_K_HEADERS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
54: ,ATTRIBUTE5 OKL_K_HEADERS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
55: ,ATTRIBUTE6 OKL_K_HEADERS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
56: ,ATTRIBUTE7 OKL_K_HEADERS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

Line 53: ,ATTRIBUTE4 OKL_K_HEADERS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

49: ,ATTRIBUTE_CATEGORY OKL_K_HEADERS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
50: ,ATTRIBUTE1 OKL_K_HEADERS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
51: ,ATTRIBUTE2 OKL_K_HEADERS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
52: ,ATTRIBUTE3 OKL_K_HEADERS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
53: ,ATTRIBUTE4 OKL_K_HEADERS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
54: ,ATTRIBUTE5 OKL_K_HEADERS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
55: ,ATTRIBUTE6 OKL_K_HEADERS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
56: ,ATTRIBUTE7 OKL_K_HEADERS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
57: ,ATTRIBUTE8 OKL_K_HEADERS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

Line 54: ,ATTRIBUTE5 OKL_K_HEADERS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

50: ,ATTRIBUTE1 OKL_K_HEADERS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
51: ,ATTRIBUTE2 OKL_K_HEADERS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
52: ,ATTRIBUTE3 OKL_K_HEADERS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
53: ,ATTRIBUTE4 OKL_K_HEADERS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
54: ,ATTRIBUTE5 OKL_K_HEADERS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
55: ,ATTRIBUTE6 OKL_K_HEADERS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
56: ,ATTRIBUTE7 OKL_K_HEADERS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
57: ,ATTRIBUTE8 OKL_K_HEADERS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
58: ,ATTRIBUTE9 OKL_K_HEADERS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

Line 55: ,ATTRIBUTE6 OKL_K_HEADERS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

51: ,ATTRIBUTE2 OKL_K_HEADERS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
52: ,ATTRIBUTE3 OKL_K_HEADERS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
53: ,ATTRIBUTE4 OKL_K_HEADERS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
54: ,ATTRIBUTE5 OKL_K_HEADERS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
55: ,ATTRIBUTE6 OKL_K_HEADERS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
56: ,ATTRIBUTE7 OKL_K_HEADERS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
57: ,ATTRIBUTE8 OKL_K_HEADERS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
58: ,ATTRIBUTE9 OKL_K_HEADERS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
59: ,ATTRIBUTE10 OKL_K_HEADERS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

Line 56: ,ATTRIBUTE7 OKL_K_HEADERS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

52: ,ATTRIBUTE3 OKL_K_HEADERS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
53: ,ATTRIBUTE4 OKL_K_HEADERS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
54: ,ATTRIBUTE5 OKL_K_HEADERS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
55: ,ATTRIBUTE6 OKL_K_HEADERS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
56: ,ATTRIBUTE7 OKL_K_HEADERS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
57: ,ATTRIBUTE8 OKL_K_HEADERS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
58: ,ATTRIBUTE9 OKL_K_HEADERS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
59: ,ATTRIBUTE10 OKL_K_HEADERS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
60: ,ATTRIBUTE11 OKL_K_HEADERS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

Line 57: ,ATTRIBUTE8 OKL_K_HEADERS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

53: ,ATTRIBUTE4 OKL_K_HEADERS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
54: ,ATTRIBUTE5 OKL_K_HEADERS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
55: ,ATTRIBUTE6 OKL_K_HEADERS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
56: ,ATTRIBUTE7 OKL_K_HEADERS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
57: ,ATTRIBUTE8 OKL_K_HEADERS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
58: ,ATTRIBUTE9 OKL_K_HEADERS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
59: ,ATTRIBUTE10 OKL_K_HEADERS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
60: ,ATTRIBUTE11 OKL_K_HEADERS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
61: ,ATTRIBUTE12 OKL_K_HEADERS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

Line 58: ,ATTRIBUTE9 OKL_K_HEADERS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

54: ,ATTRIBUTE5 OKL_K_HEADERS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
55: ,ATTRIBUTE6 OKL_K_HEADERS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
56: ,ATTRIBUTE7 OKL_K_HEADERS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
57: ,ATTRIBUTE8 OKL_K_HEADERS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
58: ,ATTRIBUTE9 OKL_K_HEADERS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
59: ,ATTRIBUTE10 OKL_K_HEADERS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
60: ,ATTRIBUTE11 OKL_K_HEADERS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
61: ,ATTRIBUTE12 OKL_K_HEADERS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
62: ,ATTRIBUTE13 OKL_K_HEADERS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

Line 59: ,ATTRIBUTE10 OKL_K_HEADERS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

55: ,ATTRIBUTE6 OKL_K_HEADERS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
56: ,ATTRIBUTE7 OKL_K_HEADERS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
57: ,ATTRIBUTE8 OKL_K_HEADERS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
58: ,ATTRIBUTE9 OKL_K_HEADERS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
59: ,ATTRIBUTE10 OKL_K_HEADERS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
60: ,ATTRIBUTE11 OKL_K_HEADERS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
61: ,ATTRIBUTE12 OKL_K_HEADERS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
62: ,ATTRIBUTE13 OKL_K_HEADERS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
63: ,ATTRIBUTE14 OKL_K_HEADERS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

Line 60: ,ATTRIBUTE11 OKL_K_HEADERS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

56: ,ATTRIBUTE7 OKL_K_HEADERS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
57: ,ATTRIBUTE8 OKL_K_HEADERS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
58: ,ATTRIBUTE9 OKL_K_HEADERS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
59: ,ATTRIBUTE10 OKL_K_HEADERS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
60: ,ATTRIBUTE11 OKL_K_HEADERS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
61: ,ATTRIBUTE12 OKL_K_HEADERS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
62: ,ATTRIBUTE13 OKL_K_HEADERS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
63: ,ATTRIBUTE14 OKL_K_HEADERS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
64: ,ATTRIBUTE15 OKL_K_HEADERS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

Line 61: ,ATTRIBUTE12 OKL_K_HEADERS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

57: ,ATTRIBUTE8 OKL_K_HEADERS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
58: ,ATTRIBUTE9 OKL_K_HEADERS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
59: ,ATTRIBUTE10 OKL_K_HEADERS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
60: ,ATTRIBUTE11 OKL_K_HEADERS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
61: ,ATTRIBUTE12 OKL_K_HEADERS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
62: ,ATTRIBUTE13 OKL_K_HEADERS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
63: ,ATTRIBUTE14 OKL_K_HEADERS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
64: ,ATTRIBUTE15 OKL_K_HEADERS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
65: -- arajagop End added for Flexfield Support

Line 62: ,ATTRIBUTE13 OKL_K_HEADERS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

58: ,ATTRIBUTE9 OKL_K_HEADERS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
59: ,ATTRIBUTE10 OKL_K_HEADERS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
60: ,ATTRIBUTE11 OKL_K_HEADERS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
61: ,ATTRIBUTE12 OKL_K_HEADERS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
62: ,ATTRIBUTE13 OKL_K_HEADERS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
63: ,ATTRIBUTE14 OKL_K_HEADERS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
64: ,ATTRIBUTE15 OKL_K_HEADERS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
65: -- arajagop End added for Flexfield Support
66: --added abhsaxen for Legal Entity Uptake

Line 63: ,ATTRIBUTE14 OKL_K_HEADERS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

59: ,ATTRIBUTE10 OKL_K_HEADERS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
60: ,ATTRIBUTE11 OKL_K_HEADERS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
61: ,ATTRIBUTE12 OKL_K_HEADERS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
62: ,ATTRIBUTE13 OKL_K_HEADERS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
63: ,ATTRIBUTE14 OKL_K_HEADERS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
64: ,ATTRIBUTE15 OKL_K_HEADERS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
65: -- arajagop End added for Flexfield Support
66: --added abhsaxen for Legal Entity Uptake
67: ,legal_entity_id OKL_K_HEADERS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM

Line 64: ,ATTRIBUTE15 OKL_K_HEADERS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

60: ,ATTRIBUTE11 OKL_K_HEADERS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
61: ,ATTRIBUTE12 OKL_K_HEADERS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
62: ,ATTRIBUTE13 OKL_K_HEADERS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
63: ,ATTRIBUTE14 OKL_K_HEADERS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
64: ,ATTRIBUTE15 OKL_K_HEADERS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
65: -- arajagop End added for Flexfield Support
66: --added abhsaxen for Legal Entity Uptake
67: ,legal_entity_id OKL_K_HEADERS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM
68: );

Line 67: ,legal_entity_id OKL_K_HEADERS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM

63: ,ATTRIBUTE14 OKL_K_HEADERS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
64: ,ATTRIBUTE15 OKL_K_HEADERS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
65: -- arajagop End added for Flexfield Support
66: --added abhsaxen for Legal Entity Uptake
67: ,legal_entity_id OKL_K_HEADERS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM
68: );
69:
70: TYPE secAgreement_tbl_type IS TABLE OF secAgreement_rec_type
71: INDEX BY BINARY_INTEGER;

Line 93: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

89: -- End of comments
90: ----------------------------------------------------------------------------------
91: PROCEDURE create_sec_agreement(
92: p_api_version IN NUMBER
93: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
94: ,x_return_status OUT NOCOPY VARCHAR2
95: ,x_msg_count OUT NOCOPY NUMBER
96: ,x_msg_data OUT NOCOPY VARCHAR2
97: ,p_secAgreement_rec IN secAgreement_rec_type

Line 112: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

108: -- End of comments
109: ----------------------------------------------------------------------------------
110: PROCEDURE update_sec_agreement(
111: p_api_version IN NUMBER
112: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
113: ,x_return_status OUT NOCOPY VARCHAR2
114: ,x_msg_count OUT NOCOPY NUMBER
115: ,x_msg_data OUT NOCOPY VARCHAR2
116: ,p_secAgreement_rec IN secAgreement_rec_type

Line 131: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

127: -- End of comments
128: ----------------------------------------------------------------------------------
129: PROCEDURE activate_sec_agreement(
130: p_api_version IN NUMBER
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);

Line 150: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

146: -- End of comments
147: ----------------------------------------------------------------------------------
148: PROCEDURE update_sec_agreement_sts(
149: p_api_version IN NUMBER
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

Line 200: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

196: -- Version : 1.0
197: -- End of comments
198: ---------------------------------------------------------------------------
199: PROCEDURE submit_add_khr_request (p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
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,