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.

[Home] [Help]

APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKC_K_HEADERS_V

Line 94: -- FUNCTION get_chrv_rec for: OKC_K_HEADERS_V

90: END Report_Error;
91:
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_chrv_rec for: OKC_K_HEADERS_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_chrv_rec (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
97: x_return_status OUT NOCOPY VARCHAR2)
98: RETURN chrv_rec_type IS

Line 96: FUNCTION get_chrv_rec (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_chrv_rec for: OKC_K_HEADERS_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_chrv_rec (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
97: x_return_status OUT NOCOPY VARCHAR2)
98: RETURN chrv_rec_type IS
99: CURSOR okc_chrv_pk_csr(p_id OKC_K_HEADERS_V.ID%TYPE) IS
100: SELECT ID,

Line 99: CURSOR okc_chrv_pk_csr(p_id OKC_K_HEADERS_V.ID%TYPE) IS

95: ---------------------------------------------------------------------------
96: FUNCTION get_chrv_rec (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
97: x_return_status OUT NOCOPY VARCHAR2)
98: RETURN chrv_rec_type IS
99: CURSOR okc_chrv_pk_csr(p_id OKC_K_HEADERS_V.ID%TYPE) IS
100: SELECT ID,
101: OBJECT_VERSION_NUMBER,
102: SFWT_FLAG,
103: CHR_ID_RESPONSE,

Line 178: FROM okc_k_headers_v chrv

174: CREATION_DATE,
175: LAST_UPDATED_BY,
176: LAST_UPDATE_DATE,
177: LAST_UPDATE_LOGIN
178: FROM okc_k_headers_v chrv
179: WHERE chrv.id = p_id;
180: x_chrv_rec chrv_rec_type;
181: BEGIN
182: OPEN okc_chrv_pk_csr (p_chr_id);

Line 511: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

507: PROCEDURE copy_rebook_stream(
508: x_return_status OUT NOCOPY VARCHAR2,
509: x_msg_count OUT NOCOPY NUMBER,
510: x_msg_data OUT NOCOPY VARCHAR2,
511: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
512: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE
513: ) IS
514: l_proc_name VARCHAR2(35) := 'COPY_REBOOK_STREAM';
515: l_stmv_rec stmv_rec_type;

Line 512: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE

508: x_return_status OUT NOCOPY VARCHAR2,
509: x_msg_count OUT NOCOPY NUMBER,
510: x_msg_data OUT NOCOPY VARCHAR2,
511: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
512: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE
513: ) IS
514: l_proc_name VARCHAR2(35) := 'COPY_REBOOK_STREAM';
515: l_stmv_rec stmv_rec_type;
516: l_selv_tbl selv_tbl_type;

Line 522: CURSOR strm_hdr_csr (p_rebook_chr_id OKC_K_HEADERS_V.ID%TYPE) IS -- Bug 3984890

518: x_selv_tbl selv_tbl_type;
519: l_no_of_ele NUMBER := 0;
520: copy_failed EXCEPTION;
521:
522: CURSOR strm_hdr_csr (p_rebook_chr_id OKC_K_HEADERS_V.ID%TYPE) IS -- Bug 3984890
523: SELECT
524: str.id,
525: str.sty_id,
526: str.khr_id,

Line 560: CURSOR orig_strm_csr (p_khr_id OKC_K_HEADERS_V.ID%TYPE,

556: AND str.say_code = 'CURR';
557:
558:
559: -- Bug# 2857333
560: CURSOR orig_strm_csr (p_khr_id OKC_K_HEADERS_V.ID%TYPE,
561: p_kle_id OKC_K_LINES_V.ID%TYPE,
562: p_sty_id OKL_STREAMS.sty_id%TYPE,
563: p_purpose_code OKL_STREAMS.PURPOSE_CODE%TYPE) IS
564: SELECT id

Line 1079: x_orig_chr_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE

1075: ------------------------------------------------------------------------------
1076: PROCEDURE get_orig_chr_id(
1077: x_return_status OUT NOCOPY VARCHAR2,
1078: p_chr_id IN NUMBER,
1079: x_orig_chr_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE
1080: ) IS
1081:
1082: l_proc_name VARCHAR2(35) := 'GET_ORIG_CHR_ID';
1083: l_orig_system_id OKC_K_HEADERS_V.ID%TYPE;

Line 1083: l_orig_system_id OKC_K_HEADERS_V.ID%TYPE;

1079: x_orig_chr_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE
1080: ) IS
1081:
1082: l_proc_name VARCHAR2(35) := 'GET_ORIG_CHR_ID';
1083: l_orig_system_id OKC_K_HEADERS_V.ID%TYPE;
1084: orig_failed EXCEPTION;
1085:
1086: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.id%TYPE) IS
1087: SELECT orig_system_id1

