DBA Data[Home] [Help]

APPS.OKL_RECEIPTS_PVT dependencies on OKL_AUTO_CASH_APPL_RULES_PVT

Line 15: SUBTYPE line_appl_tbl_type IS okl_auto_cash_appl_rules_pvt.okl_appl_dtls_tbl_type;

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

Line 16: SUBTYPE llca_tbl_type IS okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;

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

Line 1632: l_inv_lns_tbl okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;

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;

Line 1633: l_init_inv_lines_tbl okl_auto_cash_appl_rules_pvt.okl_inv_line_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;

Line 1880: log_debug('Before okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract');

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,

Line 1881: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract( p_api_version => l_api_version,

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,

Line 1897: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract');

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;

Line 1923: log_debug('Before okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv');

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,

Line 1924: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv ( p_api_version => l_api_version,

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,

Line 1940: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv');

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;

Line 1967: log_debug('Before okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv');

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,

Line 1968: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv ( p_api_version => l_api_version,

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,

Line 1984: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv');

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;