eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_EXTWARPRGM_PVT dependencies on OKS_EXTWARPRGM_PVT

Line 1: PACKAGE BODY oks_extwarprgm_pvt AS

1: PACKAGE BODY oks_extwarprgm_pvt AS
2: /* $Header: OKSREWRB.pls 120.87.12010000.2 2008/11/12 07:17:31 harlaksh ship $ */
3:
4: TYPE p_srvline_rec IS RECORD (
5: k_line_id NUMBER

Line 5675: p_contact_tbl_in IN oks_extwarprgm_pvt.contact_tbl,

5671: END create_k_covered_levels;
5672:
5673: PROCEDURE create_contract_ibnew (
5674: p_extwar_rec IN extwar_rec_type,
5675: p_contact_tbl_in IN oks_extwarprgm_pvt.contact_tbl,
5676: p_salescredit_tbl_hdr_in IN oks_extwarprgm_pvt.salescredit_tbl,
5677: --mmadhavi bug 4174921
5678: p_salescredit_tbl_line_in IN oks_extwarprgm_pvt.salescredit_tbl,
5679: p_price_attribs_in IN oks_extwarprgm_pvt.pricing_attributes_type,

Line 5676: p_salescredit_tbl_hdr_in IN oks_extwarprgm_pvt.salescredit_tbl,

5672:
5673: PROCEDURE create_contract_ibnew (
5674: p_extwar_rec IN extwar_rec_type,
5675: p_contact_tbl_in IN oks_extwarprgm_pvt.contact_tbl,
5676: p_salescredit_tbl_hdr_in IN oks_extwarprgm_pvt.salescredit_tbl,
5677: --mmadhavi bug 4174921
5678: p_salescredit_tbl_line_in IN oks_extwarprgm_pvt.salescredit_tbl,
5679: p_price_attribs_in IN oks_extwarprgm_pvt.pricing_attributes_type,
5680: x_inst_dtls_tbl IN OUT NOCOPY oks_ihd_pvt.ihdv_tbl_type,

Line 5678: p_salescredit_tbl_line_in IN oks_extwarprgm_pvt.salescredit_tbl,

5674: p_extwar_rec IN extwar_rec_type,
5675: p_contact_tbl_in IN oks_extwarprgm_pvt.contact_tbl,
5676: p_salescredit_tbl_hdr_in IN oks_extwarprgm_pvt.salescredit_tbl,
5677: --mmadhavi bug 4174921
5678: p_salescredit_tbl_line_in IN oks_extwarprgm_pvt.salescredit_tbl,
5679: p_price_attribs_in IN oks_extwarprgm_pvt.pricing_attributes_type,
5680: x_inst_dtls_tbl IN OUT NOCOPY oks_ihd_pvt.ihdv_tbl_type,
5681: x_chrid OUT NOCOPY NUMBER,
5682: x_return_status OUT NOCOPY VARCHAR2,

Line 5679: p_price_attribs_in IN oks_extwarprgm_pvt.pricing_attributes_type,

5675: p_contact_tbl_in IN oks_extwarprgm_pvt.contact_tbl,
5676: p_salescredit_tbl_hdr_in IN oks_extwarprgm_pvt.salescredit_tbl,
5677: --mmadhavi bug 4174921
5678: p_salescredit_tbl_line_in IN oks_extwarprgm_pvt.salescredit_tbl,
5679: p_price_attribs_in IN oks_extwarprgm_pvt.pricing_attributes_type,
5680: x_inst_dtls_tbl IN OUT NOCOPY oks_ihd_pvt.ihdv_tbl_type,
5681: x_chrid OUT NOCOPY NUMBER,
5682: x_return_status OUT NOCOPY VARCHAR2,
5683: x_msg_count OUT NOCOPY NUMBER,

Line 5718: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;

5714: l_hdrdates_rec l_hdrdates_csr%ROWTYPE;
5715: --l_ctr NUMBER := 0;
5716:
5717: --Contact
5718: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
5719: --SalesCredit
5720: l_salescredit_tbl oks_extwarprgm_pvt.salescredit_tbl;
5721: l_api_version CONSTANT NUMBER := 1.0;
5722: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;

Line 5720: l_salescredit_tbl oks_extwarprgm_pvt.salescredit_tbl;

5716:
5717: --Contact
5718: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
5719: --SalesCredit
5720: l_salescredit_tbl oks_extwarprgm_pvt.salescredit_tbl;
5721: l_api_version CONSTANT NUMBER := 1.0;
5722: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
5723: l_index VARCHAR2 (2000);
5724: l_rule_group_id NUMBER;

Line 5817: oks_extwarprgm_pvt.create_k_hdr

5813: get_sts_code ('ACTIVE', NULL, l_ste_code, l_sts_code);
5814: END IF;
5815:
5816: l_hdr_rec.sts_code := l_sts_code;
5817: oks_extwarprgm_pvt.create_k_hdr
5818: (p_k_header_rec => l_hdr_rec,
5819: p_contact_tbl => p_contact_tbl_in,
5820: p_salescredit_tbl_in => p_salescredit_tbl_hdr_in,
5821: --mmadhavi bug 4174921

Line 5836: 'oks_extwarprgm_pvt.create_k_hdr(Return status = '

5832: fnd_log.STRING
5833: (fnd_log.level_event,
5834: g_module_current
5835: || '.Create_contract_Ibnew.after_create.header',
5836: 'oks_extwarprgm_pvt.create_k_hdr(Return status = '
5837: || l_return_status
5838: || ')'
5839: );
5840: END IF;

Line 5922: oks_extwarprgm_pvt.create_k_service_lines

5918: get_sts_code ('ACTIVE', NULL, l_ste_code, l_sts_code);
5919: END IF;
5920:
5921: l_line_rec.line_sts_code := l_sts_code;
5922: oks_extwarprgm_pvt.create_k_service_lines
5923: (p_k_line_rec => l_line_rec,
5924: p_contact_tbl => p_contact_tbl_in,
5925: p_salescredit_tbl_in => p_salescredit_tbl_line_in,
5926: p_caller => 'IB',

Line 5940: 'oks_extwarprgm_pvt.create_k_service_lines(Return status = '

5936: fnd_log.STRING
5937: (fnd_log.level_event,
5938: g_module_current
5939: || '.Create_contract_Ibnew.after_create.service_line',
5940: 'oks_extwarprgm_pvt.create_k_service_lines(Return status = '
5941: || l_return_status
5942: || ')'
5943: );
5944: END IF;

Line 5989: oks_extwarprgm_pvt.create_k_covered_levels

5985: get_sts_code ('ACTIVE', NULL, l_ste_code, l_sts_code);
5986: END IF;
5987:
5988: l_covd_rec.product_sts_code := l_sts_code;
5989: oks_extwarprgm_pvt.create_k_covered_levels
5990: (p_k_covd_rec => l_covd_rec,
5991: p_price_attribs => p_price_attribs_in,
5992: p_caller => 'IB',
5993: x_order_error => l_temp,

Line 6007: 'oks_extwarprgm_pvt.create_k_covered_levels(Return status = '

6003: fnd_log.STRING
6004: (fnd_log.level_event,
6005: g_module_current
6006: || '.Create_contract_Ibnew.after_create.covered_line',
6007: 'oks_extwarprgm_pvt.create_k_covered_levels(Return status = '
6008: || l_return_status
6009: || ')'
6010: );
6011: END IF;

Line 6756: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;

6752: --Contract Line Table
6753: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
6754: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
6755: --SalesCredit
6756: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
6757: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
6758: l_qty1price NUMBER := 0;
6759: l_oldamt NUMBER (30, 2) := 0;
6760: l_no_of_days NUMBER := 0;

Line 6757: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;

6753: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
6754: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
6755: --SalesCredit
6756: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
6757: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
6758: l_qty1price NUMBER := 0;
6759: l_oldamt NUMBER (30, 2) := 0;
6760: l_no_of_days NUMBER := 0;
6761: l_new_value NUMBER := 0;

Line 6768: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;

6764: l_diff NUMBER := 0;
6765: l_covlvl_id NUMBER;
6766: l_rule_group_id NUMBER;
6767: l_rule_id NUMBER;
6768: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
6769: l_bill_schd_yn VARCHAR2 (1);
6770: l_list_price NUMBER := 0;
6771: l_spldt DATE;
6772: l_billed_amount NUMBER := 0;

Line 7179: oks_extwarprgm_pvt.create_k_covered_levels

7175: THEN
7176: RAISE g_exception_halt_validation;
7177: END IF;
7178:
7179: oks_extwarprgm_pvt.create_k_covered_levels
7180: (p_k_covd_rec => l_covd_rec,
7181: p_price_attribs => l_price_attribs_in,
7182: p_caller => 'IB',
7183: x_order_error => l_temp,

Line 7197: 'oks_extwarprgm_pvt.create_k_covered_levels(Return status = '

7193: fnd_log.STRING
7194: (fnd_log.level_event,
7195: g_module_current
7196: || '.CREATE_CONTRACT_IBSPLIT.after_create.cov_lvl',
7197: 'oks_extwarprgm_pvt.create_k_covered_levels(Return status = '
7198: || l_return_status
7199: || ')'
7200: );
7201: END IF;

Line 7615: -- l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;

7611: l_insthist_rec oks_ins_pvt.insv_rec_type;
7612: x_insthist_rec oks_ins_pvt.insv_rec_type;
7613: l_parameters VARCHAR2 (2000);
7614: l_renewal_id NUMBER;
7615: -- l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
7616: -- l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
7617: -- l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
7618: l_line_rec k_line_service_rec_type;
7619: l_covd_rec k_line_covered_level_rec_type;

Line 7616: -- l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;

7612: x_insthist_rec oks_ins_pvt.insv_rec_type;
7613: l_parameters VARCHAR2 (2000);
7614: l_renewal_id NUMBER;
7615: -- l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
7616: -- l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
7617: -- l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
7618: l_line_rec k_line_service_rec_type;
7619: l_covd_rec k_line_covered_level_rec_type;
7620: l_available_yn CHAR;

Line 7617: -- l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;

7613: l_parameters VARCHAR2 (2000);
7614: l_renewal_id NUMBER;
7615: -- l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
7616: -- l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
7617: -- l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
7618: l_line_rec k_line_service_rec_type;
7619: l_covd_rec k_line_covered_level_rec_type;
7620: l_available_yn CHAR;
7621: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;

Line 7640: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;

7636: l_covlvl_id NUMBER;
7637: --Contract Line Table
7638: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
7639: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
7640: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
7641: l_cov_rec l_cov_csr%ROWTYPE;
7642: l_api_version CONSTANT NUMBER := 1.0;
7643: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
7644: l_list_price NUMBER;

Line 8157: oks_extwarprgm_pvt.create_k_covered_levels

8153: l_covd_rec.price_uom := p_kdtl_tbl (l_ctr).price_uom_code;
8154: l_covd_rec.toplvl_uom_code := p_kdtl_tbl (l_ctr).toplvl_uom_code;
8155: --mchoudha added for bug#5233956
8156: l_covd_rec.toplvl_price_qty := p_kdtl_tbl (l_ctr).toplvl_price_qty;
8157: oks_extwarprgm_pvt.create_k_covered_levels
8158: (p_k_covd_rec => l_covd_rec,
8159: p_price_attribs => l_price_attribs_in,
8160: p_caller => 'IB',
8161: x_order_error => l_temp,

Line 8175: 'oks_extwarprgm_pvt.create_k_covered_levels(Return status = '

8171: fnd_log.STRING
8172: (fnd_log.level_event,
8173: g_module_current
8174: || '.CREATE_CONTRACT_IBREPLACE.create_cov_lvl',
8175: 'oks_extwarprgm_pvt.create_k_covered_levels(Return status = '
8176: || l_return_status
8177: );
8178: END IF;
8179:

Line 8531: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;

8527: l_old_cp_id NUMBER;
8528: l_insthist_rec oks_ins_pvt.insv_rec_type;
8529: x_insthist_rec oks_ins_pvt.insv_rec_type;
8530: l_parameters VARCHAR2 (2000);
8531: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
8532: --SalesCredit
8533: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
8534: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
8535: l_line_rec k_line_service_rec_type;

Line 8533: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;

8529: x_insthist_rec oks_ins_pvt.insv_rec_type;
8530: l_parameters VARCHAR2 (2000);
8531: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
8532: --SalesCredit
8533: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
8534: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
8535: l_line_rec k_line_service_rec_type;
8536: l_covd_rec k_line_covered_level_rec_type;
8537: l_available_yn CHAR;

Line 8534: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;

8530: l_parameters VARCHAR2 (2000);
8531: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
8532: --SalesCredit
8533: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
8534: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
8535: l_line_rec k_line_service_rec_type;
8536: l_covd_rec k_line_covered_level_rec_type;
8537: l_available_yn CHAR;
8538: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;

Line 9348: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;

9344: l_ref_num VARCHAR2 (30);
9345: l_msg_count NUMBER;
9346: l_msg_data VARCHAR2 (2000);
9347: l_trf_option VARCHAR2 (40);
9348: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
9349: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
9350: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
9351: l_line_rec oks_extwarprgm_pvt.k_line_service_rec_type;
9352: l_covd_rec oks_extwarprgm_pvt.k_line_covered_level_rec_type;

Line 9349: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;

9345: l_msg_count NUMBER;
9346: l_msg_data VARCHAR2 (2000);
9347: l_trf_option VARCHAR2 (40);
9348: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
9349: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
9350: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
9351: l_line_rec oks_extwarprgm_pvt.k_line_service_rec_type;
9352: l_covd_rec oks_extwarprgm_pvt.k_line_covered_level_rec_type;
9353: --l_kdtl_tbl oks_extwar_util_pvt.contract_tbl_type;

Line 9350: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;

9346: l_msg_data VARCHAR2 (2000);
9347: l_trf_option VARCHAR2 (40);
9348: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
9349: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
9350: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
9351: l_line_rec oks_extwarprgm_pvt.k_line_service_rec_type;
9352: l_covd_rec oks_extwarprgm_pvt.k_line_covered_level_rec_type;
9353: --l_kdtl_tbl oks_extwar_util_pvt.contract_tbl_type;
9354: l_available_yn CHAR;

Line 9351: l_line_rec oks_extwarprgm_pvt.k_line_service_rec_type;

9347: l_trf_option VARCHAR2 (40);
9348: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
9349: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
9350: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
9351: l_line_rec oks_extwarprgm_pvt.k_line_service_rec_type;
9352: l_covd_rec oks_extwarprgm_pvt.k_line_covered_level_rec_type;
9353: --l_kdtl_tbl oks_extwar_util_pvt.contract_tbl_type;
9354: l_available_yn CHAR;
9355: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;

Line 9352: l_covd_rec oks_extwarprgm_pvt.k_line_covered_level_rec_type;

9348: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
9349: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
9350: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
9351: l_line_rec oks_extwarprgm_pvt.k_line_service_rec_type;
9352: l_covd_rec oks_extwarprgm_pvt.k_line_covered_level_rec_type;
9353: --l_kdtl_tbl oks_extwar_util_pvt.contract_tbl_type;
9354: l_available_yn CHAR;
9355: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;
9356: l_line_found VARCHAR2 (1);

Line 9594: p_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;

9590: l_party_id NUMBER;
9591: l_party_name VARCHAR2 (360);
9592: l_return_status VARCHAR2 (1);
9593: l_rnrl_rec_out oks_renew_util_pvt.rnrl_rec_type;
9594: p_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
9595: l_chrid NUMBER;
9596: l_cacv_tbl_in okc_contract_pub.cacv_tbl_type;
9597: l_cacv_tbl_out okc_contract_pub.cacv_tbl_type;
9598: l_status VARCHAR2 (40);

Line 9606: l_salescredit_tbl oks_extwarprgm_pvt.salescredit_tbl;

9602: l_resource_id NUMBER;
9603: l_group_id NUMBER;
9604: l_access_level VARCHAR2 (3);
9605: l_sc_hdr_ctr NUMBER;
9606: l_salescredit_tbl oks_extwarprgm_pvt.salescredit_tbl;
9607: l_org_id NUMBER;
9608:
9609: CURSOR l_sales_credit_hdr_csr (p_chr_id NUMBER)
9610: IS

Line 9919: oks_extwarprgm_pvt.create_k_hdr

9915: l_salescredit_tbl (l_sc_hdr_ctr).sales_group_id :=
9916: l_sales_credit_hdr_rec.sales_group_id;
9917: END LOOP; -- For l_sales_credit_rec IN l_sales_credit_csr
9918:
9919: oks_extwarprgm_pvt.create_k_hdr
9920: (p_k_header_rec => l_hdr_rec,
9921: p_contact_tbl => p_contact_tbl_in,
9922: p_salescredit_tbl_in => l_salescredit_tbl
9923: -- mmadhavi bug 4174921

Line 9939: 'OKS_EXTWARPRGM_PVT.create_k_hdr(Return status = '

9935: fnd_log.STRING
9936: (fnd_log.level_statement,
9937: g_module_current
9938: || '.CREATE_K_SYSTEM_TRF.create_contract_header',
9939: 'OKS_EXTWARPRGM_PVT.create_k_hdr(Return status = '
9940: || l_return_status
9941: || ')'
9942: );
9943: END IF;

Line 10072: p_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;

10068: l_hdr_ste_code VARCHAR2 (40);
10069: l_lineid NUMBER;
10070: l_return_status VARCHAR2 (10);
10071: l_price_list_id NUMBER;
10072: p_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
10073: l_status VARCHAR2 (40);
10074: l_bill_to_id NUMBER;
10075: l_ship_to_id NUMBER;
10076: l_warranty_flag VARCHAR2 (2);

Line 10085: l_salescredit_tbl oks_extwarprgm_pvt.salescredit_tbl;

10081: FROM oks_k_sales_credits_v
10082: WHERE cle_id = p_cle_id;
10083:
10084: l_sc_ctr NUMBER;
10085: l_salescredit_tbl oks_extwarprgm_pvt.salescredit_tbl;
10086: BEGIN
10087: x_return_status := okc_api.g_ret_sts_success;
10088:
10089: OPEN l_line_rule_csr (p_kdtl_rec.service_line_id);

Line 10237: oks_extwarprgm_pvt.create_k_service_lines

10233: l_salescredit_tbl (l_sc_ctr).sales_group_id :=
10234: l_sales_credit_rec.sales_group_id;
10235: END LOOP; -- For l_sales_credit_rec IN l_sales_credit_csr
10236:
10237: oks_extwarprgm_pvt.create_k_service_lines
10238: (p_k_line_rec => l_line_rec,
10239: p_contact_tbl => p_contact_tbl_in,
10240: p_salescredit_tbl_in => l_salescredit_tbl,
10241: p_caller => 'ST',

Line 10255: 'oks_extwarprgm_pvt.create_k_service_lines(Return status = '

10251: fnd_log.STRING
10252: (fnd_log.level_statement,
10253: g_module_current
10254: || '.CREATE_K_SYSTEM_TRF.create_k_service_line',
10255: 'oks_extwarprgm_pvt.create_k_service_lines(Return status = '
10256: || l_return_status
10257: || ')'
10258: );
10259: END IF;

Line 10343: p_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;

10339: l_return_status VARCHAR2 (10);
10340: l_days NUMBER;
10341: l_newamt NUMBER;
10342: l_day1price NUMBER;
10343: p_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
10344: l_warranty_flag VARCHAR2 (2);
10345: l_covlvl_id NUMBER;
10346: l_update_top_line VARCHAR2 (1);
10347: l_status VARCHAR2 (40);

Line 10546: oks_extwarprgm_pvt.create_k_covered_levels

10542: l_covd_rec.product_sts_code := l_sts_code;
10543: END IF;
10544: END IF;
10545:
10546: oks_extwarprgm_pvt.create_k_covered_levels
10547: (p_k_covd_rec => l_covd_rec,
10548: p_price_attribs => p_price_attribs_in,
10549: p_caller => 'ST',
10550: x_order_error => l_temp,

Line 10724: OKS_RENEW_PVT.DEBUG_LOG( 'OKS_EXTWARPRGM_PVT.CREATE_K_SYSTEM_TRF :: CREATE_BCL_FOR_OM '|| l_return_status);

10720: X_RETURN_STATUS => l_return_status
10721: );
10722: If(G_FND_LOG_OPTION = 'Y') Then
10723: FND_FILE.PUT_LINE (FND_FILE.LOG,'IBNEW :- CREATE_BCL_FOR_OM ' || l_return_status );
10724: OKS_RENEW_PVT.DEBUG_LOG( 'OKS_EXTWARPRGM_PVT.CREATE_K_SYSTEM_TRF :: CREATE_BCL_FOR_OM '|| l_return_status);
10725: End if;
10726:
10727: If Not l_return_status = 'S' then
10728: Raise G_EXCEPTION_HALT_VALIDATION;

Line 10796: OKS_RENEW_PVT.DEBUG_LOG( 'OKS_EXTWARPRGM_PVT.CREATE_K_SYSTEM_TRF :: CREATE_BCL_FOR_OM '|| l_return_status);

10792: X_RETURN_STATUS => l_return_status
10793: );
10794: -- FND_FILE.PUT_LINE (FND_FILE.LOG,'IBNEW :- CREATE_BCL_FOR_OM ' || l_return_status );
10795: If(G_FND_LOG_OPTION = 'Y') Then
10796: OKS_RENEW_PVT.DEBUG_LOG( 'OKS_EXTWARPRGM_PVT.CREATE_K_SYSTEM_TRF :: CREATE_BCL_FOR_OM '|| l_return_status);
10797: End if;
10798: If Not l_return_status = 'S' then
10799: Raise G_EXCEPTION_HALT_VALIDATION;
10800: End if;

Line 13924: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;

13920: --Contract Line Table
13921: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
13922: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
13923: --SalesCredit
13924: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
13925: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
13926: l_line_rec k_line_service_rec_type;
13927: l_covd_rec k_line_covered_level_rec_type;
13928: l_available_yn CHAR;

Line 13925: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;

13921: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
13922: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
13923: --SalesCredit
13924: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
13925: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
13926: l_line_rec k_line_service_rec_type;
13927: l_covd_rec k_line_covered_level_rec_type;
13928: l_available_yn CHAR;
13929: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;

Line 14697: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;

14693: l_available_yn VARCHAR2 (2);
14694: l_index VARCHAR2 (2000);
14695: l_return_status VARCHAR2 (1) := 'S';
14696: --l_kdtl_tbl oks_extwar_util_pvt.contract_tbl_type;
14697: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
14698: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
14699: l_ctr NUMBER := 0;
14700: l_cov_att VARCHAR2 (1);
14701: v_temp VARCHAR2 (1);

Line 14698: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;

14694: l_index VARCHAR2 (2000);
14695: l_return_status VARCHAR2 (1) := 'S';
14696: --l_kdtl_tbl oks_extwar_util_pvt.contract_tbl_type;
14697: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
14698: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
14699: l_ctr NUMBER := 0;
14700: l_cov_att VARCHAR2 (1);
14701: v_temp VARCHAR2 (1);
14702: l_sub_sdt DATE := NULL;

Line 15529: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;

15525: --Contract Line Table
15526: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
15527: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
15528: --SalesCredit
15529: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
15530: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
15531: l_line_rec k_line_service_rec_type;
15532: l_covd_rec k_line_covered_level_rec_type;
15533: -- l_kdtl_tbl OKS_EXTWAR_UTIL_PVT.Contract_tbl_type;

Line 15530: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;

15526: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
15527: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
15528: --SalesCredit
15529: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
15530: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
15531: l_line_rec k_line_service_rec_type;
15532: l_covd_rec k_line_covered_level_rec_type;
15533: -- l_kdtl_tbl OKS_EXTWAR_UTIL_PVT.Contract_tbl_type;
15534: l_available_yn VARCHAR2 (1);

Line 15558: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;

15554: l_time VARCHAR2 (25);
15555: l_sll_tbl oks_bill_sch.streamlvl_tbl;
15556: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
15557: l_strmlvl_id NUMBER := NULL;
15558: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
15559: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
15560: l_ctr NUMBER;
15561: l_temp VARCHAR2 (2000);
15562: l_suppress_credit VARCHAR2 (10);

Line 15559: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;

15555: l_sll_tbl oks_bill_sch.streamlvl_tbl;
15556: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
15557: l_strmlvl_id NUMBER := NULL;
15558: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
15559: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
15560: l_ctr NUMBER;
15561: l_temp VARCHAR2 (2000);
15562: l_suppress_credit VARCHAR2 (10);
15563:

Line 16124: oks_extwarprgm_pvt.create_k_covered_levels

16120: p_kdtl_tbl (l_ctr).toplvl_uom_code;
16121: --mchoudha added for bug#5233956
16122: l_covd_rec.toplvl_price_qty :=
16123: p_kdtl_tbl (l_ctr).toplvl_price_qty;
16124: oks_extwarprgm_pvt.create_k_covered_levels
16125: (p_k_covd_rec => l_covd_rec,
16126: p_price_attribs => l_price_attribs_in,
16127: p_caller => 'IB',
16128: x_order_error => l_temp,

Line 16145: 'oks_extwarprgm_pvt.create_k_covered_levels(Retun status = '

16141: fnd_log.STRING
16142: (fnd_log.level_event,
16143: g_module_current
16144: || '.CREATE_CONTRACT_IBUPDATE',
16145: 'oks_extwarprgm_pvt.create_k_covered_levels(Retun status = '
16146: || l_return_status
16147: || ')'
16148: );
16149: END IF;

Line 17084: END oks_extwarprgm_pvt;

17080: 'Exiting Send_notification ' || l_return_status
17081: );
17082: END IF;
17083: END send_notification;
17084: END oks_extwarprgm_pvt;