Line 1086: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.id%TYPE) IS

1082: l_proc_name VARCHAR2(35) := 'GET_ORIG_CHR_ID';
1083: l_orig_system_id OKC_K_HEADERS_V.ID%TYPE;
1084: orig_failed EXCEPTION;
1085:
1086: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.id%TYPE) IS
1087: SELECT orig_system_id1
1088: FROM OKC_K_HEADERS_V
1089: WHERE id = p_chr_id;
1090:

Line 1088: FROM OKC_K_HEADERS_V

1084: orig_failed EXCEPTION;
1085:
1086: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.id%TYPE) IS
1087: SELECT orig_system_id1
1088: FROM OKC_K_HEADERS_V
1089: WHERE id = p_chr_id;
1090:
1091: BEGIN
1092: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 1137: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

1133: PROCEDURE change_stream_status(
1134: x_return_status OUT NOCOPY VARCHAR2,
1135: x_msg_count OUT NOCOPY NUMBER,
1136: x_msg_data OUT NOCOPY VARCHAR2,
1137: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1138: p_status IN VARCHAR2,
1139: p_active_yn IN VARCHAR2
1140: ) IS
1141:

Line 1148: CURSOR strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

1144: x_stmv_rec stmv_rec_type;
1145: strm_failed EXCEPTION;
1146: l_id NUMBER;
1147:
1148: CURSOR strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1149: SELECT id
1150: FROM okl_streams
1151: WHERE khr_id = p_chr_id
1152: -- BUg 4737555

Line 1601: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

1597: x_return_status OUT NOCOPY VARCHAR2,
1598: x_msg_count OUT NOCOPY NUMBER,
1599: x_msg_data OUT NOCOPY VARCHAR2,
1600: p_for_line IN VARCHAR2, -- DEFAULT 'N',
1601: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1602: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE
1603: ) IS
1604:
1605: l_proc_name VARCHAR2(35) := 'SYNC_HEADER_SLH_SLL';

Line 1602: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE

1598: x_msg_count OUT NOCOPY NUMBER,
1599: x_msg_data OUT NOCOPY VARCHAR2,
1600: p_for_line IN VARCHAR2, -- DEFAULT 'N',
1601: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1602: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE
1603: ) IS
1604:
1605: l_proc_name VARCHAR2(35) := 'SYNC_HEADER_SLH_SLL';
1606: sync_header_failed EXCEPTION;

Line 1608: CURSOR rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

1604:
1605: l_proc_name VARCHAR2(35) := 'SYNC_HEADER_SLH_SLL';
1606: sync_header_failed EXCEPTION;
1607:
1608: CURSOR rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1609: SELECT
1610: id
1611: ,object_version_number
1612: ,sfwt_flag

Line 1647: CURSOR orig_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

1643: WHERE dnz_chr_id = p_chr_id
1644: AND cle_id IS NULL
1645: AND rgd_code = 'LALEVL';
1646:
1647: CURSOR orig_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1648:
1649: SELECT id
1650: FROM okc_rule_groups_v
1651: WHERE dnz_chr_id = p_chr_id

Line 1840: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

1836: x_return_status OUT NOCOPY VARCHAR2,
1837: x_msg_count OUT NOCOPY NUMBER,
1838: x_msg_data OUT NOCOPY VARCHAR2,
1839: p_for_line IN VARCHAR2, -- DEFAULT 'N',
1840: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1841: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE
1842: ) IS
1843:
1844: l_proc_name VARCHAR2(35) := 'SYNC_SLH_SLL';

Line 1841: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE

1837: x_msg_count OUT NOCOPY NUMBER,
1838: x_msg_data OUT NOCOPY VARCHAR2,
1839: p_for_line IN VARCHAR2, -- DEFAULT 'N',
1840: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1841: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE
1842: ) IS
1843:
1844: l_proc_name VARCHAR2(35) := 'SYNC_SLH_SLL';
1845: sync_failed EXCEPTION;

