11: currency_conv_rate NUMBER ,
12: x_return_status VARCHAR2(1)
13: );
14:
15: SUBTYPE line_appl_tbl_type IS okl_auto_cash_appl_rules_pvt.okl_appl_dtls_tbl_type;
16: SUBTYPE llca_tbl_type IS okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;
17: ---------------------------------------------------------------------------
18: -- GLOBAL VARIABLES
19: ---------------------------------------------------------------------------
12: x_return_status VARCHAR2(1)
13: );
14:
15: SUBTYPE line_appl_tbl_type IS okl_auto_cash_appl_rules_pvt.okl_appl_dtls_tbl_type;
16: SUBTYPE llca_tbl_type IS okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;
17: ---------------------------------------------------------------------------
18: -- GLOBAL VARIABLES
19: ---------------------------------------------------------------------------
20: ---------------------------------------------------------------------------
1628: l_appl_tbl APPL_TBL_TYPE DEFAULT p_appl_tbl;
1629: l_okl_rcpt_tbl line_appl_tbl_type;
1630: x_okl_rcpt_tbl line_appl_tbl_type;
1631: l_final_appl_tbl line_appl_tbl_type;
1632: l_inv_lns_tbl okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;
1633: l_init_inv_lines_tbl okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;
1634:
1635: l_rctv_rec Okl_Rct_Pvt.rctv_rec_type;
1636: l_rcav_tbl Okl_Rca_Pvt.rcav_tbl_type;
1629: l_okl_rcpt_tbl line_appl_tbl_type;
1630: x_okl_rcpt_tbl line_appl_tbl_type;
1631: l_final_appl_tbl line_appl_tbl_type;
1632: l_inv_lns_tbl okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;
1633: l_init_inv_lines_tbl okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;
1634:
1635: l_rctv_rec Okl_Rct_Pvt.rctv_rec_type;
1636: l_rcav_tbl Okl_Rca_Pvt.rcav_tbl_type;
1637: x_rctv_rec Okl_Rct_Pvt.rctv_rec_type;
1876: ELSIF l_appl_tbl(i).contract_id is not null then
1877: OPEN c_cont_num(l_appl_tbl(i).contract_id,l_org_id);
1878: FETCH c_cont_num into l_contract_number;
1879: CLOSE C_cont_num;
1880: log_debug('Before okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract');
1881: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract( p_api_version => l_api_version,
1882: p_init_msg_list => l_init_msg_list,
1883: x_return_status => l_return_status,
1884: x_msg_count => l_msg_count,
1877: OPEN c_cont_num(l_appl_tbl(i).contract_id,l_org_id);
1878: FETCH c_cont_num into l_contract_number;
1879: CLOSE C_cont_num;
1880: log_debug('Before okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract');
1881: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract( p_api_version => l_api_version,
1882: p_init_msg_list => l_init_msg_list,
1883: x_return_status => l_return_status,
1884: x_msg_count => l_msg_count,
1885: x_msg_data => l_msg_data,
1893: x_appl_tbl => x_okl_rcpt_tbl,
1894: x_onacc_amount => l_apply_onacc_amount,
1895: x_unapply_amount =>l_unapply_amount
1896: );
1897: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract');
1898: log_debug('l_apply_onacc_amount = '||l_apply_onacc_amount);
1899: log_debug('l_unapply_amount = '||l_unapply_amount);
1900: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1901: RAISE okl_api.g_exception_unexpected_error;
1919: ELSIF l_appl_tbl(i).con_inv_id is not null then
1920: OPEN c_cons_inv_num(l_appl_tbl(i).con_inv_id,l_org_id);
1921: FETCH c_cons_inv_num into l_cons_inv_number;
1922: CLOSE c_cons_inv_num;
1923: log_debug('Before okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv');
1924: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv ( p_api_version => l_api_version,
1925: p_init_msg_list => l_init_msg_list,
1926: x_return_status => l_return_status,
1927: x_msg_count => l_msg_count,
1920: OPEN c_cons_inv_num(l_appl_tbl(i).con_inv_id,l_org_id);
1921: FETCH c_cons_inv_num into l_cons_inv_number;
1922: CLOSE c_cons_inv_num;
1923: log_debug('Before okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv');
1924: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv ( p_api_version => l_api_version,
1925: p_init_msg_list => l_init_msg_list,
1926: x_return_status => l_return_status,
1927: x_msg_count => l_msg_count,
1928: x_msg_data => l_msg_data,
1936: x_appl_tbl => x_okl_rcpt_tbl,
1937: x_onacc_amount => l_apply_onacc_amount,
1938: x_unapply_amount =>l_unapply_amount
1939: );
1940: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv');
1941: log_debug('l_apply_onacc_amount = '||l_apply_onacc_amount);
1942: log_debug('l_unapply_amount = '||l_unapply_amount);
1943: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1944: RAISE okl_api.g_exception_unexpected_error;
1963: and l_rcpt_rec.cash_receipt_id IS NULL then
1964: OPEN c_ar_inv_num(l_appl_tbl(i).ar_inv_id,l_org_id);
1965: FETCH c_ar_inv_num into l_ar_inv_number;
1966: CLOSE c_ar_inv_num;
1967: log_debug('Before okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv');
1968: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv ( p_api_version => l_api_version,
1969: p_init_msg_list => l_init_msg_list,
1970: x_return_status => l_return_status,
1971: x_msg_count => l_msg_count,
1964: OPEN c_ar_inv_num(l_appl_tbl(i).ar_inv_id,l_org_id);
1965: FETCH c_ar_inv_num into l_ar_inv_number;
1966: CLOSE c_ar_inv_num;
1967: log_debug('Before okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv');
1968: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv ( p_api_version => l_api_version,
1969: p_init_msg_list => l_init_msg_list,
1970: x_return_status => l_return_status,
1971: x_msg_count => l_msg_count,
1972: x_msg_data => l_msg_data,
1980: x_appl_tbl => x_okl_rcpt_tbl,
1981: x_onacc_amount => l_apply_onacc_amount,
1982: x_unapply_amount =>l_unapply_amount
1983: );
1984: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv');
1985: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1986: RAISE okl_api.g_exception_unexpected_error;
1987: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1988: RAISE okl_api.g_exception_error;