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.90.12020000.7 2013/02/22 10:40:20 mchandak ship $ */
3:
4: TYPE p_srvline_rec IS RECORD (
5: k_line_id NUMBER

Line 3329: IF (Nvl(OKS_EXTWARPRGM_PVT.G_TRF_K_CREATE,'N') ='Y') AND (l_auth_org_id<>(nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99)))THEN

3325: OPEN get_k_auth_org(l_chrid);
3326: FETCH get_k_auth_org INTO l_auth_org_id;
3327: CLOSE get_k_auth_org;
3328:
3329: IF (Nvl(OKS_EXTWARPRGM_PVT.G_TRF_K_CREATE,'N') ='Y') AND (l_auth_org_id<>(nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99)))THEN
3330: l_okc_org_id := l_auth_org_id;
3331: ELSE
3332: l_okc_org_id := Okc_context.get_okc_org_id;
3333: END IF;

Line 4530: IF (Nvl(OKS_EXTWARPRGM_PVT.G_TRF_K_CREATE,'N') ='Y') AND (l_inv_org_id<>(nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99)))THEN

4526: OPEN get_k_inv_org(p_k_line_rec.k_id);
4527: FETCH get_k_inv_org INTO l_inv_org_id;
4528: CLOSE get_k_inv_org;
4529:
4530: IF (Nvl(OKS_EXTWARPRGM_PVT.G_TRF_K_CREATE,'N') ='Y') AND (l_inv_org_id<>(nvl(OKC_CONTEXT.GET_OKC_ORG_ID,-99)))THEN
4531: l_cimv_tbl_in( 1 ).object1_id2 := l_inv_org_id;
4532: ELSE
4533: l_cimv_tbl_in( 1 ).object1_id2 := okc_context.get_okc_organization_id;
4534: END IF;

Line 5843: p_contact_tbl_in IN oks_extwarprgm_pvt.contact_tbl,

