DBA Data[Home] [Help]

APPS.OKS_IBINT_PUB dependencies on OKS_EXTWARPRGM_PVT

Line 496: l_extwar_rec OKS_EXTWARPRGM_PVT .extwar_rec_Type;

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

Line 497: p_contact_tbl OKS_EXTWARPRGM_PVT .contact_tbl;

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

Line 498: l_SalesCredit_tbl OKS_EXTWARPRGM_PVT.SalesCredit_tbl;

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

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

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

Line 500: l_pricing_attributes_in OKS_EXTWARPRGM_PVT.Pricing_attributes_Type;

496: l_extwar_rec OKS_EXTWARPRGM_PVT .extwar_rec_Type;
497: p_contact_tbl OKS_EXTWARPRGM_PVT .contact_tbl;
498: l_SalesCredit_tbl OKS_EXTWARPRGM_PVT.SalesCredit_tbl;
499: l_SalesCredit_tbl_hdr OKS_EXTWARPRGM_PVT.SalesCredit_tbl; --mmadhavi bug 4174921
500: l_pricing_attributes_in OKS_EXTWARPRGM_PVT.Pricing_attributes_Type;
501: l_inst_dtls_tbl OKS_IHD_PVT.ihdv_tbl_type ;
502: l_insthist_rec OKS_INS_PVT.insv_rec_type;
503:
504:

Line 864: OKS_EXTWARPRGM_PVT .Create_Contract_IBNEW

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

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

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

Line 1093: OKS_EXTWARPRGM_PVT .Create_Contract_IBNEW

1089: x_inst_dtls_tbl(l_ptr).TRANSACTION_TYPE := 'NEW';
1090: x_inst_dtls_tbl(l_ptr).INSTANCE_ID_NEW := p_instance_rec.old_customer_product_id;
1091: x_inst_dtls_tbl(l_ptr).INSTANCE_QTY_NEW := p_instance_rec.old_quantity;
1092:
1093: OKS_EXTWARPRGM_PVT .Create_Contract_IBNEW
1094: (
1095: p_extwar_rec => l_ExtWar_Rec
1096: , p_contact_tbl_in => p_contact_tbl
1097: , p_salescredit_tbl_hdr_in => l_SalesCredit_tbl_hdr --mmadhavi bug 4174921

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

1104: , x_msg_data => x_msg_data
1105: );
1106: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1107: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_NEW',
1108: 'oks_extwarprgm_pvt .create_contract_ibnew(Return status = '||l_return_status || ')');
1109: END IF;
1110:
1111: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then
1112:

Line 2050: k_trf_tbl OKS_EXTWARPRGM_PVT.Contract_trf_tbl;

2046: select instance_number
2047: from csi_item_instances
2048: where instance_id = p_cp_id;
2049:
2050: k_trf_tbl OKS_EXTWARPRGM_PVT.Contract_trf_tbl;
2051: k_trm_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2052: k_ret_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2053: k_idc_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2054: k_spl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;

Line 2051: k_trm_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;

2047: from csi_item_instances
2048: where instance_id = p_cp_id;
2049:
2050: k_trf_tbl OKS_EXTWARPRGM_PVT.Contract_trf_tbl;
2051: k_trm_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2052: k_ret_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2053: k_idc_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2054: k_spl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2055: k_rpl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;

Line 2052: k_ret_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;

2048: where instance_id = p_cp_id;
2049:
2050: k_trf_tbl OKS_EXTWARPRGM_PVT.Contract_trf_tbl;
2051: k_trm_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2052: k_ret_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2053: k_idc_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2054: k_spl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2055: k_rpl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2056: k_upd_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;

Line 2053: k_idc_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;

2049:
2050: k_trf_tbl OKS_EXTWARPRGM_PVT.Contract_trf_tbl;
2051: k_trm_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2052: k_ret_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2053: k_idc_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2054: k_spl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2055: k_rpl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2056: k_upd_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2057:

Line 2054: k_spl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;

2050: k_trf_tbl OKS_EXTWARPRGM_PVT.Contract_trf_tbl;
2051: k_trm_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2052: k_ret_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2053: k_idc_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2054: k_spl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2055: k_rpl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2056: k_upd_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2057:
2058:

Line 2055: k_rpl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;

2051: k_trm_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2052: k_ret_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2053: k_idc_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2054: k_spl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2055: k_rpl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2056: k_upd_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2057:
2058:
2059: l_return_status Varchar2(1):= OKC_API.G_RET_STS_SUCCESS;

Line 2056: k_upd_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;

2052: k_ret_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2053: k_idc_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2054: k_spl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2055: k_rpl_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2056: k_upd_tbl OKS_EXTWARPRGM_PVT.Contract_tbl;
2057:
2058:
2059: l_return_status Varchar2(1):= OKC_API.G_RET_STS_SUCCESS;
2060: l_inst_dtls_tbl OKS_IHD_PVT.ihdv_tbl_type ;

Line 2293: OKS_EXTWARPRGM_PVT .Create_k_System_TRANSFER

2289:
2290: If K_trf_tbl.count > 0 Then
2291:
2292:
2293: OKS_EXTWARPRGM_PVT .Create_k_System_TRANSFER
2294: (
2295: p_kdtl_tbl => k_trf_tbl,
2296: x_return_status => l_return_status,
2297: x_msg_count => x_msg_count,

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

2298: x_msg_data => x_msg_data
2299: );
2300: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2301: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2302: 'oks_extwarprgm_pvt .create_k_system_transfer(Return status = '||l_return_status ||')' );
2303: End If;
2304:
2305: x_return_status := l_return_status;
2306: If not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

Line 2325: OKS_EXTWARPRGM_PVT.Create_COntract_Terminate

2321:
2322:
2323: If K_trm_tbl.count > 0 Then
2324:
2325: OKS_EXTWARPRGM_PVT.Create_COntract_Terminate
2326: (
2327: p_kdtl_tbl => k_trm_tbl,
2328: x_return_status => l_return_status,
2329: x_msg_count => x_msg_count,

Line 2357: OKS_EXTWARPRGM_PVT.Create_Contract_IBReturn

2353: --errorout_n('in return count'||K_ret_tbl.count);
2354:
2355: If K_ret_tbl.count > 0 Then
2356:
2357: OKS_EXTWARPRGM_PVT.Create_Contract_IBReturn
2358: (
2359: p_kdtl_tbl => k_ret_tbl,
2360: x_return_status => l_return_status,
2361: x_msg_count => x_msg_count,

Line 2394: OKS_EXTWARPRGM_PVT.Create_Contract_IBupdate

2390:
2391:
2392: If K_upd_tbl.count > 0 Then
2393:
2394: OKS_EXTWARPRGM_PVT.Create_Contract_IBupdate
2395: (
2396: p_kdtl_tbl => k_upd_tbl,
2397: x_return_status => l_return_status,
2398: x_msg_count => x_msg_count,

Line 2428: OKS_EXTWARPRGM_PVT.Update_Contract_IDC

2424: End If;
2425:
2426:
2427: If K_idc_tbl.count > 0 Then
2428: OKS_EXTWARPRGM_PVT.Update_Contract_IDC
2429: (
2430: p_kdtl_tbl => k_idc_tbl,
2431: x_return_status => l_return_status,
2432: x_msg_count => x_msg_count,

Line 2462: OKS_EXTWARPRGM_PVT.Create_Contract_IBSPLIT

2458:
2459:
2460: If K_spl_tbl.count > 0 Then
2461:
2462: OKS_EXTWARPRGM_PVT.Create_Contract_IBSPLIT
2463: (
2464: p_kdtl_tbl => k_spl_tbl,
2465: x_return_status => l_return_status,
2466: x_msg_count => x_msg_count,

Line 2542: OKS_EXTWARPRGM_PVT.Update_Contract_IBReplace

2538: END IF;
2539: --Call out ends here
2540: IF l_process_status = 'C' THEN
2541:
2542: OKS_EXTWARPRGM_PVT.Update_Contract_IBReplace
2543: (
2544: p_kdtl_tbl => k_rpl_tbl,
2545: x_return_status => l_return_status,
2546: x_msg_count => x_msg_count,