Line 1871: CURSOR rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

1867:
1868: l_rulv_tbl rulv_tbl_type;
1869: i NUMBER := 0;
1870:
1871: CURSOR rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1872: SELECT
1873: id
1874: ,object_version_number
1875: ,sfwt_flag

Line 1915: p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

1911: FROM okc_k_lines_v
1912: WHERE id = p_cle_id;
1913:
1914: CURSOR orig_rgp_csr(p_cle_id OKC_K_LINES_V.ID%TYPE,
1915: p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1916: SELECT id
1917: FROM okc_rule_groups_v
1918: WHERE dnz_chr_id = p_chr_id
1919: AND ((cle_id = p_cle_id AND p_cle_id IS NOT NULL)

Line 1924: CURSOR del_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

1920: OR
1921: cle_id IS NULL AND p_cle_id IS NULL)
1922: AND rgd_code = 'LALEVL';
1923:
1924: CURSOR del_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1925: SELECT id
1926: FROM okc_rule_groups_v
1927: WHERE dnz_chr_id = p_chr_id
1928: AND rgd_code = 'LALEVL';

Line 2155: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

2151: PROCEDURE sync_sales_tax (
2152: x_return_status OUT NOCOPY VARCHAR2,
2153: x_msg_count OUT NOCOPY NUMBER,
2154: x_msg_data OUT NOCOPY VARCHAR2,
2155: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2156: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE
2157: ) IS
2158:
2159: l_proc_name VARCHAR2(35) := 'SYNC_SALES_TAX';

Line 2156: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE

2152: x_return_status OUT NOCOPY VARCHAR2,
2153: x_msg_count OUT NOCOPY NUMBER,
2154: x_msg_data OUT NOCOPY VARCHAR2,
2155: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2156: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE
2157: ) IS
2158:
2159: l_proc_name VARCHAR2(35) := 'SYNC_SALES_TAX';
2160: sync_tax_failed EXCEPTION;

Line 2457: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

2453: PROCEDURE sync_party_role(
2454: x_return_status OUT NOCOPY VARCHAR2,
2455: x_msg_count OUT NOCOPY NUMBER,
2456: x_msg_data OUT NOCOPY VARCHAR2,
2457: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2458: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE
2459: ) IS
2460:
2461: CURSOR rebook_party_csr (p_rebook_chr_id OKC_K_HEADERS_B.ID%TYPE,

Line 2458: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE

2454: x_return_status OUT NOCOPY VARCHAR2,
2455: x_msg_count OUT NOCOPY NUMBER,
2456: x_msg_data OUT NOCOPY VARCHAR2,
2457: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2458: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE
2459: ) IS
2460:
2461: CURSOR rebook_party_csr (p_rebook_chr_id OKC_K_HEADERS_B.ID%TYPE,
2462: p_orig_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

Line 2831: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

2827: PROCEDURE sync_header_values(
2828: x_return_status OUT NOCOPY VARCHAR2,
2829: x_msg_count OUT NOCOPY NUMBER,
2830: x_msg_data OUT NOCOPY VARCHAR2,
2831: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2832: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE
2833: ) IS
2834:
2835: CURSOR header_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

Line 2832: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE

2828: x_return_status OUT NOCOPY VARCHAR2,
2829: x_msg_count OUT NOCOPY NUMBER,
2830: x_msg_data OUT NOCOPY VARCHAR2,
2831: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2832: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE
2833: ) IS
2834:
2835: CURSOR header_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
2836: SELECT start_date,

Line 2835: CURSOR header_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

2831: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2832: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE
2833: ) IS
2834:
2835: CURSOR header_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
2836: SELECT start_date,
2837: end_date,
2838: term_duration,
2839: pre_tax_yield,

Line 3530: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

3526: PROCEDURE sync_fee_line(
3527: x_return_status OUT NOCOPY VARCHAR2,
3528: x_msg_count OUT NOCOPY NUMBER,
3529: x_msg_data OUT NOCOPY VARCHAR2,
3530: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
3531: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE
3532: ) IS
3533:
3534: CURSOR fee_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

Line 3531: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE

3527: x_return_status OUT NOCOPY VARCHAR2,
3528: x_msg_count OUT NOCOPY NUMBER,
3529: x_msg_data OUT NOCOPY VARCHAR2,
3530: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
3531: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE
3532: ) IS
3533:
3534: CURSOR fee_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3535: SELECT line.*

Line 3534: CURSOR fee_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

3530: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
3531: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE
3532: ) IS
3533:
3534: CURSOR fee_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3535: SELECT line.*
3536: FROM okl_k_Lines_full_v line,
3537: okc_line_styles_v style
3538: WHERE line.sts_code = 'BOOKED'

Line 3550: CURSOR rbk_new_fee_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

3546: FROM okc_k_lines_v
3547: WHERE cle_id = p_cle_id
3548: AND sts_code = 'BOOKED';
3549:
3550: CURSOR rbk_new_fee_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3551: SELECT line.*
3552: FROM okl_k_Lines_full_v line,
3553: okc_line_styles_v style
3554: WHERE style.lty_code = 'FEE'

Line 3565: CURSOR txn_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

3561: FROM okl_streams
3562: WHERE kle_id = p_kle_id
3563: AND say_code <> 'HIST';
3564:
3565: CURSOR txn_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3566: SELECT trx_number,
3567: rbr_code,
3568: date_transaction_occurred
3569: FROM okl_trx_contracts

Line 4644: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

4640: PROCEDURE sync_line_values(
4641: x_return_status OUT NOCOPY VARCHAR2,
4642: x_msg_count OUT NOCOPY NUMBER,
4643: x_msg_data OUT NOCOPY VARCHAR2,
4644: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
4645: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
4646: x_new_klev_tbl OUT NOCOPY klev_tbl_type,
4647: x_new_clev_tbl OUT NOCOPY clev_tbl_type
4648: ) IS

Line 4645: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

4641: x_return_status OUT NOCOPY VARCHAR2,
4642: x_msg_count OUT NOCOPY NUMBER,
4643: x_msg_data OUT NOCOPY VARCHAR2,
4644: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
4645: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
4646: x_new_klev_tbl OUT NOCOPY klev_tbl_type,
4647: x_new_clev_tbl OUT NOCOPY clev_tbl_type
4648: ) IS
4649:

Line 4653: CURSOR rebook_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

4649:
4650: l_proc_name VARCHAR2(35) := 'SYNC_LINE_VALUES';
4651: sync_failed EXCEPTION;
4652:
4653: CURSOR rebook_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4654: SELECT *
4655: FROM okl_k_lines_full_v
4656: WHERE dnz_chr_id = p_chr_id
4657: AND orig_system_id1 IS NOT NULL;

Line 4659: CURSOR rebook_new_line_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

4655: FROM okl_k_lines_full_v
4656: WHERE dnz_chr_id = p_chr_id
4657: AND orig_system_id1 IS NOT NULL;
4658:
4659: CURSOR rebook_new_line_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4660: SELECT line.*
4661: FROM okl_k_lines_full_v line,
4662: okc_line_styles_v style
4663: WHERE line.dnz_chr_id = p_chr_id

Line 4669: CURSOR rebook_new_ib_line_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

4665: AND style.lty_code = 'FREE_FORM1'
4666: AND orig_system_id1 IS NULL;
4667:
4668: --Bug# 5207066
4669: CURSOR rebook_new_ib_line_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4670: SELECT line.*,
4671: parent_cle.orig_system_id1 parent_orig_system_id1,
4672: parent_cle.start_date parent_orig_start_date
4673: FROM okl_k_lines_full_v line,

Line 4684: CURSOR del_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

4680: AND parent_cle.orig_system_id1 IS NOT NULL
4681: AND line.cle_id = parent_cle.id
4682: AND line.dnz_chr_id = parent_cle.dnz_chr_id;
4683:
4684: CURSOR del_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4685: SELECT id
4686: FROM okc_rule_groups_v
4687: WHERE dnz_chr_id = p_chr_id
4688: AND rgd_code = 'LALEVL';

Line 5170: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE

5166: PROCEDURE version_contract(
5167: x_return_status OUT NOCOPY VARCHAR2,
5168: x_msg_count OUT NOCOPY NUMBER,
5169: x_msg_data OUT NOCOPY VARCHAR2,
5170: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE
5171: ) IS
5172:
5173: l_proc_name VARCHAR2(35) := 'VERSION_CONTRACT';
5174: l_cvmv_rec cvmv_rec_type;