5839: END create_k_covered_levels;
5840:
5841: PROCEDURE create_contract_ibnew (
5842: p_extwar_rec IN extwar_rec_type,
5843: p_contact_tbl_in IN oks_extwarprgm_pvt.contact_tbl,
5844: p_salescredit_tbl_hdr_in IN oks_extwarprgm_pvt.salescredit_tbl,
5845: --mmadhavi bug 4174921
5846: p_salescredit_tbl_line_in IN oks_extwarprgm_pvt.salescredit_tbl,
5847: p_price_attribs_in IN oks_extwarprgm_pvt.pricing_attributes_type,

Line 5844: p_salescredit_tbl_hdr_in IN oks_extwarprgm_pvt.salescredit_tbl,

5840:
5841: PROCEDURE create_contract_ibnew (
5842: p_extwar_rec IN extwar_rec_type,
5843: p_contact_tbl_in IN oks_extwarprgm_pvt.contact_tbl,
5844: p_salescredit_tbl_hdr_in IN oks_extwarprgm_pvt.salescredit_tbl,
5845: --mmadhavi bug 4174921
5846: p_salescredit_tbl_line_in IN oks_extwarprgm_pvt.salescredit_tbl,
5847: p_price_attribs_in IN oks_extwarprgm_pvt.pricing_attributes_type,
5848: x_inst_dtls_tbl IN OUT NOCOPY oks_ihd_pvt.ihdv_tbl_type,

Line 5846: p_salescredit_tbl_line_in IN oks_extwarprgm_pvt.salescredit_tbl,

5842: p_extwar_rec IN extwar_rec_type,
5843: p_contact_tbl_in IN oks_extwarprgm_pvt.contact_tbl,
5844: p_salescredit_tbl_hdr_in IN oks_extwarprgm_pvt.salescredit_tbl,
5845: --mmadhavi bug 4174921
5846: p_salescredit_tbl_line_in IN oks_extwarprgm_pvt.salescredit_tbl,
5847: p_price_attribs_in IN oks_extwarprgm_pvt.pricing_attributes_type,
5848: x_inst_dtls_tbl IN OUT NOCOPY oks_ihd_pvt.ihdv_tbl_type,
5849: x_chrid OUT NOCOPY NUMBER,
5850: x_return_status OUT NOCOPY VARCHAR2,

Line 5847: p_price_attribs_in IN oks_extwarprgm_pvt.pricing_attributes_type,

5843: p_contact_tbl_in IN oks_extwarprgm_pvt.contact_tbl,
5844: p_salescredit_tbl_hdr_in IN oks_extwarprgm_pvt.salescredit_tbl,
5845: --mmadhavi bug 4174921
5846: p_salescredit_tbl_line_in IN oks_extwarprgm_pvt.salescredit_tbl,
5847: p_price_attribs_in IN oks_extwarprgm_pvt.pricing_attributes_type,
5848: x_inst_dtls_tbl IN OUT NOCOPY oks_ihd_pvt.ihdv_tbl_type,
5849: x_chrid OUT NOCOPY NUMBER,
5850: x_return_status OUT NOCOPY VARCHAR2,
5851: x_msg_count OUT NOCOPY NUMBER,

Line 5886: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;

5882: l_hdrdates_rec l_hdrdates_csr%ROWTYPE;
5883: --l_ctr NUMBER := 0;
5884:
5885: --Contact
5886: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
5887: --SalesCredit
5888: l_salescredit_tbl oks_extwarprgm_pvt.salescredit_tbl;
5889: l_api_version CONSTANT NUMBER := 1.0;
5890: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;

Line 5888: l_salescredit_tbl oks_extwarprgm_pvt.salescredit_tbl;

5884:
5885: --Contact
5886: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
5887: --SalesCredit
5888: l_salescredit_tbl oks_extwarprgm_pvt.salescredit_tbl;
5889: l_api_version CONSTANT NUMBER := 1.0;
5890: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
5891: l_index VARCHAR2 (2000);
5892: l_rule_group_id NUMBER;

Line 5985: oks_extwarprgm_pvt.create_k_hdr

5981: get_sts_code ('ACTIVE', NULL, l_ste_code, l_sts_code);
5982: END IF;
5983:
5984: l_hdr_rec.sts_code := l_sts_code;
5985: oks_extwarprgm_pvt.create_k_hdr
5986: (p_k_header_rec => l_hdr_rec,
5987: p_contact_tbl => p_contact_tbl_in,
5988: p_salescredit_tbl_in => p_salescredit_tbl_hdr_in,
5989: --mmadhavi bug 4174921

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

6000: fnd_log.STRING
6001: (fnd_log.level_event,
6002: g_module_current
6003: || '.Create_contract_Ibnew.after_create.header',
6004: 'oks_extwarprgm_pvt.create_k_hdr(Return status = '
6005: || l_return_status
6006: || ')'
6007: );
6008: END IF;

Line 6090: oks_extwarprgm_pvt.create_k_service_lines

6086: get_sts_code ('ACTIVE', NULL, l_ste_code, l_sts_code);
6087: END IF;
6088:
6089: l_line_rec.line_sts_code := l_sts_code;
6090: oks_extwarprgm_pvt.create_k_service_lines
6091: (p_k_line_rec => l_line_rec,
6092: p_contact_tbl => p_contact_tbl_in,
6093: p_salescredit_tbl_in => p_salescredit_tbl_line_in,
6094: p_caller => 'IB',

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

6104: fnd_log.STRING
6105: (fnd_log.level_event,
6106: g_module_current
6107: || '.Create_contract_Ibnew.after_create.service_line',
6108: 'oks_extwarprgm_pvt.create_k_service_lines(Return status = '
6109: || l_return_status
6110: || ')'
6111: );
6112: END IF;

Line 6157: oks_extwarprgm_pvt.create_k_covered_levels

6153: get_sts_code ('ACTIVE', NULL, l_ste_code, l_sts_code);
6154: END IF;
6155:
6156: l_covd_rec.product_sts_code := l_sts_code;
6157: oks_extwarprgm_pvt.create_k_covered_levels
6158: (p_k_covd_rec => l_covd_rec,
6159: p_price_attribs => p_price_attribs_in,
6160: p_caller => 'IB',
6161: x_order_error => l_temp,

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

6171: fnd_log.STRING
6172: (fnd_log.level_event,
6173: g_module_current
6174: || '.Create_contract_Ibnew.after_create.covered_line',
6175: 'oks_extwarprgm_pvt.create_k_covered_levels(Return status = '
6176: || l_return_status
6177: || ')'
6178: );
6179: END IF;

Line 6937: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;

6933: --Contract Line Table
6934: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
6935: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
6936: --SalesCredit
6937: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
6938: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
6939: l_qty1price NUMBER := 0;
6940: l_oldamt NUMBER (30, 2) := 0;
6941: l_no_of_days NUMBER := 0;

Line 6938: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;

6934: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
6935: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
6936: --SalesCredit
6937: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
6938: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
6939: l_qty1price NUMBER := 0;
6940: l_oldamt NUMBER (30, 2) := 0;
6941: l_no_of_days NUMBER := 0;
6942: l_new_value NUMBER := 0;

Line 6949: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;

6945: l_diff NUMBER := 0;
6946: l_covlvl_id NUMBER;
6947: l_rule_group_id NUMBER;
6948: l_rule_id NUMBER;
6949: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
6950: l_bill_schd_yn VARCHAR2 (1);
6951: l_list_price NUMBER := 0;
6952: l_spldt DATE;
6953: l_billed_amount NUMBER := 0;

Line 7360: oks_extwarprgm_pvt.create_k_covered_levels

7356: THEN
7357: RAISE g_exception_halt_validation;
7358: END IF;
7359:
7360: oks_extwarprgm_pvt.create_k_covered_levels
7361: (p_k_covd_rec => l_covd_rec,
7362: p_price_attribs => l_price_attribs_in,
7363: p_caller => 'IB',
7364: x_order_error => l_temp,

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

7374: fnd_log.STRING
7375: (fnd_log.level_event,
7376: g_module_current
7377: || '.CREATE_CONTRACT_IBSPLIT.after_create.cov_lvl',
7378: 'oks_extwarprgm_pvt.create_k_covered_levels(Return status = '
7379: || l_return_status
7380: || ')'
7381: );
7382: END IF;

Line 7809: -- l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;

7805: l_insthist_rec oks_ins_pvt.insv_rec_type;
7806: x_insthist_rec oks_ins_pvt.insv_rec_type;
7807: l_parameters VARCHAR2 (2000);
7808: l_renewal_id NUMBER;
7809: -- l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
7810: -- l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
7811: -- l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
7812: l_line_rec k_line_service_rec_type;
7813: l_covd_rec k_line_covered_level_rec_type;

Line 7810: -- l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;

7806: x_insthist_rec oks_ins_pvt.insv_rec_type;
7807: l_parameters VARCHAR2 (2000);
7808: l_renewal_id NUMBER;
7809: -- l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
7810: -- l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
7811: -- l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
7812: l_line_rec k_line_service_rec_type;
7813: l_covd_rec k_line_covered_level_rec_type;
7814: l_available_yn CHAR;

Line 7811: -- l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;

7807: l_parameters VARCHAR2 (2000);
7808: l_renewal_id NUMBER;
7809: -- l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
7810: -- l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
7811: -- l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
7812: l_line_rec k_line_service_rec_type;
7813: l_covd_rec k_line_covered_level_rec_type;
7814: l_available_yn CHAR;
7815: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;

Line 7834: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;

7830: l_covlvl_id NUMBER;
7831: --Contract Line Table
7832: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
7833: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
7834: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
7835: l_cov_rec l_cov_csr%ROWTYPE;
7836: l_api_version CONSTANT NUMBER := 1.0;
7837: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
7838: l_list_price NUMBER;

Line 8375: oks_extwarprgm_pvt.create_k_covered_levels

8371: l_covd_rec.price_uom := p_kdtl_tbl (l_ctr).price_uom_code;
8372: l_covd_rec.toplvl_uom_code := p_kdtl_tbl (l_ctr).toplvl_uom_code;
8373: --mchoudha added for bug#5233956
8374: l_covd_rec.toplvl_price_qty := p_kdtl_tbl (l_ctr).toplvl_price_qty;
8375: oks_extwarprgm_pvt.create_k_covered_levels
8376: (p_k_covd_rec => l_covd_rec,
8377: p_price_attribs => l_price_attribs_in,
8378: p_caller => 'IB',
8379: x_order_error => l_temp,

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

8389: fnd_log.STRING
8390: (fnd_log.level_event,
8391: g_module_current
8392: || '.CREATE_CONTRACT_IBREPLACE.create_cov_lvl',
8393: 'oks_extwarprgm_pvt.create_k_covered_levels(Return status = '
8394: || l_return_status
8395: );
8396: END IF;
8397:

Line 8762: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;

8758: l_old_cp_id NUMBER;
8759: l_insthist_rec oks_ins_pvt.insv_rec_type;
8760: x_insthist_rec oks_ins_pvt.insv_rec_type;
8761: l_parameters VARCHAR2 (2000);
8762: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
8763: --SalesCredit
8764: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
8765: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
8766: l_line_rec k_line_service_rec_type;

Line 8764: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;

8760: x_insthist_rec oks_ins_pvt.insv_rec_type;
8761: l_parameters VARCHAR2 (2000);
8762: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
8763: --SalesCredit
8764: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
8765: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
8766: l_line_rec k_line_service_rec_type;
8767: l_covd_rec k_line_covered_level_rec_type;
8768: l_available_yn CHAR;

Line 8765: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;

8761: l_parameters VARCHAR2 (2000);
8762: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
8763: --SalesCredit
8764: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
8765: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
8766: l_line_rec k_line_service_rec_type;
8767: l_covd_rec k_line_covered_level_rec_type;
8768: l_available_yn CHAR;
8769: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;

Line 9592: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;

9588: l_ref_num VARCHAR2 (30);
9589: l_msg_count NUMBER;
9590: l_msg_data VARCHAR2 (2000);
9591: l_trf_option VARCHAR2 (40);
9592: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
9593: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
9594: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
9595: l_line_rec oks_extwarprgm_pvt.k_line_service_rec_type;
9596: l_covd_rec oks_extwarprgm_pvt.k_line_covered_level_rec_type;

Line 9593: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;

9589: l_msg_count NUMBER;
9590: l_msg_data VARCHAR2 (2000);
9591: l_trf_option VARCHAR2 (40);
9592: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
9593: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
9594: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
9595: l_line_rec oks_extwarprgm_pvt.k_line_service_rec_type;
9596: l_covd_rec oks_extwarprgm_pvt.k_line_covered_level_rec_type;
9597: --l_kdtl_tbl oks_extwar_util_pvt.contract_tbl_type;

Line 9594: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;

9590: l_msg_data VARCHAR2 (2000);
9591: l_trf_option VARCHAR2 (40);
9592: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
9593: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
9594: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
9595: l_line_rec oks_extwarprgm_pvt.k_line_service_rec_type;
9596: l_covd_rec oks_extwarprgm_pvt.k_line_covered_level_rec_type;
9597: --l_kdtl_tbl oks_extwar_util_pvt.contract_tbl_type;
9598: l_available_yn CHAR;

Line 9595: l_line_rec oks_extwarprgm_pvt.k_line_service_rec_type;

9591: l_trf_option VARCHAR2 (40);
9592: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
9593: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
9594: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
9595: l_line_rec oks_extwarprgm_pvt.k_line_service_rec_type;
9596: l_covd_rec oks_extwarprgm_pvt.k_line_covered_level_rec_type;
9597: --l_kdtl_tbl oks_extwar_util_pvt.contract_tbl_type;
9598: l_available_yn CHAR;
9599: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;

Line 9596: l_covd_rec oks_extwarprgm_pvt.k_line_covered_level_rec_type;

9592: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
9593: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
9594: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
9595: l_line_rec oks_extwarprgm_pvt.k_line_service_rec_type;
9596: l_covd_rec oks_extwarprgm_pvt.k_line_covered_level_rec_type;
9597: --l_kdtl_tbl oks_extwar_util_pvt.contract_tbl_type;
9598: l_available_yn CHAR;
9599: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;
9600: l_line_found VARCHAR2 (1);

Line 9838: p_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;

9834: l_party_id NUMBER;
9835: l_party_name VARCHAR2 (360);
9836: l_return_status VARCHAR2 (1);
9837: l_rnrl_rec_out oks_renew_util_pvt.rnrl_rec_type;
9838: p_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
9839: l_chrid NUMBER;
9840: l_cacv_tbl_in okc_contract_pub.cacv_tbl_type;
9841: l_cacv_tbl_out okc_contract_pub.cacv_tbl_type;
9842: l_status VARCHAR2 (40);

Line 9850: l_salescredit_tbl oks_extwarprgm_pvt.salescredit_tbl;

9846: l_resource_id NUMBER;
9847: l_group_id NUMBER;
9848: l_access_level VARCHAR2 (3);
9849: l_sc_hdr_ctr NUMBER;
9850: l_salescredit_tbl oks_extwarprgm_pvt.salescredit_tbl;
9851: l_org_id NUMBER;
9852:
9853: CURSOR l_sales_credit_hdr_csr (p_chr_id NUMBER)
9854: IS

Line 10150: OKS_EXTWARPRGM_PVT.G_TRF_K_CREATE := 'Y';

10146: l_hdr_rec.price_uom := p_kdtl_rec.price_uom_hdr;
10147: l_sc_hdr_ctr := 0;
10148:
10149: /*spingali bugfix for bug12747411 -start*/
10150: OKS_EXTWARPRGM_PVT.G_TRF_K_CREATE := 'Y';
10151: /*spingali bugfix for bug12747411 -end */
10152:
10153: FOR l_sales_credit_hdr_rec IN
10154: l_sales_credit_hdr_csr (p_kdtl_rec.hdr_id)

Line 10167: oks_extwarprgm_pvt.create_k_hdr

10163: l_salescredit_tbl (l_sc_hdr_ctr).sales_group_id :=
10164: l_sales_credit_hdr_rec.sales_group_id;
10165: END LOOP; -- For l_sales_credit_rec IN l_sales_credit_csr
10166:
10167: oks_extwarprgm_pvt.create_k_hdr
10168: (p_k_header_rec => l_hdr_rec,
10169: p_contact_tbl => p_contact_tbl_in,
10170: p_salescredit_tbl_in => l_salescredit_tbl
10171: -- mmadhavi bug 4174921

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

10183: fnd_log.STRING
10184: (fnd_log.level_statement,
10185: g_module_current
10186: || '.CREATE_K_SYSTEM_TRF.create_contract_header',
10187: 'OKS_EXTWARPRGM_PVT.create_k_hdr(Return status = '
10188: || l_return_status
10189: || ')'
10190: );
10191: END IF;

Line 10320: p_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;

10316: l_hdr_ste_code VARCHAR2 (40);
10317: l_lineid NUMBER;
10318: l_return_status VARCHAR2 (10);
10319: l_price_list_id NUMBER;
10320: p_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
10321: l_status VARCHAR2 (40);
10322: l_bill_to_id NUMBER;
10323: l_ship_to_id NUMBER;
10324: l_warranty_flag VARCHAR2 (2);

Line 10333: l_salescredit_tbl oks_extwarprgm_pvt.salescredit_tbl;

10329: FROM oks_k_sales_credits_v
10330: WHERE cle_id = p_cle_id;
10331:
10332: l_sc_ctr NUMBER;
10333: l_salescredit_tbl oks_extwarprgm_pvt.salescredit_tbl;
10334: BEGIN
10335: x_return_status := okc_api.g_ret_sts_success;
10336:
10337: OPEN l_line_rule_csr (p_kdtl_rec.service_line_id);

Line 10485: oks_extwarprgm_pvt.create_k_service_lines

10481: l_salescredit_tbl (l_sc_ctr).sales_group_id :=
10482: l_sales_credit_rec.sales_group_id;
10483: END LOOP; -- For l_sales_credit_rec IN l_sales_credit_csr
10484:
10485: oks_extwarprgm_pvt.create_k_service_lines
10486: (p_k_line_rec => l_line_rec,
10487: p_contact_tbl => p_contact_tbl_in,
10488: p_salescredit_tbl_in => l_salescredit_tbl,
10489: p_caller => 'ST',

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

10499: fnd_log.STRING
10500: (fnd_log.level_statement,
10501: g_module_current
10502: || '.CREATE_K_SYSTEM_TRF.create_k_service_line',
10503: 'oks_extwarprgm_pvt.create_k_service_lines(Return status = '
10504: || l_return_status
10505: || ')'
10506: );
10507: END IF;

Line 10591: p_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;

10587: l_return_status VARCHAR2 (10);
10588: l_days NUMBER;
10589: l_newamt NUMBER;
10590: l_day1price NUMBER;
10591: p_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
10592: l_warranty_flag VARCHAR2 (2);
10593: l_covlvl_id NUMBER;
10594: l_update_top_line VARCHAR2 (1);
10595: l_status VARCHAR2 (40);

Line 10794: oks_extwarprgm_pvt.create_k_covered_levels

10790: l_covd_rec.product_sts_code := l_sts_code;
10791: END IF;
10792: END IF;
10793:
10794: oks_extwarprgm_pvt.create_k_covered_levels
10795: (p_k_covd_rec => l_covd_rec,
10796: p_price_attribs => p_price_attribs_in,
10797: p_caller => 'ST',
10798: x_order_error => l_temp,

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

10968: X_RETURN_STATUS => l_return_status
10969: );
10970: If(G_FND_LOG_OPTION = 'Y') Then
10971: FND_FILE.PUT_LINE (FND_FILE.LOG,'IBNEW :- CREATE_BCL_FOR_OM ' || l_return_status );
10972: OKS_RENEW_PVT.DEBUG_LOG( 'OKS_EXTWARPRGM_PVT.CREATE_K_SYSTEM_TRF :: CREATE_BCL_FOR_OM '|| l_return_status);
10973: End if;
10974:
10975: If Not l_return_status = 'S' then
10976: Raise G_EXCEPTION_HALT_VALIDATION;

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

11040: X_RETURN_STATUS => l_return_status
11041: );
11042: -- FND_FILE.PUT_LINE (FND_FILE.LOG,'IBNEW :- CREATE_BCL_FOR_OM ' || l_return_status );
11043: If(G_FND_LOG_OPTION = 'Y') Then
11044: OKS_RENEW_PVT.DEBUG_LOG( 'OKS_EXTWARPRGM_PVT.CREATE_K_SYSTEM_TRF :: CREATE_BCL_FOR_OM '|| l_return_status);
11045: End if;
11046: If Not l_return_status = 'S' then
11047: Raise G_EXCEPTION_HALT_VALIDATION;
11048: End if;

Line 14209: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;

14205: --Contract Line Table
14206: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
14207: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
14208: --SalesCredit
14209: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
14210: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
14211: l_line_rec k_line_service_rec_type;
14212: l_covd_rec k_line_covered_level_rec_type;
14213: l_available_yn CHAR;

Line 14210: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;

14206: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
14207: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
14208: --SalesCredit
14209: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
14210: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
14211: l_line_rec k_line_service_rec_type;
14212: l_covd_rec k_line_covered_level_rec_type;
14213: l_available_yn CHAR;
14214: l_return_status VARCHAR2 (5) := okc_api.g_ret_sts_success;

Line 14982: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;

14978: l_available_yn VARCHAR2 (2);
14979: l_index VARCHAR2 (2000);
14980: l_return_status VARCHAR2 (1) := 'S';
14981: --l_kdtl_tbl oks_extwar_util_pvt.contract_tbl_type;
14982: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
14983: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
14984: l_ctr NUMBER := 0;
14985: l_cov_att VARCHAR2 (1);
14986: v_temp VARCHAR2 (1);

Line 14983: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;

14979: l_index VARCHAR2 (2000);
14980: l_return_status VARCHAR2 (1) := 'S';
14981: --l_kdtl_tbl oks_extwar_util_pvt.contract_tbl_type;
14982: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
14983: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
14984: l_ctr NUMBER := 0;
14985: l_cov_att VARCHAR2 (1);
14986: v_temp VARCHAR2 (1);
14987: l_sub_sdt DATE := NULL;

Line 15827: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;

15823: --Contract Line Table
15824: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
15825: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
15826: --SalesCredit
15827: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
15828: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
15829: l_line_rec k_line_service_rec_type;
15830: l_covd_rec k_line_covered_level_rec_type;
15831: -- l_kdtl_tbl OKS_EXTWAR_UTIL_PVT.Contract_tbl_type;

Line 15828: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;

15824: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
15825: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
15826: --SalesCredit
15827: l_salescredit_tbl_line oks_extwarprgm_pvt.salescredit_tbl;
15828: l_salescredit_tbl_hdr oks_extwarprgm_pvt.salescredit_tbl;
15829: l_line_rec k_line_service_rec_type;
15830: l_covd_rec k_line_covered_level_rec_type;
15831: -- l_kdtl_tbl OKS_EXTWAR_UTIL_PVT.Contract_tbl_type;
15832: l_available_yn VARCHAR2 (1);

Line 15856: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;

15852: l_time VARCHAR2 (25);
15853: l_sll_tbl oks_bill_sch.streamlvl_tbl;
15854: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
15855: l_strmlvl_id NUMBER := NULL;
15856: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
15857: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
15858: l_ctr NUMBER;
15859: l_temp VARCHAR2 (2000);
15860: l_suppress_credit VARCHAR2 (10);

Line 15857: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;

15853: l_sll_tbl oks_bill_sch.streamlvl_tbl;
15854: l_bil_sch_out oks_bill_sch.itembillsch_tbl;
15855: l_strmlvl_id NUMBER := NULL;
15856: l_contact_tbl_in oks_extwarprgm_pvt.contact_tbl;
15857: l_price_attribs_in oks_extwarprgm_pvt.pricing_attributes_type;
15858: l_ctr NUMBER;
15859: l_temp VARCHAR2 (2000);
15860: l_suppress_credit VARCHAR2 (10);
15861:

Line 16422: oks_extwarprgm_pvt.create_k_covered_levels

16418: p_kdtl_tbl (l_ctr).toplvl_uom_code;
16419: --mchoudha added for bug#5233956
16420: l_covd_rec.toplvl_price_qty :=
16421: p_kdtl_tbl (l_ctr).toplvl_price_qty;
16422: oks_extwarprgm_pvt.create_k_covered_levels
16423: (p_k_covd_rec => l_covd_rec,
16424: p_price_attribs => l_price_attribs_in,
16425: p_caller => 'IB',
16426: x_order_error => l_temp,

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

16439: fnd_log.STRING
16440: (fnd_log.level_event,
16441: g_module_current
16442: || '.CREATE_CONTRACT_IBUPDATE',
16443: 'oks_extwarprgm_pvt.create_k_covered_levels(Retun status = '
16444: || l_return_status
16445: || ')'
16446: );
16447: END IF;

Line 17382: END oks_extwarprgm_pvt;

17378: 'Exiting Send_notification ' || l_return_status
17379: );
17380: END IF;
17381: END send_notification;
17382: END oks_extwarprgm_pvt;