DBA Data[Home] [Help]

APPS.OKL_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKL_MASS_REBOOK_PVT

Line 51: PROCEDURE PRINT_MESSAGES(l_payment_struc IN okl_mass_rebook_pvt.strm_lalevl_tbl_type)

47:
48:
49:
50:
51: PROCEDURE PRINT_MESSAGES(l_payment_struc IN okl_mass_rebook_pvt.strm_lalevl_tbl_type)
52: IS
53: i Number;
54: BEGIN
55: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 1207: x_payment_struc OUT NOCOPY okl_mass_rebook_pvt.strm_lalevl_tbl_type,

1203: END get_payment_details;
1204:
1205: PROCEDURE get_current_payments(
1206: p_khr_id IN NUMBER,
1207: x_payment_struc OUT NOCOPY okl_mass_rebook_pvt.strm_lalevl_tbl_type,
1208: x_prim_sty_id OUT NOCOPY NUMBER,
1209: x_upp_sty_id OUT NOCOPY NUMBER,
1210: x_primary_strm_type OUT NOCOPY VARCHAR2) AS
1211:

Line 1285: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type;

1281: /*-----------------------------------------------------------------------+
1282: * | Local Variable Declarations and initializations |
1283: * +-----------------------------------------------------------------------*/
1284: l_prev_sty_id NUMBER := -99;
1285: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type;
1286: i NUMBER :=1;
1287: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1288: --l_rent_sty_id NUMBER;
1289: l_prim_sty_id NUMBER;

Line 1494: p_payment_struc IN okl_mass_rebook_pvt.strm_lalevl_tbl_type,

1490: END IF;
1491: END get_current_payments;
1492:
1493: PROCEDURE modify_payments(
1494: p_payment_struc IN okl_mass_rebook_pvt.strm_lalevl_tbl_type,
1495: p_ppd_date IN DATE,
1496: p_blank_amount IN VARCHAR2,
1497: p_rent_sty_id IN NUMBER,
1498: x_modified_payment_struc OUT NOCOPY okl_mass_rebook_pvt.strm_lalevl_tbl_type)

Line 1498: x_modified_payment_struc OUT NOCOPY okl_mass_rebook_pvt.strm_lalevl_tbl_type)

1494: p_payment_struc IN okl_mass_rebook_pvt.strm_lalevl_tbl_type,
1495: p_ppd_date IN DATE,
1496: p_blank_amount IN VARCHAR2,
1497: p_rent_sty_id IN NUMBER,
1498: x_modified_payment_struc OUT NOCOPY okl_mass_rebook_pvt.strm_lalevl_tbl_type)
1499: AS
1500:
1501:
1502: --The parameter p_blank_amount is very important and the allowable

Line 1519: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type := p_payment_struc;

1515: /*-----------------------------------------------------------------------+
1516: * | Local Variable Declarations and initializations |
1517: * +-----------------------------------------------------------------------*/
1518: l_prev_sty_id NUMBER := -99;
1519: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type := p_payment_struc;
1520: i NUMBER :=1;
1521: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1522: l_sty_id NUMBER;
1523:

Line 1530: l_modified_payments okl_mass_rebook_pvt.strm_lalevl_tbl_type;

1526: l_upper_period NUMBER;
1527: l_lower_period NUMBER;
1528: l_payment_already_split VARCHAR2(1) := 'N';
1529: k NUMBER := 1;
1530: l_modified_payments okl_mass_rebook_pvt.strm_lalevl_tbl_type;
1531: l_prev_cle_id NUMBER := -99;
1532: pymnt_knt NUMBER;
1533: l_stub_pymnt VARCHAR2(1);
1534: l_upper_stub_days NUMBER;

Line 1713: p_payment_struc IN okl_mass_rebook_pvt.strm_lalevl_tbl_type,