Line 5215: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

5211: PROCEDURE check_and_update_date(
5212: x_return_status OUT NOCOPY VARCHAR2,
5213: x_msg_count OUT NOCOPY NUMBER,
5214: x_msg_data OUT NOCOPY VARCHAR2,
5215: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
5216: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE
5217: ) IS
5218: CURSOR term_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5219: SELECT term_duration,

Line 5216: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE

5212: x_return_status OUT NOCOPY VARCHAR2,
5213: x_msg_count OUT NOCOPY NUMBER,
5214: x_msg_data OUT NOCOPY VARCHAR2,
5215: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
5216: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE
5217: ) IS
5218: CURSOR term_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5219: SELECT term_duration,
5220: start_date

Line 5218: CURSOR term_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

5214: x_msg_data OUT NOCOPY VARCHAR2,
5215: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
5216: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE
5217: ) IS
5218: CURSOR term_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5219: SELECT term_duration,
5220: start_date
5221: FROM okl_k_headers_full_v
5222: WHERE id = p_chr_id;

Line 5224: CURSOR date_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

5220: start_date
5221: FROM okl_k_headers_full_v
5222: WHERE id = p_chr_id;
5223:
5224: CURSOR date_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5225: SELECT start_date,
5226: end_date,
5227: term_duration
5228: FROM okl_k_headers_full_v

Line 5243: l_new_start_date OKC_K_HEADERS_V.START_DATE%TYPE;

5239:
5240: l_orig_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
5241: l_rebook_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
5242:
5243: l_new_start_date OKC_K_HEADERS_V.START_DATE%TYPE;
5244: l_new_end_date OKC_K_HEADERS_V.END_DATE%TYPE;
5245: l_new_term OKL_K_HEADERS.TERM_DURATION%TYPE;
5246:
5247: check_update_failed EXCEPTION;

Line 5244: l_new_end_date OKC_K_HEADERS_V.END_DATE%TYPE;

5240: l_orig_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
5241: l_rebook_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
5242:
5243: l_new_start_date OKC_K_HEADERS_V.START_DATE%TYPE;
5244: l_new_end_date OKC_K_HEADERS_V.END_DATE%TYPE;
5245: l_new_term OKL_K_HEADERS.TERM_DURATION%TYPE;
5246:
5247: check_update_failed EXCEPTION;
5248:

Line 5342: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE

5338: p_init_msg_list IN VARCHAR2, -- DEFAULT OKC_API.G_FALSE,
5339: x_return_status OUT NOCOPY VARCHAR2,
5340: x_msg_count OUT NOCOPY NUMBER,
5341: x_msg_data OUT NOCOPY VARCHAR2,
5342: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE
5343: ) IS
5344: l_api_name VARCHAR2(35) := 'sync_rebook_orig_contract';
5345: l_proc_name VARCHAR2(35) := 'SYNC_REBOOK_ORIG_CONTRACT';
5346:

Line 5347: l_orig_chr_id OKC_K_HEADERS_V.ID%TYPE;

5343: ) IS
5344: l_api_name VARCHAR2(35) := 'sync_rebook_orig_contract';
5345: l_proc_name VARCHAR2(35) := 'SYNC_REBOOK_ORIG_CONTRACT';
5346:
5347: l_orig_chr_id OKC_K_HEADERS_V.ID%TYPE;
5348: l_khrv_rec khrv_rec_type;
5349: l_chrv_rec chrv_rec_type;
5350:
5351: x_khrv_rec khrv_rec_type;

Line 5363: CURSOR trx_csr(p_chr_id_new OKC_K_HEADERS_V.ID%TYPE) IS

5359: l_update_klev_tbl klev_tbl_type;
5360: x_update_clev_tbl clev_tbl_type;
5361: x_update_klev_tbl klev_tbl_type;
5362:
5363: CURSOR trx_csr(p_chr_id_new OKC_K_HEADERS_V.ID%TYPE) IS
5364: SELECT id
5365: FROM OKL_TRX_CONTRACTS
5366: WHERE khr_id_new = p_chr_id_new
5367: AND representation_type = 'PRIMARY'; -- MGAAP 7263041

Line 5646: p_from_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

