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_CREDIT_PUB dependencies on OKC_API

Line 22: id NUMBER := OKC_API.G_MISS_NUM,

18: SUBTYPE klev_rec_type IS okl_kle_pvt.klev_rec_type;
19: SUBTYPE klev_tbl_type IS okl_kle_pvt.klev_tbl_type;
20:
21: TYPE clev_rec_type IS RECORD (
22: id NUMBER := OKC_API.G_MISS_NUM,
23: chr_id NUMBER := OKC_API.G_MISS_NUM,
24: lse_id NUMBER := OKC_API.G_MISS_NUM,
25: line_number OKC_K_LINES_V.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
26: sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 23: chr_id NUMBER := OKC_API.G_MISS_NUM,

19: SUBTYPE klev_tbl_type IS okl_kle_pvt.klev_tbl_type;
20:
21: TYPE clev_rec_type IS RECORD (
22: id NUMBER := OKC_API.G_MISS_NUM,
23: chr_id NUMBER := OKC_API.G_MISS_NUM,
24: lse_id NUMBER := OKC_API.G_MISS_NUM,
25: line_number OKC_K_LINES_V.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
26: sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: display_sequence NUMBER := OKC_API.G_MISS_NUM,

Line 24: lse_id NUMBER := OKC_API.G_MISS_NUM,

20:
21: TYPE clev_rec_type IS RECORD (
22: id NUMBER := OKC_API.G_MISS_NUM,
23: chr_id NUMBER := OKC_API.G_MISS_NUM,
24: lse_id NUMBER := OKC_API.G_MISS_NUM,
25: line_number OKC_K_LINES_V.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
26: sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: display_sequence NUMBER := OKC_API.G_MISS_NUM,
28: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,

Line 25: line_number OKC_K_LINES_V.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,

21: TYPE clev_rec_type IS RECORD (
22: id NUMBER := OKC_API.G_MISS_NUM,
23: chr_id NUMBER := OKC_API.G_MISS_NUM,
24: lse_id NUMBER := OKC_API.G_MISS_NUM,
25: line_number OKC_K_LINES_V.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
26: sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: display_sequence NUMBER := OKC_API.G_MISS_NUM,
28: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
29: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

Line 26: sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,

22: id NUMBER := OKC_API.G_MISS_NUM,
23: chr_id NUMBER := OKC_API.G_MISS_NUM,
24: lse_id NUMBER := OKC_API.G_MISS_NUM,
25: line_number OKC_K_LINES_V.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
26: sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: display_sequence NUMBER := OKC_API.G_MISS_NUM,
28: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
29: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
30: exception_yn OKC_K_LINES_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,

Line 27: display_sequence NUMBER := OKC_API.G_MISS_NUM,

23: chr_id NUMBER := OKC_API.G_MISS_NUM,
24: lse_id NUMBER := OKC_API.G_MISS_NUM,
25: line_number OKC_K_LINES_V.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
26: sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: display_sequence NUMBER := OKC_API.G_MISS_NUM,
28: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
29: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
30: exception_yn OKC_K_LINES_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
31: start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE

Line 28: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,

24: lse_id NUMBER := OKC_API.G_MISS_NUM,
25: line_number OKC_K_LINES_V.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
26: sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: display_sequence NUMBER := OKC_API.G_MISS_NUM,
28: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
29: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
30: exception_yn OKC_K_LINES_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
31: start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
32: );

Line 29: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

25: line_number OKC_K_LINES_V.LINE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
26: sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: display_sequence NUMBER := OKC_API.G_MISS_NUM,
28: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
29: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
30: exception_yn OKC_K_LINES_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
31: start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
32: );
33:

Line 30: exception_yn OKC_K_LINES_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,

26: sts_code OKC_K_LINES_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: display_sequence NUMBER := OKC_API.G_MISS_NUM,
28: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
29: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
30: exception_yn OKC_K_LINES_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
31: start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
32: );
33:
34: TYPE clev_tbl_type IS TABLE OF clev_rec_type

Line 31: start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE

27: display_sequence NUMBER := OKC_API.G_MISS_NUM,
28: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
29: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
30: exception_yn OKC_K_LINES_V.EXCEPTION_YN%TYPE := OKC_API.G_MISS_CHAR,
31: start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
32: );
33:
34: TYPE clev_tbl_type IS TABLE OF clev_rec_type
35: INDEX BY BINARY_INTEGER;

Line 38: id NUMBER := OKC_API.G_MISS_NUM,

