DBA Data[Home] [Help]

APPS.OKS_IBINT_PUB dependencies on OKS_EXTWARPRGM_PVT

Line 500: l_extwar_rec OKS_EXTWARPRGM_PVT .extwar_rec_Type;

496: l_order_error VARCHAR2(2000);
497: l_curr_code VARCHAR2(15);
498: l_process BOOLEAN := TRUE;
499: l_Ord_hdr_rec l_Ord_Hdr_csr%rowtype ;
500: l_extwar_rec OKS_EXTWARPRGM_PVT .extwar_rec_Type;
501: p_contact_tbl OKS_EXTWARPRGM_PVT .contact_tbl;
502: l_SalesCredit_tbl OKS_EXTWARPRGM_PVT.SalesCredit_tbl;
503: l_SalesCredit_tbl_hdr OKS_EXTWARPRGM_PVT.SalesCredit_tbl; --mmadhavi bug 4174921
504: l_pricing_attributes_in OKS_EXTWARPRGM_PVT.Pricing_attributes_Type;

Line 501: p_contact_tbl OKS_EXTWARPRGM_PVT .contact_tbl;

497: l_curr_code VARCHAR2(15);
498: l_process BOOLEAN := TRUE;
499: l_Ord_hdr_rec l_Ord_Hdr_csr%rowtype ;
500: l_extwar_rec OKS_EXTWARPRGM_PVT .extwar_rec_Type;
501: p_contact_tbl OKS_EXTWARPRGM_PVT .contact_tbl;
502: l_SalesCredit_tbl OKS_EXTWARPRGM_PVT.SalesCredit_tbl;
503: l_SalesCredit_tbl_hdr OKS_EXTWARPRGM_PVT.SalesCredit_tbl; --mmadhavi bug 4174921
504: l_pricing_attributes_in OKS_EXTWARPRGM_PVT.Pricing_attributes_Type;
505: l_inst_dtls_tbl OKS_IHD_PVT.ihdv_tbl_type ;

Line 502: l_SalesCredit_tbl OKS_EXTWARPRGM_PVT.SalesCredit_tbl;

498: l_process BOOLEAN := TRUE;
499: l_Ord_hdr_rec l_Ord_Hdr_csr%rowtype ;
500: l_extwar_rec OKS_EXTWARPRGM_PVT .extwar_rec_Type;
501: p_contact_tbl OKS_EXTWARPRGM_PVT .contact_tbl;
502: l_SalesCredit_tbl OKS_EXTWARPRGM_PVT.SalesCredit_tbl;
503: l_SalesCredit_tbl_hdr OKS_EXTWARPRGM_PVT.SalesCredit_tbl; --mmadhavi bug 4174921
504: l_pricing_attributes_in OKS_EXTWARPRGM_PVT.Pricing_attributes_Type;
505: l_inst_dtls_tbl OKS_IHD_PVT.ihdv_tbl_type ;
506: l_insthist_rec OKS_INS_PVT.insv_rec_type;

Line 503: l_SalesCredit_tbl_hdr OKS_EXTWARPRGM_PVT.SalesCredit_tbl; --mmadhavi bug 4174921

499: l_Ord_hdr_rec l_Ord_Hdr_csr%rowtype ;
500: l_extwar_rec OKS_EXTWARPRGM_PVT .extwar_rec_Type;
501: p_contact_tbl OKS_EXTWARPRGM_PVT .contact_tbl;
502: l_SalesCredit_tbl OKS_EXTWARPRGM_PVT.SalesCredit_tbl;
503: l_SalesCredit_tbl_hdr OKS_EXTWARPRGM_PVT.SalesCredit_tbl; --mmadhavi bug 4174921
504: l_pricing_attributes_in OKS_EXTWARPRGM_PVT.Pricing_attributes_Type;
505: l_inst_dtls_tbl OKS_IHD_PVT.ihdv_tbl_type ;
506: l_insthist_rec OKS_INS_PVT.insv_rec_type;
507:

Line 504: l_pricing_attributes_in OKS_EXTWARPRGM_PVT.Pricing_attributes_Type;

