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 1689: l_inv_lns_tbl okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;

1685: l_appl_tbl APPL_TBL_TYPE DEFAULT p_appl_tbl;
1686: l_okl_rcpt_tbl line_appl_tbl_type;
1687: x_okl_rcpt_tbl line_appl_tbl_type;
1688: l_final_appl_tbl line_appl_tbl_type;
1689: l_inv_lns_tbl okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;
1690: l_init_inv_lines_tbl okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;
1691:
1692: l_rctv_rec Okl_Rct_Pvt.rctv_rec_type;
1693: l_rcav_tbl Okl_Rca_Pvt.rcav_tbl_type;

Line 1690: l_init_inv_lines_tbl okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;

1686: l_okl_rcpt_tbl line_appl_tbl_type;
1687: x_okl_rcpt_tbl line_appl_tbl_type;
1688: l_final_appl_tbl line_appl_tbl_type;
1689: l_inv_lns_tbl okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;
1690: l_init_inv_lines_tbl okl_auto_cash_appl_rules_pvt.okl_inv_line_tbl_type;
1691:
1692: l_rctv_rec Okl_Rct_Pvt.rctv_rec_type;
1693: l_rcav_tbl Okl_Rca_Pvt.rcav_tbl_type;
1694: x_rctv_rec Okl_Rct_Pvt.rctv_rec_type;

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

1933: ELSIF l_appl_tbl(i).contract_id is not null then
1934: OPEN c_cont_num(l_appl_tbl(i).contract_id,l_org_id);
1935: FETCH c_cont_num into l_contract_number;
1936: CLOSE C_cont_num;
1937: log_debug('Before okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract');
1938: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract( p_api_version => l_api_version,
1939: p_init_msg_list => l_init_msg_list,
1940: x_return_status => l_return_status,
1941: x_msg_count => l_msg_count,

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

1934: OPEN c_cont_num(l_appl_tbl(i).contract_id,l_org_id);
1935: FETCH c_cont_num into l_contract_number;
1936: CLOSE C_cont_num;
1937: log_debug('Before okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract');
1938: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract( p_api_version => l_api_version,
1939: p_init_msg_list => l_init_msg_list,
1940: x_return_status => l_return_status,
1941: x_msg_count => l_msg_count,
1942: x_msg_data => l_msg_data,

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

1950: x_appl_tbl => x_okl_rcpt_tbl,
1951: x_onacc_amount => l_apply_onacc_amount,
1952: x_unapply_amount =>l_unapply_amount
1953: );
1954: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract');
1955: log_debug('l_apply_onacc_amount = '||l_apply_onacc_amount);
1956: log_debug('l_unapply_amount = '||l_unapply_amount);
1957: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1958: RAISE okl_api.g_exception_unexpected_error;

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

1976: ELSIF l_appl_tbl(i).con_inv_id is not null then
1977: OPEN c_cons_inv_num(l_appl_tbl(i).con_inv_id,l_org_id);
1978: FETCH c_cons_inv_num into l_cons_inv_number;
1979: CLOSE c_cons_inv_num;
1980: log_debug('Before okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv');
1981: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv ( p_api_version => l_api_version,
1982: p_init_msg_list => l_init_msg_list,
1983: x_return_status => l_return_status,
1984: x_msg_count => l_msg_count,

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

1977: OPEN c_cons_inv_num(l_appl_tbl(i).con_inv_id,l_org_id);
1978: FETCH c_cons_inv_num into l_cons_inv_number;
1979: CLOSE c_cons_inv_num;
1980: log_debug('Before okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv');
1981: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv ( p_api_version => l_api_version,
1982: p_init_msg_list => l_init_msg_list,
1983: x_return_status => l_return_status,
1984: x_msg_count => l_msg_count,
1985: x_msg_data => l_msg_data,

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

1993: x_appl_tbl => x_okl_rcpt_tbl,
1994: x_onacc_amount => l_apply_onacc_amount,
1995: x_unapply_amount =>l_unapply_amount
1996: );
1997: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv');
1998: log_debug('l_apply_onacc_amount = '||l_apply_onacc_amount);
1999: log_debug('l_unapply_amount = '||l_unapply_amount);
2000: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2001: RAISE okl_api.g_exception_unexpected_error;

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

2020: and l_rcpt_rec.cash_receipt_id IS NULL then
2021: OPEN c_ar_inv_num(l_appl_tbl(i).ar_inv_id,l_org_id);
2022: FETCH c_ar_inv_num into l_ar_inv_number;
2023: CLOSE c_ar_inv_num;
2024: log_debug('Before okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv');
2025: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv ( p_api_version => l_api_version,
2026: p_init_msg_list => l_init_msg_list,
2027: x_return_status => l_return_status,
2028: x_msg_count => l_msg_count,

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

2021: OPEN c_ar_inv_num(l_appl_tbl(i).ar_inv_id,l_org_id);
2022: FETCH c_ar_inv_num into l_ar_inv_number;
2023: CLOSE c_ar_inv_num;
2024: log_debug('Before okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv');
2025: okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv ( p_api_version => l_api_version,
2026: p_init_msg_list => l_init_msg_list,
2027: x_return_status => l_return_status,
2028: x_msg_count => l_msg_count,
2029: x_msg_data => l_msg_data,

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

2037: x_appl_tbl => x_okl_rcpt_tbl,
2038: x_onacc_amount => l_apply_onacc_amount,
2039: x_unapply_amount =>l_unapply_amount
2040: );
2041: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv');
2042: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2043: RAISE okl_api.g_exception_unexpected_error;
2044: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2045: RAISE okl_api.g_exception_error;