34: TYPE clev_tbl_type IS TABLE OF clev_rec_type
35: INDEX BY BINARY_INTEGER;
36:
37: TYPE crdv_rec_type IS RECORD (
38: id NUMBER := OKC_API.G_MISS_NUM,
39: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
40: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: party_roles_id NUMBER := OKC_API.G_MISS_NUM,
42: customer_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,

Line 39: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,

35: INDEX BY BINARY_INTEGER;
36:
37: TYPE crdv_rec_type IS RECORD (
38: id NUMBER := OKC_API.G_MISS_NUM,
39: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
40: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: party_roles_id NUMBER := OKC_API.G_MISS_NUM,
42: customer_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
43: customer_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,

Line 40: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

36:
37: TYPE crdv_rec_type IS RECORD (
38: id NUMBER := OKC_API.G_MISS_NUM,
39: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
40: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: party_roles_id NUMBER := OKC_API.G_MISS_NUM,
42: customer_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
43: customer_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
44: customer_code OKC_K_PARTY_ROLES_B.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 41: party_roles_id NUMBER := OKC_API.G_MISS_NUM,

37: TYPE crdv_rec_type IS RECORD (
38: id NUMBER := OKC_API.G_MISS_NUM,
39: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
40: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: party_roles_id NUMBER := OKC_API.G_MISS_NUM,
42: customer_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
43: customer_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
44: customer_code OKC_K_PARTY_ROLES_B.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
45: customer_name OKX_PARTIES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,

Line 42: customer_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,

38: id NUMBER := OKC_API.G_MISS_NUM,
39: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
40: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: party_roles_id NUMBER := OKC_API.G_MISS_NUM,
42: customer_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
43: customer_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
44: customer_code OKC_K_PARTY_ROLES_B.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
45: customer_name OKX_PARTIES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
46: effective_from OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 43: customer_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,

39: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
40: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: party_roles_id NUMBER := OKC_API.G_MISS_NUM,
42: customer_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
43: customer_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
44: customer_code OKC_K_PARTY_ROLES_B.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
45: customer_name OKX_PARTIES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
46: effective_from OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
47: effective_to OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 44: customer_code OKC_K_PARTY_ROLES_B.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,

40: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: party_roles_id NUMBER := OKC_API.G_MISS_NUM,
42: customer_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
43: customer_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
44: customer_code OKC_K_PARTY_ROLES_B.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
45: customer_name OKX_PARTIES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
46: effective_from OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
47: effective_to OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
48: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 45: customer_name OKX_PARTIES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,

41: party_roles_id NUMBER := OKC_API.G_MISS_NUM,
42: customer_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
43: customer_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
44: customer_code OKC_K_PARTY_ROLES_B.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
45: customer_name OKX_PARTIES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
46: effective_from OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
47: effective_to OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
48: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
49: currency_conv_type OKL_K_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,

Line 46: effective_from OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,

42: customer_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
43: customer_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
44: customer_code OKC_K_PARTY_ROLES_B.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
45: customer_name OKX_PARTIES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
46: effective_from OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
47: effective_to OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
48: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
49: currency_conv_type OKL_K_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: currency_conv_rate NUMBER := OKC_API.G_MISS_NUM,

Line 47: effective_to OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,

43: customer_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
44: customer_code OKC_K_PARTY_ROLES_B.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
45: customer_name OKX_PARTIES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
46: effective_from OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
47: effective_to OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
48: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
49: currency_conv_type OKL_K_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: currency_conv_rate NUMBER := OKC_API.G_MISS_NUM,
51: currency_conv_date OKL_K_HEADERS.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 48: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,

44: customer_code OKC_K_PARTY_ROLES_B.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
45: customer_name OKX_PARTIES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
46: effective_from OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
47: effective_to OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
48: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
49: currency_conv_type OKL_K_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: currency_conv_rate NUMBER := OKC_API.G_MISS_NUM,
51: currency_conv_date OKL_K_HEADERS.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
52: revolving_credit_yn OKL_K_HEADERS.REVOLVING_CREDIT_YN%TYPE := OKC_API.G_MISS_CHAR,

Line 49: currency_conv_type OKL_K_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,

45: customer_name OKX_PARTIES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
46: effective_from OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
47: effective_to OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
48: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
49: currency_conv_type OKL_K_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: currency_conv_rate NUMBER := OKC_API.G_MISS_NUM,
51: currency_conv_date OKL_K_HEADERS.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
52: revolving_credit_yn OKL_K_HEADERS.REVOLVING_CREDIT_YN%TYPE := OKC_API.G_MISS_CHAR,
53: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 50: currency_conv_rate NUMBER := OKC_API.G_MISS_NUM,

46: effective_from OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
47: effective_to OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
48: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
49: currency_conv_type OKL_K_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: currency_conv_rate NUMBER := OKC_API.G_MISS_NUM,
51: currency_conv_date OKL_K_HEADERS.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
52: revolving_credit_yn OKL_K_HEADERS.REVOLVING_CREDIT_YN%TYPE := OKC_API.G_MISS_CHAR,
53: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
54: credit_ckl_id NUMBER := OKC_API.G_MISS_NUM,

Line 51: currency_conv_date OKL_K_HEADERS.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,

47: effective_to OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
48: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
49: currency_conv_type OKL_K_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: currency_conv_rate NUMBER := OKC_API.G_MISS_NUM,
51: currency_conv_date OKL_K_HEADERS.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
52: revolving_credit_yn OKL_K_HEADERS.REVOLVING_CREDIT_YN%TYPE := OKC_API.G_MISS_CHAR,
53: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
54: credit_ckl_id NUMBER := OKC_API.G_MISS_NUM,
55: funding_ckl_id NUMBER := OKC_API.G_MISS_NUM,

Line 52: revolving_credit_yn OKL_K_HEADERS.REVOLVING_CREDIT_YN%TYPE := OKC_API.G_MISS_CHAR,

48: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
49: currency_conv_type OKL_K_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: currency_conv_rate NUMBER := OKC_API.G_MISS_NUM,
51: currency_conv_date OKL_K_HEADERS.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
52: revolving_credit_yn OKL_K_HEADERS.REVOLVING_CREDIT_YN%TYPE := OKC_API.G_MISS_CHAR,
53: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
54: credit_ckl_id NUMBER := OKC_API.G_MISS_NUM,
55: funding_ckl_id NUMBER := OKC_API.G_MISS_NUM,
56: chklst_tpl_rgp_id NUMBER := OKC_API.G_MISS_NUM,

Line 53: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,

49: currency_conv_type OKL_K_HEADERS.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: currency_conv_rate NUMBER := OKC_API.G_MISS_NUM,
51: currency_conv_date OKL_K_HEADERS.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
52: revolving_credit_yn OKL_K_HEADERS.REVOLVING_CREDIT_YN%TYPE := OKC_API.G_MISS_CHAR,
53: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
54: credit_ckl_id NUMBER := OKC_API.G_MISS_NUM,
55: funding_ckl_id NUMBER := OKC_API.G_MISS_NUM,
56: chklst_tpl_rgp_id NUMBER := OKC_API.G_MISS_NUM,
57: chklst_tpl_rule_id NUMBER := OKC_API.G_MISS_NUM,

Line 54: credit_ckl_id NUMBER := OKC_API.G_MISS_NUM,

50: currency_conv_rate NUMBER := OKC_API.G_MISS_NUM,
51: currency_conv_date OKL_K_HEADERS.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
52: revolving_credit_yn OKL_K_HEADERS.REVOLVING_CREDIT_YN%TYPE := OKC_API.G_MISS_CHAR,
53: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
54: credit_ckl_id NUMBER := OKC_API.G_MISS_NUM,
55: funding_ckl_id NUMBER := OKC_API.G_MISS_NUM,
56: chklst_tpl_rgp_id NUMBER := OKC_API.G_MISS_NUM,
57: chklst_tpl_rule_id NUMBER := OKC_API.G_MISS_NUM,
58: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,

Line 55: funding_ckl_id NUMBER := OKC_API.G_MISS_NUM,

51: currency_conv_date OKL_K_HEADERS.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
52: revolving_credit_yn OKL_K_HEADERS.REVOLVING_CREDIT_YN%TYPE := OKC_API.G_MISS_CHAR,
53: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
54: credit_ckl_id NUMBER := OKC_API.G_MISS_NUM,
55: funding_ckl_id NUMBER := OKC_API.G_MISS_NUM,
56: chklst_tpl_rgp_id NUMBER := OKC_API.G_MISS_NUM,
57: chklst_tpl_rule_id NUMBER := OKC_API.G_MISS_NUM,
58: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
59: cust_acct_number OKX_CUSTOMER_ACCOUNTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

Line 56: chklst_tpl_rgp_id NUMBER := OKC_API.G_MISS_NUM,

52: revolving_credit_yn OKL_K_HEADERS.REVOLVING_CREDIT_YN%TYPE := OKC_API.G_MISS_CHAR,
53: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
54: credit_ckl_id NUMBER := OKC_API.G_MISS_NUM,
55: funding_ckl_id NUMBER := OKC_API.G_MISS_NUM,
56: chklst_tpl_rgp_id NUMBER := OKC_API.G_MISS_NUM,
57: chklst_tpl_rule_id NUMBER := OKC_API.G_MISS_NUM,
58: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
59: cust_acct_number OKX_CUSTOMER_ACCOUNTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
60: );

Line 57: chklst_tpl_rule_id NUMBER := OKC_API.G_MISS_NUM,

53: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
54: credit_ckl_id NUMBER := OKC_API.G_MISS_NUM,
55: funding_ckl_id NUMBER := OKC_API.G_MISS_NUM,
56: chklst_tpl_rgp_id NUMBER := OKC_API.G_MISS_NUM,
57: chklst_tpl_rule_id NUMBER := OKC_API.G_MISS_NUM,
58: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
59: cust_acct_number OKX_CUSTOMER_ACCOUNTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
60: );
61:

Line 58: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,

54: credit_ckl_id NUMBER := OKC_API.G_MISS_NUM,
55: funding_ckl_id NUMBER := OKC_API.G_MISS_NUM,
56: chklst_tpl_rgp_id NUMBER := OKC_API.G_MISS_NUM,
57: chklst_tpl_rule_id NUMBER := OKC_API.G_MISS_NUM,
58: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
59: cust_acct_number OKX_CUSTOMER_ACCOUNTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
60: );
61:
62: TYPE crdv_tbl_type IS TABLE OF crdv_rec_type

Line 59: cust_acct_number OKX_CUSTOMER_ACCOUNTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

55: funding_ckl_id NUMBER := OKC_API.G_MISS_NUM,
56: chklst_tpl_rgp_id NUMBER := OKC_API.G_MISS_NUM,
57: chklst_tpl_rule_id NUMBER := OKC_API.G_MISS_NUM,
58: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
59: cust_acct_number OKX_CUSTOMER_ACCOUNTS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
60: );
61:
62: TYPE crdv_tbl_type IS TABLE OF crdv_rec_type
63: INDEX BY BINARY_INTEGER;