500: l_extwar_rec OKS_EXTWARPRGM_PVT .extwar_rec_Type;
501: p_contact_tbl OKS_EXTWARPRGM_PVT .contact_tbl;
502: l_SalesCredit_tbl OKS_EXTWARPRGM_PVT.SalesCredit_tbl;
503: l_SalesCredit_tbl_hdr OKS_EXTWARPRGM_PVT.SalesCredit_tbl; --mmadhavi bug 4174921
504: l_pricing_attributes_in OKS_EXTWARPRGM_PVT.Pricing_attributes_Type;
505: l_inst_dtls_tbl OKS_IHD_PVT.ihdv_tbl_type ;
506: l_insthist_rec OKS_INS_PVT.insv_rec_type;
507:
508:

Line 868: OKS_EXTWARPRGM_PVT .Create_Contract_IBNEW

864: x_inst_dtls_tbl(l_ptr).TRANSACTION_TYPE := 'NEW';
865: x_inst_dtls_tbl(l_ptr).INSTANCE_ID_NEW := p_instance_rec.old_customer_product_id;
866: x_inst_dtls_tbl(l_ptr).INSTANCE_QTY_NEW := p_instance_rec.old_quantity;
867:
868: OKS_EXTWARPRGM_PVT .Create_Contract_IBNEW
869: (
870: p_extwar_rec => l_ExtWar_Rec
871: , p_contact_tbl_in => p_contact_tbl
872: , p_salescredit_tbl_hdr_in => l_SalesCredit_tbl_hdr --mmadhavi bug 4174921

Line 883: 'oks_extwarprgm_pvt .create_contract_ibnew(Return status = '||l_return_status ||

879: ,x_msg_data => x_msg_data
880: );
881: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
882: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
883: 'oks_extwarprgm_pvt .create_contract_ibnew(Return status = '||l_return_status ||
884: ',Chr_id = ' || l_chr_Id || ')');
885: END IF;
886:
887: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

Line 1078: OKS_EXTWARPRGM_PVT .Create_Contract_IBNEW

1074: x_inst_dtls_tbl(l_ptr).TRANSACTION_TYPE := 'NEW';
1075: x_inst_dtls_tbl(l_ptr).INSTANCE_ID_NEW := p_instance_rec.old_customer_product_id;
1076: x_inst_dtls_tbl(l_ptr).INSTANCE_QTY_NEW := p_instance_rec.old_quantity;
1077:
1078: OKS_EXTWARPRGM_PVT .Create_Contract_IBNEW
1079: (
1080: p_extwar_rec => l_ExtWar_Rec
1081: , p_contact_tbl_in => p_contact_tbl
1082: , p_salescredit_tbl_hdr_in => l_SalesCredit_tbl_hdr --mmadhavi bug 4174921

Line 1093: 'oks_extwarprgm_pvt .create_contract_ibnew(Return status = '||l_return_status || ')');

1089: , x_msg_data => x_msg_data
1090: );
1091: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1092: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
1093: 'oks_extwarprgm_pvt .create_contract_ibnew(Return status = '||l_return_status || ')');
1094: END IF;
1095:
1096: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then
1097:

Line 2030: k_trf_tbl OKS_EXTWARPRGM_PVT.Contract_trf_tbl;

2026: select instance_number
2027: from csi_item_instances
2028: where instance_id = p_cp_id;
2029:
2030: k_trf_tbl OKS_EXTWARPRGM_PVT.Contract_trf_tbl;
2031: k_trm_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2032: k_ret_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2033: k_idc_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2034: k_spl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;

Line 2031: k_trm_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;

2027: from csi_item_instances
2028: where instance_id = p_cp_id;
2029:
2030: k_trf_tbl OKS_EXTWARPRGM_PVT.Contract_trf_tbl;
2031: k_trm_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2032: k_ret_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2033: k_idc_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2034: k_spl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2035: k_rpl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;

Line 2032: k_ret_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;

2028: where instance_id = p_cp_id;
2029:
2030: k_trf_tbl OKS_EXTWARPRGM_PVT.Contract_trf_tbl;
2031: k_trm_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2032: k_ret_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2033: k_idc_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2034: k_spl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2035: k_rpl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2036: k_upd_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;

Line 2033: k_idc_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;

2029:
2030: k_trf_tbl OKS_EXTWARPRGM_PVT.Contract_trf_tbl;
2031: k_trm_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2032: k_ret_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2033: k_idc_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2034: k_spl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2035: k_rpl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2036: k_upd_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2037:

Line 2034: k_spl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;

