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 776: 'OKC_CONTRACT_PUB.update_contract_header(p_chr_id=' ||

772: (fnd_log.level_event,
773: g_module ||
774: l_api_name ||
775: '.external_call.before',
776: 'OKC_CONTRACT_PUB.update_contract_header(p_chr_id=' ||
777: p_chr_id ||
778: ')'
779: );
780: END IF;

Line 782: okc_contract_pub.update_contract_header

778: ')'
779: );
780: END IF;
781:
782: okc_contract_pub.update_contract_header
783: (p_api_version => l_api_version,
784: p_init_msg_list => okc_api.g_false,
785: x_return_status => l_return_status,
786: x_msg_count => l_msg_count,

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

796: (fnd_log.level_event,
797: g_module ||
798: l_api_name ||
799: '.external_call.after',
800: 'OKC_CONTRACT_PUB.update_contract_header(x_return_status= ' ||
801: l_return_status ||
802: ' l_msg_count =' ||
803: l_msg_count ||
804: ')'

Line 822: 'OKC_CONTRACT_PUB.update_contract_line - Loop begin'

818: fnd_log.STRING (fnd_log.level_event,
819: g_module ||
820: l_api_name ||
821: '.external_call.before',
822: 'OKC_CONTRACT_PUB.update_contract_line - Loop begin'
823: );
824: END IF;
825:
826: l_clev_rec.sts_code := p_status;

Line 846: okc_contract_pub.update_contract_line

842: l_lines_rec.ID
843: );
844: END IF;
845:
846: okc_contract_pub.update_contract_line
847: (p_api_version => l_api_version,
848: p_init_msg_list => okc_api.g_false,
849: x_return_status => l_return_status,
850: x_msg_count => l_msg_count,

Line 890: okc_contract_pub.update_contract_line

886: l_lines_rec.ID
887: );
888: END IF;
889:
890: okc_contract_pub.update_contract_line
891: (p_api_version => l_api_version,
892: p_init_msg_list => okc_api.g_false,
893: x_return_status => l_return_status,
894: x_msg_count => l_msg_count,

Line 927: 'OKC_CONTRACT_PUB.update_contract_line - loop end'

923: fnd_log.STRING (fnd_log.level_event,
924: g_module ||
925: l_api_name ||
926: '.external_call.after',
927: 'OKC_CONTRACT_PUB.update_contract_line - loop end'
928: );
929: END IF;
930: EXCEPTION
931: WHEN fnd_api.g_exc_error

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

2208: -- STEP 1: Check for active workflow processes
2209: IF x_is_eligible = 'Y' THEN
2210: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2211: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2212: 'okc_contract_pub.get_active_process(p_contract_number= '||
2213: l_k_details_rec.contract_number||
2214: ' p_contract_number_modifier ='||l_k_details_rec.contract_number_modifier||')');
2215: END IF;
2216: okc_contract_pub.get_active_process

Line 2216: okc_contract_pub.get_active_process

2212: 'okc_contract_pub.get_active_process(p_contract_number= '||
2213: l_k_details_rec.contract_number||
2214: ' p_contract_number_modifier ='||l_k_details_rec.contract_number_modifier||')');
2215: END IF;
2216: okc_contract_pub.get_active_process
2217: (
2218: p_api_version => 1.0,
2219: p_init_msg_list => 'Y',
2220: x_return_status => x_return_status,

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

2229: x_usage => l_usage
2230: );
2231: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2232: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2233: 'okc_contract_pub.get_active_process(x_return_status= '||x_return_status||
2234: ' x_msg_count ='||x_msg_count||')');
2235: END IF;
2236:
2237: -- If error, skip this contract and proceed with the next