Line 66: id NUMBER := OKC_API.G_MISS_NUM,

62: TYPE crdv_tbl_type IS TABLE OF crdv_rec_type
63: INDEX BY BINARY_INTEGER;
64:
65: TYPE clmv_rec_type IS RECORD (
66: id NUMBER := OKC_API.G_MISS_NUM,
67: chr_id NUMBER := OKC_API.G_MISS_NUM,
68: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
69: start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
70: credit_nature OKL_K_LINES.CREDIT_NATURE%TYPE := OKC_API.G_MISS_CHAR,

Line 67: chr_id NUMBER := OKC_API.G_MISS_NUM,

63: INDEX BY BINARY_INTEGER;
64:
65: TYPE clmv_rec_type IS RECORD (
66: id NUMBER := OKC_API.G_MISS_NUM,
67: chr_id NUMBER := OKC_API.G_MISS_NUM,
68: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
69: start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
70: credit_nature OKL_K_LINES.CREDIT_NATURE%TYPE := OKC_API.G_MISS_CHAR,
71: amount NUMBER := OKC_API.G_MISS_NUM

Line 68: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

64:
65: TYPE clmv_rec_type IS RECORD (
66: id NUMBER := OKC_API.G_MISS_NUM,
67: chr_id NUMBER := OKC_API.G_MISS_NUM,
68: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
69: start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
70: credit_nature OKL_K_LINES.CREDIT_NATURE%TYPE := OKC_API.G_MISS_CHAR,
71: amount NUMBER := OKC_API.G_MISS_NUM
72: );

Line 69: start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,

65: TYPE clmv_rec_type IS RECORD (
66: id NUMBER := OKC_API.G_MISS_NUM,
67: chr_id NUMBER := OKC_API.G_MISS_NUM,
68: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
69: start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
70: credit_nature OKL_K_LINES.CREDIT_NATURE%TYPE := OKC_API.G_MISS_CHAR,
71: amount NUMBER := OKC_API.G_MISS_NUM
72: );
73:

Line 70: credit_nature OKL_K_LINES.CREDIT_NATURE%TYPE := OKC_API.G_MISS_CHAR,

66: id NUMBER := OKC_API.G_MISS_NUM,
67: chr_id NUMBER := OKC_API.G_MISS_NUM,
68: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
69: start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
70: credit_nature OKL_K_LINES.CREDIT_NATURE%TYPE := OKC_API.G_MISS_CHAR,
71: amount NUMBER := OKC_API.G_MISS_NUM
72: );
73:
74: TYPE clmv_tbl_type IS TABLE OF clmv_rec_type

Line 71: amount NUMBER := OKC_API.G_MISS_NUM

67: chr_id NUMBER := OKC_API.G_MISS_NUM,
68: item_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
69: start_date OKC_K_LINES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
70: credit_nature OKL_K_LINES.CREDIT_NATURE%TYPE := OKC_API.G_MISS_CHAR,
71: amount NUMBER := OKC_API.G_MISS_NUM
72: );
73:
74: TYPE clmv_tbl_type IS TABLE OF clmv_rec_type
75: INDEX BY BINARY_INTEGER;

