DBA Data[Home] [Help]

APPS.OKS_REPRICE_PVT dependencies on OKC_CONTRACT_PUB

Line 611: p_chrv_rec IN okc_contract_pub.chrv_rec_type,

607: END IF;
608: END get_oldcontractline_dates;
609:
610: PROCEDURE update_header (
611: p_chrv_rec IN okc_contract_pub.chrv_rec_type,
612: x_return_status OUT NOCOPY VARCHAR2
613: ) IS
614: l_api_name CONSTANT VARCHAR2 (30) := 'update_header';
615: l_chrv_rec okc_contract_pub.chrv_rec_type

Line 615: l_chrv_rec okc_contract_pub.chrv_rec_type

611: p_chrv_rec IN okc_contract_pub.chrv_rec_type,
612: x_return_status OUT NOCOPY VARCHAR2
613: ) IS
614: l_api_name CONSTANT VARCHAR2 (30) := 'update_header';
615: l_chrv_rec okc_contract_pub.chrv_rec_type
616: := p_chrv_rec;
617: x_chrv_rec okc_contract_pub.chrv_rec_type;
618: l_api_version NUMBER := 1.0;
619: l_init_msg_list VARCHAR2 (1) := okc_api.g_false;

Line 617: x_chrv_rec okc_contract_pub.chrv_rec_type;

613: ) IS
614: l_api_name CONSTANT VARCHAR2 (30) := 'update_header';
615: l_chrv_rec okc_contract_pub.chrv_rec_type
616: := p_chrv_rec;
617: x_chrv_rec okc_contract_pub.chrv_rec_type;
618: l_api_version NUMBER := 1.0;
619: l_init_msg_list VARCHAR2 (1) := okc_api.g_false;
620: l_return_status VARCHAR2 (1)
621: := okc_api.g_ret_sts_success;

Line 637: okc_contract_pub.update_contract_header

633: l_api_name
634: );
635: END IF;
636:
637: okc_contract_pub.update_contract_header
638: (p_api_version => l_api_version,
639: p_init_msg_list => l_init_msg_list,
640: x_return_status => l_return_status,
641: x_msg_count => l_msg_count,

Line 705: p_clev_rec IN okc_contract_pub.clev_rec_type,

701: );
702: END update_header;
703:
704: PROCEDURE update_line (
705: p_clev_rec IN okc_contract_pub.clev_rec_type,
706: x_return_status OUT NOCOPY VARCHAR2
707: ) IS
708: l_api_name CONSTANT VARCHAR2 (30) := 'update_line';
709: l_clev_rec okc_contract_pub.clev_rec_type

Line 709: l_clev_rec okc_contract_pub.clev_rec_type

705: p_clev_rec IN okc_contract_pub.clev_rec_type,
706: x_return_status OUT NOCOPY VARCHAR2
707: ) IS
708: l_api_name CONSTANT VARCHAR2 (30) := 'update_line';
709: l_clev_rec okc_contract_pub.clev_rec_type
710: := p_clev_rec;
711: x_clev_rec okc_contract_pub.clev_rec_type;
712: l_api_version NUMBER := 1.0;
713: l_init_msg_list VARCHAR2 (1) := okc_api.g_false;

Line 711: x_clev_rec okc_contract_pub.clev_rec_type;

707: ) IS
708: l_api_name CONSTANT VARCHAR2 (30) := 'update_line';
709: l_clev_rec okc_contract_pub.clev_rec_type
710: := p_clev_rec;
711: x_clev_rec okc_contract_pub.clev_rec_type;
712: l_api_version NUMBER := 1.0;
713: l_init_msg_list VARCHAR2 (1) := okc_api.g_false;
714: l_return_status VARCHAR2 (1)
715: := okc_api.g_ret_sts_success;

