1814: ) AS
1815: l_api_version CONSTANT NUMBER := 1;
1816: l_api_name CONSTANT VARCHAR2 (30)
1817: := 'update_payment_details';
1818: l_rnrl_rec oks_renew_util_pvt.rnrl_rec_type;
1819: x_rnrl_rec oks_renew_util_pvt.rnrl_rec_type;
1820:
1821: CURSOR csr_billing_address_id IS
1822: SELECT st.party_site_id
1815: l_api_version CONSTANT NUMBER := 1;
1816: l_api_name CONSTANT VARCHAR2 (30)
1817: := 'update_payment_details';
1818: l_rnrl_rec oks_renew_util_pvt.rnrl_rec_type;
1819: x_rnrl_rec oks_renew_util_pvt.rnrl_rec_type;
1820:
1821: CURSOR csr_billing_address_id IS
1822: SELECT st.party_site_id
1823: FROM okc_k_headers_all_b okc,
1961: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1962: fnd_log.STRING (fnd_log.level_procedure,
1963: g_module ||
1964: l_api_name,
1965: '210: Calling OKS_RENEW_UTIL_PVT.get_renew_rules'
1966: );
1967: END IF;
1968:
1969: -- Call OKS_RENEW_UTIL_PVT.get_renew_rules
1965: '210: Calling OKS_RENEW_UTIL_PVT.get_renew_rules'
1966: );
1967: END IF;
1968:
1969: -- Call OKS_RENEW_UTIL_PVT.get_renew_rules
1970: oks_renew_util_pvt.get_renew_rules (x_return_status => x_return_status,
1971: p_api_version => 1.0,
1972: p_init_msg_list => g_false,
1973: p_chr_id => p_chr_id,
1966: );
1967: END IF;
1968:
1969: -- Call OKS_RENEW_UTIL_PVT.get_renew_rules
1970: oks_renew_util_pvt.get_renew_rules (x_return_status => x_return_status,
1971: p_api_version => 1.0,
1972: p_init_msg_list => g_false,
1973: p_chr_id => p_chr_id,
1974: p_party_id => NULL,
1984: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1985: fnd_log.STRING (fnd_log.level_procedure,
1986: g_module ||
1987: l_api_name,
1988: '250: After Calling OKS_RENEW_UTIL_PVT.get_renew_rules'
1989: );
1990: fnd_log.STRING (fnd_log.level_procedure,
1991: g_module ||
1992: l_api_name,
2478: l_valid_payments VARCHAR2 (2000) := '';
2479: l_effective_payments VARCHAR2 (2000) := '';
2480: l_default_payment VARCHAR2 (2000) := '';
2481: l_separator VARCHAR2 (1) := '';
2482: l_rnrl_rec oks_renew_util_pvt.rnrl_rec_type;
2483: x_rnrl_rec oks_renew_util_pvt.rnrl_rec_type;
2484: l_k_amount NUMBER (15, 2);
2485: l_k_curr VARCHAR2 (100);
2486: l_curr_instrument okc_k_headers_all_b.payment_instruction_type%TYPE
2479: l_effective_payments VARCHAR2 (2000) := '';
2480: l_default_payment VARCHAR2 (2000) := '';
2481: l_separator VARCHAR2 (1) := '';
2482: l_rnrl_rec oks_renew_util_pvt.rnrl_rec_type;
2483: x_rnrl_rec oks_renew_util_pvt.rnrl_rec_type;
2484: l_k_amount NUMBER (15, 2);
2485: l_k_curr VARCHAR2 (100);
2486: l_curr_instrument okc_k_headers_all_b.payment_instruction_type%TYPE
2487: := '';
2550: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2551: fnd_log.STRING (fnd_log.level_procedure,
2552: g_module ||
2553: l_api_name,
2554: '200: Calling OKS_RENEW_UTIL_PVT.get_renew_rules'
2555: );
2556: END IF;
2557:
2558: -- Call OKS_RENEW_UTIL_PVT.get_renew_rules
2554: '200: Calling OKS_RENEW_UTIL_PVT.get_renew_rules'
2555: );
2556: END IF;
2557:
2558: -- Call OKS_RENEW_UTIL_PVT.get_renew_rules
2559: oks_renew_util_pvt.get_renew_rules (x_return_status => x_return_status,
2560: p_api_version => 1.0,
2561: p_init_msg_list => g_false,
2562: p_chr_id => p_chr_id,
2555: );
2556: END IF;
2557:
2558: -- Call OKS_RENEW_UTIL_PVT.get_renew_rules
2559: oks_renew_util_pvt.get_renew_rules (x_return_status => x_return_status,
2560: p_api_version => 1.0,
2561: p_init_msg_list => g_false,
2562: p_chr_id => p_chr_id,
2563: p_party_id => NULL,
2573: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2574: fnd_log.STRING (fnd_log.level_procedure,
2575: g_module ||
2576: l_api_name,
2577: '250: After Calling OKS_RENEW_UTIL_PVT.get_renew_rules'
2578: );
2579: fnd_log.STRING (fnd_log.level_procedure,
2580: g_module ||
2581: l_api_name,