Line 106: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

102: * @rep:category BUSINESS_ENTITY OKL_UNDERWRITING
103: */
104: PROCEDURE create_credit(
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_msg_count OUT NOCOPY NUMBER,
109: x_msg_data OUT NOCOPY VARCHAR2,
110: p_crdv_rec IN crdv_rec_type,

Line 117: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

113: x_clmv_tbl OUT NOCOPY clmv_tbl_type);
114:
115: PROCEDURE create_credit(
116: p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: --

Line 187: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

183: x_khrv_rec OUT NOCOPY khrv_rec_type);
184:
185: PROCEDURE validate_credit(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_chr_id IN NUMBER,

Line 216: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

212: p_sts_code IN VARCHAR2);
213:
214: PROCEDURE validate_account_number(
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,
220: p_account_number IN VARCHAR2);

Line 224: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

220: p_account_number IN VARCHAR2);
221:
222: PROCEDURE validate_credit_limit(
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_mode IN VARCHAR2 DEFAULT 'CREATE',

Line 238: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

234: p_amount IN NUMBER DEFAULT 0);
235:
236: PROCEDURE validate_credit_limit(
237: p_api_version IN NUMBER,
238: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
239: x_return_status OUT NOCOPY VARCHAR2,
240: x_msg_count OUT NOCOPY NUMBER,
241: x_msg_data OUT NOCOPY VARCHAR2,
242: p_mode IN VARCHAR2 DEFAULT 'CREATE',

Line 249: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

245: p_klev_rec IN klev_rec_type);
246:
247: PROCEDURE validate_credit_limit(
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,
252: x_msg_data OUT NOCOPY VARCHAR2,
253: p_mode IN VARCHAR2 DEFAULT 'CREATE',

Line 260: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

256: p_klev_tbl IN klev_tbl_type);
257:
258: PROCEDURE create_credit_limit(
259: p_api_version IN NUMBER,
260: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
261: x_return_status OUT NOCOPY VARCHAR2,
262: x_msg_count OUT NOCOPY NUMBER,
263: x_msg_data OUT NOCOPY VARCHAR2,
264: -- p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,

Line 273: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

269: x_klev_tbl OUT NOCOPY klev_tbl_type);
270:
271: PROCEDURE update_credit_limit(
272: p_api_version IN NUMBER,
273: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
274: x_return_status OUT NOCOPY VARCHAR2,
275: x_msg_count OUT NOCOPY NUMBER,
276: x_msg_data OUT NOCOPY VARCHAR2,
277: -- p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,

Line 286: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

282: x_klev_tbl OUT NOCOPY klev_tbl_type);
283:
284: PROCEDURE delete_credit_limit(
285: p_api_version IN NUMBER,
286: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
287: x_return_status OUT NOCOPY VARCHAR2,
288: x_msg_count OUT NOCOPY NUMBER,
289: x_msg_data OUT NOCOPY VARCHAR2,
290: -- p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,

Line 420: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

416: * @rep:category BUSINESS_ENTITY OKL_UNDERWRITING
417: */
418: PROCEDURE activate_credit(
419: p_api_version IN NUMBER,
420: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
421: x_return_status OUT NOCOPY VARCHAR2,
422: x_msg_count OUT NOCOPY NUMBER,
423: x_msg_data OUT NOCOPY VARCHAR2,
424: p_chr_id IN NUMBER,