Line 731: okc_contract_pub.update_contract_line (p_api_version => l_api_version,

727: l_api_name
728: );
729: END IF;
730:
731: okc_contract_pub.update_contract_line (p_api_version => l_api_version,
732: p_init_msg_list => l_init_msg_list,
733: x_return_status => l_return_status,
734: x_msg_count => l_msg_count,
735: x_msg_data => l_msg_data,

Line 859: l_chrv_rec okc_contract_pub.chrv_rec_type;

855:
856: l_line_id NUMBER;
857: l_tot_subline_amt NUMBER;
858: l_tot_topline_amt NUMBER;
859: l_chrv_rec okc_contract_pub.chrv_rec_type;
860: l_clev_rec okc_contract_pub.clev_rec_type;
861: l_return_status VARCHAR2 (1) := g_ret_sts_success;
862:
863: l_tot_subline_tax NUMBER;

Line 860: l_clev_rec okc_contract_pub.clev_rec_type;

856: l_line_id NUMBER;
857: l_tot_subline_amt NUMBER;
858: l_tot_topline_amt NUMBER;
859: l_chrv_rec okc_contract_pub.chrv_rec_type;
860: l_clev_rec okc_contract_pub.clev_rec_type;
861: l_return_status VARCHAR2 (1) := g_ret_sts_success;
862:
863: l_tot_subline_tax NUMBER;
864: l_tot_topline_tax NUMBER;

Line 1442: l_clev_rec okc_contract_pub.clev_rec_type;

1438: FROM oks_subscr_elements
1439: WHERE dnz_cle_id = p_line_id;
1440:
1441: l_new_amount NUMBER;
1442: l_clev_rec okc_contract_pub.clev_rec_type;
1443: l_price_type VARCHAR2 (10);
1444: l_detail_rec oks_qp_pkg.input_details;
1445: l_price_details oks_qp_pkg.price_details;
1446: l_modifier_details qp_preq_grp.line_detail_tbl_type;

Line 2010: l_chr_rec_in okc_contract_pub.chrv_rec_type;

2006:
2007:
2008:
2009:
2010: l_chr_rec_in okc_contract_pub.chrv_rec_type;
2011: l_chr_rec_out okc_contract_pub.chrv_rec_type;
2012: l_scev_rec_in oks_subscr_elems_pub.scev_rec_type;
2013: l_scev_rec_out oks_subscr_elems_pub.scev_rec_type;
2014: l_pricelist_id NUMBER;

Line 2011: l_chr_rec_out okc_contract_pub.chrv_rec_type;

2007:
2008:
2009:
2010: l_chr_rec_in okc_contract_pub.chrv_rec_type;
2011: l_chr_rec_out okc_contract_pub.chrv_rec_type;
2012: l_scev_rec_in oks_subscr_elems_pub.scev_rec_type;
2013: l_scev_rec_out oks_subscr_elems_pub.scev_rec_type;
2014: l_pricelist_id NUMBER;
2015: l_line_rec l_line_csr%ROWTYPE;

Line 2030: l_clev_rec okc_contract_pub.clev_rec_type;

2026: l_init_msg_list VARCHAR2 (1) := okc_api.g_false;
2027: l_return_status VARCHAR2 (1) := g_ret_sts_success;
2028: l_msg_count NUMBER;
2029: l_msg_data VARCHAR2 (2000);
2030: l_clev_rec okc_contract_pub.clev_rec_type;
2031:
2032: CURSOR l_currcode_csr (
2033: p_hdr_id NUMBER
2034: ) IS

Line 2216: okc_contract_pub.update_contract_header

2212: -- Bug 4628808
2213: IF p_reprice_rec.price_list_id <> NVL (l_pricelist_id, -9999) THEN
2214: l_chr_rec_in.ID := p_reprice_rec.contract_id;
2215: l_chr_rec_in.price_list_id := p_reprice_rec.price_list_id;
2216: okc_contract_pub.update_contract_header
2217: (p_api_version => l_api_version,
2218: p_init_msg_list => l_init_msg_list,
2219: x_return_status => l_return_status,
2220: x_msg_count => l_msg_count,

Line 3010: l_clev_rec okc_contract_pub.clev_rec_type;

3006: l_init_msg_list VARCHAR2 (1) := okc_api.g_false;
3007: l_return_status VARCHAR2 (1) := g_ret_sts_success;
3008: l_old_start_date DATE;
3009: l_old_end_date DATE;
3010: l_clev_rec okc_contract_pub.clev_rec_type;
3011: l_chr_rec_in okc_contract_pub.chrv_rec_type;
3012: l_chr_rec_out okc_contract_pub.chrv_rec_type;
3013: l_scev_rec_in oks_subscr_elems_pub.scev_rec_type;
3014: l_scev_rec_out oks_subscr_elems_pub.scev_rec_type;

Line 3011: l_chr_rec_in okc_contract_pub.chrv_rec_type;

3007: l_return_status VARCHAR2 (1) := g_ret_sts_success;
3008: l_old_start_date DATE;
3009: l_old_end_date DATE;
3010: l_clev_rec okc_contract_pub.clev_rec_type;
3011: l_chr_rec_in okc_contract_pub.chrv_rec_type;
3012: l_chr_rec_out okc_contract_pub.chrv_rec_type;
3013: l_scev_rec_in oks_subscr_elems_pub.scev_rec_type;
3014: l_scev_rec_out oks_subscr_elems_pub.scev_rec_type;
3015: l_modifier_details qp_preq_grp.line_detail_tbl_type;

Line 3012: l_chr_rec_out okc_contract_pub.chrv_rec_type;

3008: l_old_start_date DATE;
3009: l_old_end_date DATE;
3010: l_clev_rec okc_contract_pub.clev_rec_type;
3011: l_chr_rec_in okc_contract_pub.chrv_rec_type;
3012: l_chr_rec_out okc_contract_pub.chrv_rec_type;
3013: l_scev_rec_in oks_subscr_elems_pub.scev_rec_type;
3014: l_scev_rec_out oks_subscr_elems_pub.scev_rec_type;
3015: l_modifier_details qp_preq_grp.line_detail_tbl_type;
3016: l_detail_rec oks_qp_pkg.input_details;

Line 3092: fnd_file.put_line(FND_FILE.LOG,'renewal_pricing_type = LST, Calling okc_contract_pub.update_contract_header');

3088: oks_renew_pvt.debug_log
3089: (p_program_name => 'Renewal Consolidation Reprice::',
3090: p_perf_msg => 'Pricing type - Price List - Header Pricing');
3091:
3092: fnd_file.put_line(FND_FILE.LOG,'renewal_pricing_type = LST, Calling okc_contract_pub.update_contract_header');
3093:
3094: okc_contract_pub.update_contract_header
3095: (p_api_version => l_api_version,
3096: p_init_msg_list => l_init_msg_list,

Line 3094: okc_contract_pub.update_contract_header

3090: p_perf_msg => 'Pricing type - Price List - Header Pricing');
3091:
3092: fnd_file.put_line(FND_FILE.LOG,'renewal_pricing_type = LST, Calling okc_contract_pub.update_contract_header');
3093:
3094: okc_contract_pub.update_contract_header
3095: (p_api_version => l_api_version,
3096: p_init_msg_list => l_init_msg_list,
3097: x_return_status => l_return_status,
3098: x_msg_count => l_msg_count,

Line 3105: fnd_file.put_line(FND_FILE.LOG,'AFTER Calling okc_contract_pub.update_contract_header x_return_status= '||l_return_status);

3101: p_chrv_rec => l_chr_rec_in,
3102: x_chrv_rec => l_chr_rec_out
3103: );
3104:
3105: fnd_file.put_line(FND_FILE.LOG,'AFTER Calling okc_contract_pub.update_contract_header x_return_status= '||l_return_status);
3106:
3107: oks_renew_pvt.debug_log
3108: (p_program_name => 'Renewal Consolidation Reprice::',
3109: p_perf_msg => 'UPDATE CONTRACT HDR - RETURN = ' ||