1709: END IF;
1710: END modify_payments;
1711:
1712: PROCEDURE modify_terms(
1713: p_payment_struc IN okl_mass_rebook_pvt.strm_lalevl_tbl_type,
1714: p_chr_id IN NUMBER,
1715: p_ppd_date IN DATE,
1716: p_ppd_amount IN VARCHAR2,
1717: p_total_k_cost IN NUMBER,

Line 1720: x_modified_payment_struc OUT NOCOPY okl_mass_rebook_pvt.strm_lalevl_tbl_type)

1716: p_ppd_amount IN VARCHAR2,
1717: p_total_k_cost IN NUMBER,
1718: p_sty_id IN NUMBER,
1719: p_upp_sty_id IN NUMBER,
1720: x_modified_payment_struc OUT NOCOPY okl_mass_rebook_pvt.strm_lalevl_tbl_type)
1721: AS
1722:
1723:
1724: --The parameter p_blank_amount is very important and the allowable

Line 1741: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type := p_payment_struc;

1737: /*-----------------------------------------------------------------------+
1738: * | Local Variable Declarations and initializations |
1739: * +-----------------------------------------------------------------------*/
1740: l_prev_sty_id NUMBER := -99;
1741: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type := p_payment_struc;
1742: i NUMBER :=1;
1743: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1744: l_api_version CONSTANT NUMBER := 1;
1745: l_init_msg_list VARCHAR2(1) := 'T';

Line 1760: l_modified_payments okl_mass_rebook_pvt.strm_lalevl_tbl_type;

1756: l_upper_period NUMBER;
1757: l_lower_period NUMBER;
1758: l_term_already_split VARCHAR2(1) := 'N';
1759: k NUMBER := 1;
1760: l_modified_payments okl_mass_rebook_pvt.strm_lalevl_tbl_type;
1761: l_prev_cle_id NUMBER := -99;
1762: pymnt_knt NUMBER;
1763: l_stub_pymnt VARCHAR2(1);
1764: l_upper_stub_days NUMBER;

Line 1909: p_payment_struc IN okl_mass_rebook_pvt.strm_lalevl_tbl_type,

1905: END modify_terms;
1906:
1907:
1908: PROCEDURE modify_principal_payments(
1909: p_payment_struc IN okl_mass_rebook_pvt.strm_lalevl_tbl_type,
1910: p_chr_id IN NUMBER,
1911: p_ppd_date IN DATE,
1912: p_ppd_amount IN VARCHAR2,
1913: p_total_k_cost IN NUMBER,

Line 1916: x_modified_payment_struc OUT NOCOPY okl_mass_rebook_pvt.strm_lalevl_tbl_type)

1912: p_ppd_amount IN VARCHAR2,
1913: p_total_k_cost IN NUMBER,
1914: p_sty_id IN NUMBER,
1915: p_upp_sty_id IN NUMBER,
1916: x_modified_payment_struc OUT NOCOPY okl_mass_rebook_pvt.strm_lalevl_tbl_type)
1917: AS
1918:
1919: /*-----------------------------------------------------------------------+
1920: * | Local Variable Declarations and initializations |

Line 1923: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type := p_payment_struc;

1919: /*-----------------------------------------------------------------------+
1920: * | Local Variable Declarations and initializations |
1921: * +-----------------------------------------------------------------------*/
1922: l_prev_sty_id NUMBER := -99;
1923: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type := p_payment_struc;
1924: i NUMBER :=1;
1925: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1926: l_api_version CONSTANT NUMBER := 1;
1927: l_init_msg_list VARCHAR2(1) := 'T';

Line 1941: l_modified_payments okl_mass_rebook_pvt.strm_lalevl_tbl_type;

1937: l_upper_period NUMBER;
1938: l_lower_period NUMBER;
1939: l_payment_already_split VARCHAR2(1) := 'N';
1940: k NUMBER := 1;
1941: l_modified_payments okl_mass_rebook_pvt.strm_lalevl_tbl_type;
1942: l_prev_cle_id NUMBER := -99;
1943: pymnt_knt NUMBER;
1944: l_stub_pymnt VARCHAR2(1);
1945: l_upper_stub_days NUMBER;

Line 2420: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type;

