DBA Data[Home] [Help]

APPS.OKS_AUTO_REMINDER dependencies on OKC_CONTRACT_PUB

Line 709: l_chrv_rec okc_contract_pub.chrv_rec_type;

705: IS
706: l_api_version CONSTANT NUMBER := 1.0;
707: l_api_name CONSTANT VARCHAR2 (50)
708: := 'update_contract_status';
709: l_chrv_rec okc_contract_pub.chrv_rec_type;
710: x_chrv_rec okc_contract_pub.chrv_rec_type;
711: l_clev_rec okc_contract_pub.clev_rec_type;
712: x_clev_rec okc_contract_pub.clev_rec_type;
713: l_return_status VARCHAR2 (1)

Line 710: x_chrv_rec okc_contract_pub.chrv_rec_type;

706: l_api_version CONSTANT NUMBER := 1.0;
707: l_api_name CONSTANT VARCHAR2 (50)
708: := 'update_contract_status';
709: l_chrv_rec okc_contract_pub.chrv_rec_type;
710: x_chrv_rec okc_contract_pub.chrv_rec_type;
711: l_clev_rec okc_contract_pub.clev_rec_type;
712: x_clev_rec okc_contract_pub.clev_rec_type;
713: l_return_status VARCHAR2 (1)
714: := okc_api.g_ret_sts_success;

Line 711: l_clev_rec okc_contract_pub.clev_rec_type;

707: l_api_name CONSTANT VARCHAR2 (50)
708: := 'update_contract_status';
709: l_chrv_rec okc_contract_pub.chrv_rec_type;
710: x_chrv_rec okc_contract_pub.chrv_rec_type;
711: l_clev_rec okc_contract_pub.clev_rec_type;
712: x_clev_rec okc_contract_pub.clev_rec_type;
713: l_return_status VARCHAR2 (1)
714: := okc_api.g_ret_sts_success;
715: l_msg_data VARCHAR2 (2000);

Line 712: x_clev_rec okc_contract_pub.clev_rec_type;

708: := 'update_contract_status';
709: l_chrv_rec okc_contract_pub.chrv_rec_type;
710: x_chrv_rec okc_contract_pub.chrv_rec_type;
711: l_clev_rec okc_contract_pub.clev_rec_type;
712: x_clev_rec okc_contract_pub.clev_rec_type;
713: l_return_status VARCHAR2 (1)
714: := okc_api.g_ret_sts_success;
715: l_msg_data VARCHAR2 (2000);
716: l_msg_count NUMBER;

Line 792: 'OKC_CONTRACT_PUB.update_contract_header(p_chr_id=' ||

788: (fnd_log.level_event,
789: g_module ||
790: l_api_name ||
791: '.external_call.before',
792: 'OKC_CONTRACT_PUB.update_contract_header(p_chr_id=' ||
793: p_chr_id ||
794: ')'
795: );
796: END IF;

Line 804: okc_contract_pub.update_contract_header

800: l_chrv_rec.term_cancel_source := 'CUSTOMER';
801: l_chrv_rec.trn_code := 'NFC';
802: l_chrv_rec.new_ste_code := 'CANCELLED';
803: /*commented and modified for bug8345674
804: okc_contract_pub.update_contract_header
805: (p_api_version => l_api_version,
806: p_init_msg_list => okc_api.g_false,
807: x_return_status => l_return_status,
808: x_msg_count => l_msg_count,

Line 839: okc_contract_pub.update_contract_header

835: SET renewal_status = 'QUOTE_CNCLD'
836: WHERE chr_id = p_chr_id;
837: /*end of bug8345674*/
838: ELSE
839: okc_contract_pub.update_contract_header
840: (p_api_version => l_api_version,
841: p_init_msg_list => okc_api.g_false,
842: x_return_status => l_return_status,
843: x_msg_count => l_msg_count,

Line 858: 'OKC_CONTRACT_PUB.update_contract_header(x_return_status= ' ||

854: (fnd_log.level_event,
855: g_module ||
856: l_api_name ||
857: '.external_call.after',
858: 'OKC_CONTRACT_PUB.update_contract_header(x_return_status= ' ||
859: l_return_status ||
860: ' l_msg_count =' ||
861: l_msg_count ||
862: ')'

Line 880: 'OKC_CONTRACT_PUB.update_contract_line - Loop begin'

876: fnd_log.STRING (fnd_log.level_event,
877: g_module ||
878: l_api_name ||
879: '.external_call.before',
880: 'OKC_CONTRACT_PUB.update_contract_line - Loop begin'
881: );
882: END IF;
883:
884: l_clev_rec.sts_code := p_status;

Line 902: okc_contract_pub.update_contract_line

898: l_lines_rec.ID
899: );
900: END IF;
901:
902: okc_contract_pub.update_contract_line
903: (p_api_version => l_api_version,
904: p_init_msg_list => okc_api.g_false,
905: x_return_status => l_return_status,
906: x_msg_count => l_msg_count,

Line 954: okc_contract_pub.update_contract_line

950: l_clev_rec.date_cancelled := SYSDATE;
951: l_clev_rec.term_cancel_source := 'CUSTOMER';
952: l_clev_rec.trn_code := 'NFC';
953: l_clev_rec.new_ste_code := 'CANCELLED';
954: okc_contract_pub.update_contract_line
955: (p_api_version => l_api_version,
956: p_init_msg_list => okc_api.g_false,
957: x_return_status => l_return_status,
958: x_msg_count => l_msg_count,

Line 967: okc_contract_pub.update_contract_line

963: );
964: */
965: NULL;
966: ELSE
967: okc_contract_pub.update_contract_line
968: (p_api_version => l_api_version,
969: p_init_msg_list => okc_api.g_false,
970: x_return_status => l_return_status,
971: x_msg_count => l_msg_count,

Line 1004: 'OKC_CONTRACT_PUB.update_contract_line - loop end'

1000: fnd_log.STRING (fnd_log.level_event,
1001: g_module ||
1002: l_api_name ||
1003: '.external_call.after',
1004: 'OKC_CONTRACT_PUB.update_contract_line - loop end'
1005: );
1006: END IF;
1007: EXCEPTION
1008: WHEN fnd_api.g_exc_error

Line 2299: 'okc_contract_pub.get_active_process(p_contract_number= '||

2295: -- STEP 1: Check for active workflow processes
2296: IF x_is_eligible = 'Y' THEN
2297: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2298: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2299: 'okc_contract_pub.get_active_process(p_contract_number= '||
2300: l_k_details_rec.contract_number||
2301: ' p_contract_number_modifier ='||l_k_details_rec.contract_number_modifier||')');
2302: END IF;
2303: okc_contract_pub.get_active_process

Line 2303: okc_contract_pub.get_active_process

2299: 'okc_contract_pub.get_active_process(p_contract_number= '||
2300: l_k_details_rec.contract_number||
2301: ' p_contract_number_modifier ='||l_k_details_rec.contract_number_modifier||')');
2302: END IF;
2303: okc_contract_pub.get_active_process
2304: (
2305: p_api_version => 1.0,
2306: p_init_msg_list => 'Y',
2307: x_return_status => x_return_status,

Line 2320: 'okc_contract_pub.get_active_process(x_return_status= '||x_return_status||

2316: x_usage => l_usage
2317: );
2318: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2319: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2320: 'okc_contract_pub.get_active_process(x_return_status= '||x_return_status||
2321: ' x_msg_count ='||x_msg_count||')');
2322: END IF;
2323:
2324: /*BUG6956935*/