2030: k_trf_tbl OKS_EXTWARPRGM_PVT.Contract_trf_tbl;
2031: k_trm_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2032: k_ret_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2033: k_idc_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2034: k_spl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2035: k_rpl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2036: k_upd_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2037:
2038:

Line 2035: k_rpl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;

2031: k_trm_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2032: k_ret_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2033: k_idc_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2034: k_spl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2035: k_rpl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2036: k_upd_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2037:
2038:
2039: l_return_status Varchar2(1):= OKC_API.G_RET_STS_SUCCESS;

Line 2036: k_upd_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;

2032: k_ret_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2033: k_idc_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2034: k_spl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2035: k_rpl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2036: k_upd_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2037:
2038:
2039: l_return_status Varchar2(1):= OKC_API.G_RET_STS_SUCCESS;
2040: l_inst_dtls_tbl OKS_IHD_PVT.ihdv_tbl_type ;

Line 2273: OKS_EXTWARPRGM_PVT .Create_k_System_TRANSFER

2269:
2270: If K_trf_tbl.count > 0 Then
2271:
2272:
2273: OKS_EXTWARPRGM_PVT .Create_k_System_TRANSFER
2274: (
2275: p_kdtl_tbl => k_trf_tbl,
2276: x_return_status => l_return_status,
2277: x_msg_count => x_msg_count,

Line 2282: 'oks_extwarprgm_pvt .create_k_system_transfer(Return status = '||l_return_status ||')' );

2278: x_msg_data => x_msg_data
2279: );
2280: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2281: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2282: 'oks_extwarprgm_pvt .create_k_system_transfer(Return status = '||l_return_status ||')' );
2283: End If;
2284:
2285: x_return_status := l_return_status;
2286: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

Line 2305: OKS_EXTWARPRGM_PVT.Create_COntract_Terminate

2301:
2302:
2303: If K_trm_tbl.count > 0 Then
2304:
2305: OKS_EXTWARPRGM_PVT.Create_COntract_Terminate
2306: (
2307: p_kdtl_tbl => k_trm_tbl,
2308: x_return_status => l_return_status,
2309: x_msg_count => x_msg_count,

Line 2337: OKS_EXTWARPRGM_PVT.Create_Contract_IBReturn

2333: --errorout_n('in return count'||K_ret_tbl.count);
2334:
2335: If K_ret_tbl.count > 0 Then
2336:
2337: OKS_EXTWARPRGM_PVT.Create_Contract_IBReturn
2338: (
2339: p_kdtl_tbl => k_ret_tbl,
2340: x_return_status => l_return_status,
2341: x_msg_count => x_msg_count,

Line 2374: OKS_EXTWARPRGM_PVT.Create_Contract_IBupdate

2370:
2371:
2372: If K_upd_tbl.count > 0 Then
2373:
2374: OKS_EXTWARPRGM_PVT.Create_Contract_IBupdate
2375: (
2376: p_kdtl_tbl => k_upd_tbl,
2377: x_return_status => l_return_status,
2378: x_msg_count => x_msg_count,

Line 2408: OKS_EXTWARPRGM_PVT.Update_Contract_IDC

2404: End If;
2405:
2406:
2407: If K_idc_tbl.count > 0 Then
2408: OKS_EXTWARPRGM_PVT.Update_Contract_IDC
2409: (
2410: p_kdtl_tbl => k_idc_tbl,
2411: x_return_status => l_return_status,
2412: x_msg_count => x_msg_count,

Line 2442: OKS_EXTWARPRGM_PVT.Create_Contract_IBSPLIT

2438:
2439:
2440: If K_spl_tbl.count > 0 Then
2441:
2442: OKS_EXTWARPRGM_PVT.Create_Contract_IBSPLIT
2443: (
2444: p_kdtl_tbl => k_spl_tbl,
2445: x_return_status => l_return_status,
2446: x_msg_count => x_msg_count,

Line 2522: OKS_EXTWARPRGM_PVT.Update_Contract_IBReplace

2518: END IF;
2519: --Call out ends here
2520: IF l_process_status = 'C' THEN
2521:
2522: OKS_EXTWARPRGM_PVT.Update_Contract_IBReplace
2523: (
2524: p_kdtl_tbl => k_rpl_tbl,
2525: x_return_status => l_return_status,
2526: x_msg_count => x_msg_count,