2416: l_line_id NUMBER;
2417: l_frequency VARCHAR2(50);
2418: l_arrears_yn VARCHAR2(50);
2419: l_new_payment_amount NUMBER;
2420: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type;
2421: l_modified_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type;
2422: lx_cfo_id NUMBER;
2423: knt NUMBER :=0;
2424:

Line 2421: l_modified_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type;

2417: l_frequency VARCHAR2(50);
2418: l_arrears_yn VARCHAR2(50);
2419: l_new_payment_amount NUMBER;
2420: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type;
2421: l_modified_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type;
2422: lx_cfo_id NUMBER;
2423: knt NUMBER :=0;
2424:
2425: l_total_ppd_to_date NUMBER;

Line 5596: p_payment_structure IN okl_mass_rebook_pvt.strm_lalevl_tbl_type,

5592: x_msg_count OUT NOCOPY NUMBER,
5593: x_msg_data OUT NOCOPY VARCHAR2,
5594: p_ppd_request_id IN NUMBER,
5595: p_ppd_khr_id IN NUMBER,
5596: p_payment_structure IN okl_mass_rebook_pvt.strm_lalevl_tbl_type,
5597: x_cfo_id OUT NOCOPY NUMBER)
5598:
5599: AS
5600:

Line 6099: p_payment_structure IN okl_mass_rebook_pvt.strm_lalevl_tbl_type,

6095: x_msg_count OUT NOCOPY NUMBER,
6096: x_msg_data OUT NOCOPY VARCHAR2,
6097: p_ppd_request_id IN NUMBER,
6098: p_ppd_khr_id IN NUMBER,
6099: p_payment_structure IN okl_mass_rebook_pvt.strm_lalevl_tbl_type,
6100: x_cfo_id OUT NOCOPY NUMBER)
6101:
6102: AS
6103: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 6496: p_payment_struc OUT NOCOPY okl_mass_rebook_pvt.strm_lalevl_tbl_type)

6492:
6493:
6494: PROCEDURE extract_payments(
6495: p_ppd_request_id IN NUMBER,
6496: p_payment_struc OUT NOCOPY okl_mass_rebook_pvt.strm_lalevl_tbl_type)
6497: IS
6498:
6499: i NUMBER := 1;
6500: l_prev_sty_id NUMBER := -1;

Line 6658: l_kle_tbl OKL_MASS_REBOOK_PVT.kle_tbl_type;

6654: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;
6655:
6656: l_post_trqv_rec okl_trx_requests_pub.trqv_rec_type;
6657:
6658: l_kle_tbl OKL_MASS_REBOOK_PVT.kle_tbl_type;
6659: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type;
6660: i NUMBER := 1;
6661: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
6662:

Line 6659: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type;

6655:
6656: l_post_trqv_rec okl_trx_requests_pub.trqv_rec_type;
6657:
6658: l_kle_tbl OKL_MASS_REBOOK_PVT.kle_tbl_type;
6659: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type;
6660: i NUMBER := 1;
6661: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
6662:
6663: CURSOR c_obj_vers_csr (a_id NUMBER)

Line 7141: l_kle_tbl OKL_MASS_REBOOK_PVT.kle_tbl_type;

7137: lx_trqv_rec okl_trx_requests_pub.trqv_rec_type;
7138:
7139: l_post_trqv_rec okl_trx_requests_pub.trqv_rec_type;
7140:
7141: l_kle_tbl OKL_MASS_REBOOK_PVT.kle_tbl_type;
7142: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type;
7143: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
7144: l_out_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
7145:

Line 7142: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type;

7138:
7139: l_post_trqv_rec okl_trx_requests_pub.trqv_rec_type;
7140:
7141: l_kle_tbl OKL_MASS_REBOOK_PVT.kle_tbl_type;
7142: l_payment_struc okl_mass_rebook_pvt.strm_lalevl_tbl_type;
7143: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
7144: l_out_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
7145:
7146: CURSOR c_obj_vers_csr (a_id NUMBER)