5642: p_init_msg_list IN VARCHAR2, -- DEFAULT OKC_API.G_FALSE,
5643: x_return_status OUT NOCOPY VARCHAR2,
5644: x_msg_count OUT NOCOPY NUMBER,
5645: x_msg_data OUT NOCOPY VARCHAR2,
5646: p_from_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
5647: p_rebook_reason_code IN VARCHAR2,
5648: p_rebook_description IN VARCHAR2,
5649: p_trx_date IN DATE,
5650: x_tcnv_rec OUT NOCOPY tcnv_rec_type,

Line 5651: x_rebook_chr_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE

5647: p_rebook_reason_code IN VARCHAR2,
5648: p_rebook_description IN VARCHAR2,
5649: p_trx_date IN DATE,
5650: x_tcnv_rec OUT NOCOPY tcnv_rec_type,
5651: x_rebook_chr_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE
5652: ) IS
5653:
5654: l_api_name VARCHAR2(35) := 'create_txn_contract';
5655: l_proc_name VARCHAR2(35) := 'CREATE_TXN_CONTRACT';

Line 5830: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

5826: PROCEDURE process_securitization_stream(
5827: x_return_status OUT NOCOPY VARCHAR2,
5828: x_msg_count OUT NOCOPY NUMBER,
5829: x_msg_data OUT NOCOPY VARCHAR2,
5830: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
5831: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE
5832: ) IS
5833:
5834: l_api_name VARCHAR2(35) := 'process_securitization_stream';

Line 5831: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE

5827: x_return_status OUT NOCOPY VARCHAR2,
5828: x_msg_count OUT NOCOPY NUMBER,
5829: x_msg_data OUT NOCOPY VARCHAR2,
5830: p_orig_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
5831: p_rebook_chr_id IN OKC_K_HEADERS_V.ID%TYPE
5832: ) IS
5833:
5834: l_api_name VARCHAR2(35) := 'process_securitization_stream';
5835: l_proc_name VARCHAR2(35) := 'PROCESS_SECURITIZATION_STREAM';

Line 5838: CURSOR txn_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

5834: l_api_name VARCHAR2(35) := 'process_securitization_stream';
5835: l_proc_name VARCHAR2(35) := 'PROCESS_SECURITIZATION_STREAM';
5836: l_api_version CONSTANT NUMBER := 1;
5837:
5838: CURSOR txn_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5839: SELECT date_transaction_occurred
5840: FROM okl_trx_contracts
5841: WHERE khr_id = p_chr_id
5842: AND tcn_type = 'TRBK'

Line 5846: CURSOR disb_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

5842: AND tcn_type = 'TRBK'
5843: AND tsu_code = 'ENTERED'
5844: AND representation_type = 'PRIMARY'; -- MGAAP 7263041
5845:
5846: CURSOR disb_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5847: SELECT strm.id
5848: FROM okl_streams strm,
5849: okl_strm_type_v TYPE
5850: WHERE TYPE.id = strm.sty_id

Line 5855: CURSOR accu_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

5851: AND TYPE.stream_type_subclass = 'INVESTOR_DISBURSEMENT'
5852: AND strm.khr_id = p_chr_id
5853: AND strm.say_code = 'CURR';
5854:
5855: CURSOR accu_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5856: SELECT strm.id
5857: FROM okl_streams strm,
5858: okl_strm_type_v TYPE
5859: WHERE TYPE.id = strm.sty_id

Line 6112: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

6108: p_init_msg_list IN VARCHAR2, -- DEFAULT OKC_API.G_FALSE,
6109: x_return_status OUT NOCOPY VARCHAR2,
6110: x_msg_count OUT NOCOPY NUMBER,
6111: x_msg_data OUT NOCOPY VARCHAR2,
6112: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
6113: p_stream_status IN OKL_STREAMS.SAY_CODE%TYPE
6114: ) IS
6115:
6116: l_api_name VARCHAR2(35) := 'sync_rebook_stream';

Line 6458: p_from_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

6454: p_init_msg_list IN VARCHAR2, -- DEFAULT OKC_API.G_FALSE,
6455: x_return_status OUT NOCOPY VARCHAR2,
6456: x_msg_count OUT NOCOPY NUMBER,
6457: x_msg_data OUT NOCOPY VARCHAR2,
6458: p_from_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
6459: x_rebook_chr_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE,
6460: p_rbk_date IN DATE DEFAULT NULL
6461: ) IS
6462:

Line 6459: x_rebook_chr_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE,

6455: x_return_status OUT NOCOPY VARCHAR2,
6456: x_msg_count OUT NOCOPY NUMBER,
6457: x_msg_data OUT NOCOPY VARCHAR2,
6458: p_from_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
6459: x_rebook_chr_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE,
6460: p_rbk_date IN DATE DEFAULT NULL
6461: ) IS
6462:
6463: l_api_name VARCHAR2(35) := 'create_rebook_contract';

Line 6466: x_chr_id OKC_K_HEADERS_V.ID%TYPE;

6462:
6463: l_api_name VARCHAR2(35) := 'create_rebook_contract';
6464: l_proc_name VARCHAR2(35) := 'CREATE_REBOOK_CONTRACT';
6465: l_api_version CONSTANT NUMBER := 1;
6466: x_chr_id OKC_K_HEADERS_V.ID%TYPE;
6467: l_seq_no NUMBER;
6468: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
6469: l_orig_sts_code OKC_K_HEADERS_V.sts_code%TYPE; --| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |
6470: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

Line 6468: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

6464: l_proc_name VARCHAR2(35) := 'CREATE_REBOOK_CONTRACT';
6465: l_api_version CONSTANT NUMBER := 1;
6466: x_chr_id OKC_K_HEADERS_V.ID%TYPE;
6467: l_seq_no NUMBER;
6468: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
6469: l_orig_sts_code OKC_K_HEADERS_V.sts_code%TYPE; --| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |
6470: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
6471: l_khrv_rec khrv_rec_type;
6472: x_khrv_rec khrv_rec_type;

Line 6469: l_orig_sts_code OKC_K_HEADERS_V.sts_code%TYPE; --| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |

6465: l_api_version CONSTANT NUMBER := 1;
6466: x_chr_id OKC_K_HEADERS_V.ID%TYPE;
6467: l_seq_no NUMBER;
6468: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
6469: l_orig_sts_code OKC_K_HEADERS_V.sts_code%TYPE; --| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |
6470: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
6471: l_khrv_rec khrv_rec_type;
6472: x_khrv_rec khrv_rec_type;
6473: l_chrv_rec chrv_rec_type;

Line 6470: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

6466: x_chr_id OKC_K_HEADERS_V.ID%TYPE;
6467: l_seq_no NUMBER;
6468: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
6469: l_orig_sts_code OKC_K_HEADERS_V.sts_code%TYPE; --| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |
6470: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
6471: l_khrv_rec khrv_rec_type;
6472: x_khrv_rec khrv_rec_type;
6473: l_chrv_rec chrv_rec_type;
6474: x_chrv_rec chrv_rec_type;

Line 6481: /* CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

6477: x_cle_id_tbl okl_kle_pvt.klev_tbl_type;
6478: i NUMBER := 1;
6479:
6480: --start:| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |
6481: /* CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
6482: SELECT contract_number
6483: FROM okc_k_headers_v
6484: WHERE id = p_chr_id;
6485: */

Line 6483: FROM okc_k_headers_v

6479:
6480: --start:| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |
6481: /* CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
6482: SELECT contract_number
6483: FROM okc_k_headers_v
6484: WHERE id = p_chr_id;
6485: */
6486: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
6487: SELECT contract_number, sts_code

Line 6486: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

6482: SELECT contract_number
6483: FROM okc_k_headers_v
6484: WHERE id = p_chr_id;
6485: */
6486: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
6487: SELECT contract_number, sts_code
6488: FROM okc_k_headers_v
6489: WHERE id = p_chr_id;
6490: --end:| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |

Line 6488: FROM okc_k_headers_v

6484: WHERE id = p_chr_id;
6485: */
6486: CURSOR orig_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
6487: SELECT contract_number, sts_code
6488: FROM okc_k_headers_v
6489: WHERE id = p_chr_id;
6490: --end:| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |
6491:
6492: CURSOR top_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

Line 6492: CURSOR top_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

6488: FROM okc_k_headers_v
6489: WHERE id = p_chr_id;
6490: --end:| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |
6491:
6492: CURSOR top_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
6493: SELECT id
6494: FROM okc_k_lines_v
6495: WHERE chr_id = p_chr_id;
6496: --AND lse_id = 33; -- ??? Temporary , Fin Asset Line Only