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 OKC_CONTRACT_PUB

Line 1626: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

1622: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
1623: l_return_status VARCHAR2 (1) := 'S';
1624: l_index VARCHAR2 (2000);
1625: --Contract Line
1626: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
1627: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
1628: l_cleid NUMBER;
1629: l_rgp_id NUMBER;
1630: l_rule_id NUMBER;

Line 1627: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

1623: l_return_status VARCHAR2 (1) := 'S';
1624: l_index VARCHAR2 (2000);
1625: --Contract Line
1626: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
1627: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
1628: l_cleid NUMBER;
1629: l_rgp_id NUMBER;
1630: l_rule_id NUMBER;
1631: l_invoice_rule_id NUMBER;

Line 1658: okc_contract_pub.update_contract_line

1654: --Contract Header Date Update
1655: l_clev_tbl_in (1).ID := p_cle_id;
1656: l_clev_tbl_in (1).start_date := p_new_sdt;
1657: l_clev_tbl_in (1).end_date := p_new_edt;
1658: okc_contract_pub.update_contract_line
1659: (p_api_version => l_api_version,
1660: p_init_msg_list => l_init_msg_list,
1661: p_restricted_update => okc_api.g_true,
1662: x_return_status => l_return_status,

Line 1674: 'okc_contract_pub.update_contract_line(Return status = '

1670: THEN
1671: fnd_log.STRING
1672: (fnd_log.level_event,
1673: g_module_current || '.Update_Line_Dates.external_call.after',
1674: 'okc_contract_pub.update_contract_line(Return status = '
1675: || l_return_status
1676: || ')'
1677: );
1678: END IF;

Line 1888: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

1884: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
1885: l_return_status VARCHAR2 (1) := 'S';
1886: l_index VARCHAR2 (2000);
1887: --Contract Header
1888: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
1889: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
1890: --Rule Related
1891: --l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
1892: --l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;

Line 1889: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

1885: l_return_status VARCHAR2 (1) := 'S';
1886: l_index VARCHAR2 (2000);
1887: --Contract Header
1888: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
1889: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
1890: --Rule Related
1891: --l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
1892: --l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
1893: --Time Value Related

Line 1926: okc_contract_pub.update_contract_header

1922: --Contract Header Date Update
1923: l_chrv_tbl_in (1).ID := p_chr_id;
1924: l_chrv_tbl_in (1).start_date := p_new_sdt;
1925: l_chrv_tbl_in (1).end_date := p_new_edt;
1926: okc_contract_pub.update_contract_header
1927: (p_api_version => l_api_version,
1928: p_init_msg_list => l_init_msg_list,
1929: p_restricted_update => okc_api.g_true,
1930: x_return_status => l_return_status,

Line 1942: 'okc_contract_pub.update_contract_header(Return status = '

1938: THEN
1939: fnd_log.STRING
1940: (fnd_log.level_event,
1941: g_module_current || '.Update_Hdr_Dates.external_call.after',
1942: 'okc_contract_pub.update_contract_header(Return status = '
1943: || l_return_status
1944: || ')'
1945: );
1946: END IF;

Line 2057: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

2053: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
2054: l_return_status VARCHAR2 (1) := 'S';
2055: l_index VARCHAR2 (2000);
2056: --Contract Line Table
2057: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
2058: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
2059: --Contract Item
2060: l_cimv_tbl_in okc_contract_item_pub.cimv_tbl_type;
2061: l_cimv_tbl_out okc_contract_item_pub.cimv_tbl_type;

Line 2058: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

2054: l_return_status VARCHAR2 (1) := 'S';
2055: l_index VARCHAR2 (2000);
2056: --Contract Line Table
2057: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
2058: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
2059: --Contract Item
2060: l_cimv_tbl_in okc_contract_item_pub.cimv_tbl_type;
2061: l_cimv_tbl_out okc_contract_item_pub.cimv_tbl_type;
2062: l_parent_line_id NUMBER;

Line 2071: okc_contract_pub.update_contract_line

2067: THEN
2068: x_return_status := okc_api.g_ret_sts_success;
2069: l_clev_tbl_in (1).ID := p_covered_line_id;
2070: l_clev_tbl_in (1).end_date := p_new_end_date;
2071: okc_contract_pub.update_contract_line
2072: (p_api_version => l_api_version,
2073: p_init_msg_list => l_init_msg_list,
2074: p_restricted_update => okc_api.g_true,
2075: x_return_status => l_return_status,

Line 2088: 'okc_contract_pub.update_contract_line(Return status = '

2084: fnd_log.STRING
2085: (fnd_log.level_event,
2086: g_module_current
2087: || '.update_contract_line.external_call.after',
2088: 'okc_contract_pub.update_contract_line(Return status = '
2089: || l_return_status
2090: || ')'
2091: );
2092: END IF;

Line 2111: okc_contract_pub.update_contract_line

2107: x_return_status := okc_api.g_ret_sts_success;
2108: l_clev_tbl_in (1).ID := p_covered_line_id;
2109: l_clev_tbl_in (1).price_negotiated := p_new_negotiated_amt;
2110: l_clev_tbl_in (1).price_unit := p_list_price;
2111: okc_contract_pub.update_contract_line
2112: (p_api_version => l_api_version,
2113: p_init_msg_list => l_init_msg_list,
2114: p_restricted_update => okc_api.g_true,
2115: x_return_status => l_return_status,

Line 2127: 'okc_contract_pub.update_contract_line(Return status = '

2123: THEN
2124: fnd_log.STRING
2125: (fnd_log.level_event,
2126: g_module_current || '.Update_Cov_level.external_call.after',
2127: 'okc_contract_pub.update_contract_line(Return status = '
2128: || l_return_status
2129: || ')'
2130: );
2131: END IF;

Line 2360: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

2356: l_return_status VARCHAR2 (1) := 'S';
2357: l_index VARCHAR2 (2000);
2358: i NUMBER;
2359: --Contract Header
2360: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
2361: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
2362: l_khrv_tbl_in oks_khr_pvt.khrv_tbl_type;
2363: l_khrv_tbl_out oks_khr_pvt.khrv_tbl_type;
2364: --SalesCredit

Line 2361: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

2357: l_index VARCHAR2 (2000);
2358: i NUMBER;
2359: --Contract Header
2360: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
2361: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
2362: l_khrv_tbl_in oks_khr_pvt.khrv_tbl_type;
2363: l_khrv_tbl_out oks_khr_pvt.khrv_tbl_type;
2364: --SalesCredit
2365: l_scrv_tbl_in oks_sales_credit_pub.scrv_tbl_type;

Line 2374: l_gvev_tbl_in okc_contract_pub.gvev_tbl_type;

2370: --Contacts
2371: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
2372: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
2373: --Agreements/Governance
2374: l_gvev_tbl_in okc_contract_pub.gvev_tbl_type;
2375: l_gvev_tbl_out okc_contract_pub.gvev_tbl_type;
2376: --Time Value Related
2377: l_isev_ext_tbl_in okc_time_pub.isev_ext_tbl_type;
2378: l_isev_ext_tbl_out okc_time_pub.isev_ext_tbl_type;

Line 2375: l_gvev_tbl_out okc_contract_pub.gvev_tbl_type;

2371: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
2372: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
2373: --Agreements/Governance
2374: l_gvev_tbl_in okc_contract_pub.gvev_tbl_type;
2375: l_gvev_tbl_out okc_contract_pub.gvev_tbl_type;
2376: --Time Value Related
2377: l_isev_ext_tbl_in okc_time_pub.isev_ext_tbl_type;
2378: l_isev_ext_tbl_out okc_time_pub.isev_ext_tbl_type;
2379: --Approval WorkFlow

Line 2380: l_cpsv_tbl_in okc_contract_pub.cpsv_tbl_type;

2376: --Time Value Related
2377: l_isev_ext_tbl_in okc_time_pub.isev_ext_tbl_type;
2378: l_isev_ext_tbl_out okc_time_pub.isev_ext_tbl_type;
2379: --Approval WorkFlow
2380: l_cpsv_tbl_in okc_contract_pub.cpsv_tbl_type;
2381: l_cpsv_tbl_out okc_contract_pub.cpsv_tbl_type;
2382: --REL OBJS
2383: l_crjv_tbl_out okc_k_rel_objs_pub.crjv_tbl_type;
2384: --Return IDs

Line 2381: l_cpsv_tbl_out okc_contract_pub.cpsv_tbl_type;

2377: l_isev_ext_tbl_in okc_time_pub.isev_ext_tbl_type;
2378: l_isev_ext_tbl_out okc_time_pub.isev_ext_tbl_type;
2379: --Approval WorkFlow
2380: l_cpsv_tbl_in okc_contract_pub.cpsv_tbl_type;
2381: l_cpsv_tbl_out okc_contract_pub.cpsv_tbl_type;
2382: --REL OBJS
2383: l_crjv_tbl_out okc_k_rel_objs_pub.crjv_tbl_type;
2384: --Return IDs
2385: l_chrid NUMBER;

Line 2608: okc_contract_pub.create_contract_header

2604: THEN
2605: l_chrv_tbl_in (1).attribute1 := p_k_header_rec.merge_object_id;
2606: END IF;
2607:
2608: okc_contract_pub.create_contract_header
2609: (p_api_version => l_api_version,
2610: p_init_msg_list => l_init_msg_list,
2611: x_return_status => l_return_status,
2612: x_msg_count => x_msg_count,

Line 2623: 'okc_contract_pub.create_contract_header(Return Status = '

2619: THEN
2620: fnd_log.STRING
2621: (fnd_log.level_event,
2622: g_module_current || '.Create_K_Hdr.external_call.after',
2623: 'okc_contract_pub.create_contract_header(Return Status = '
2624: || l_return_status
2625: || ')'
2626: );
2627: END IF;

Line 2653: '(okc_contract_pub).create_contract_header '

2649: fnd_message.set_encoded (l_msg_data);
2650: l_msg_data := fnd_message.get;
2651: fnd_file.put_line
2652: (fnd_file.LOG,
2653: '(okc_contract_pub).create_contract_header '
2654: || l_msg_data
2655: );
2656: END IF;
2657: END LOOP;

Line 3600: okc_contract_pub.create_contract_process

3596: l_cpsv_tbl_in (1).creation_date := okc_api.g_miss_date;
3597: l_cpsv_tbl_in (1).last_updated_by := okc_api.g_miss_num;
3598: l_cpsv_tbl_in (1).last_update_date := okc_api.g_miss_date;
3599: l_cpsv_tbl_in (1).last_update_login := okc_api.g_miss_num;
3600: okc_contract_pub.create_contract_process
3601: (p_api_version => l_api_version,
3602: p_init_msg_list => l_init_msg_list,
3603: x_return_status => l_return_status,
3604: x_msg_count => x_msg_count,

Line 3615: 'okc_contract_pub.create_contract_process(Return status = '

3611: THEN
3612: fnd_log.STRING
3613: (fnd_log.level_event,
3614: g_module_current || '.Create_K_Hdr.external_call.after',
3615: 'okc_contract_pub.create_contract_process(Return status = '
3616: || l_return_status
3617: || ')'
3618: );
3619: END IF;

Line 3641: okc_contract_pub.create_governance

3637: l_gvev_tbl_in (1).chr_id := l_chrid;
3638: l_gvev_tbl_in (1).isa_agreement_id := p_k_header_rec.agreement_id;
3639: l_gvev_tbl_in (1).copied_only_yn := 'Y';
3640: l_gvev_tbl_in (1).dnz_chr_id := l_chrid;
3641: okc_contract_pub.create_governance
3642: (p_api_version => l_api_version,
3643: p_init_msg_list => l_init_msg_list,
3644: x_return_status => l_return_status,
3645: x_msg_count => x_msg_count,

Line 3656: 'okc_contract_pub.create_governance(Return status = '

3652: THEN
3653: fnd_log.STRING
3654: (fnd_log.level_event,
3655: g_module_current || '.Create_K_Hdr.external_call.after',
3656: 'okc_contract_pub.create_governance(Return status = '
3657: || l_return_status
3658: || ')'
3659: );
3660: END IF;

Line 3839: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

3835: l_sales_group_id NUMBER;
3836: l_ctr_grpid VARCHAR2 (40);
3837: l_ste_code VARCHAR2 (30);
3838: --Contract Line Table
3839: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
3840: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
3841: l_klnv_tbl_in oks_kln_pvt.klnv_tbl_type;
3842: l_klnv_tbl_out oks_kln_pvt.klnv_tbl_type;
3843: --Contract Item

Line 3840: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

3836: l_ctr_grpid VARCHAR2 (40);
3837: l_ste_code VARCHAR2 (30);
3838: --Contract Line Table
3839: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
3840: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
3841: l_klnv_tbl_in oks_kln_pvt.klnv_tbl_type;
3842: l_klnv_tbl_out oks_kln_pvt.klnv_tbl_type;
3843: --Contract Item
3844: l_cimv_tbl_in okc_contract_item_pub.cimv_tbl_type;

Line 4129: okc_contract_pub.create_contract_line

4125: l_clev_tbl_in (1).bill_to_site_use_id := p_k_line_rec.bill_to_id; --BTO
4126: l_clev_tbl_in (1).ship_to_site_use_id := p_k_line_rec.ship_to_id; --STO
4127: l_clev_tbl_in (1).price_list_id := p_k_line_rec.ln_price_list_id;
4128: -- price list
4129: okc_contract_pub.create_contract_line
4130: (p_api_version => l_api_version,
4131: p_init_msg_list => l_init_msg_list,
4132: p_restricted_update => okc_api.g_true,
4133: x_return_status => l_return_status,

Line 4146: 'okc_contract_pub.create_contract_line(Return status = '

4142: fnd_log.STRING
4143: (fnd_log.level_event,
4144: g_module_current
4145: || '.Create_K_Service_Lines.External_call.after',
4146: 'okc_contract_pub.create_contract_line(Return status = '
4147: || l_return_status
4148: );
4149: END IF;
4150:

Line 4175: '(okc_contract_pub).create_contract_line '

4171: fnd_message.set_encoded (l_msg_data);
4172: l_msg_data := fnd_message.get;
4173: fnd_file.put_line
4174: (fnd_file.LOG,
4175: '(okc_contract_pub).create_contract_line '
4176: || l_msg_data
4177: );
4178: END IF;
4179: END LOOP;

Line 4804: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

4800: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
4801: l_return_status VARCHAR2 (1) := 'S';
4802: l_index VARCHAR2 (2000);
4803: --Contract Line Table
4804: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
4805: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
4806: l_klnv_tbl_in oks_kln_pvt.klnv_tbl_type;
4807: l_klnv_tbl_out oks_kln_pvt.klnv_tbl_type;
4808: --Contract Item

Line 4805: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

4801: l_return_status VARCHAR2 (1) := 'S';
4802: l_index VARCHAR2 (2000);
4803: --Contract Line Table
4804: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
4805: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
4806: l_klnv_tbl_in oks_kln_pvt.klnv_tbl_type;
4807: l_klnv_tbl_out oks_kln_pvt.klnv_tbl_type;
4808: --Contract Item
4809: l_cimv_tbl okc_contract_item_pub.cimv_tbl_type;

Line 5133: okc_contract_pub.create_contract_line

5129: -- rules inserted by okc
5130: l_clev_tbl_in (1).line_renewal_type_code :=
5131: NVL (p_k_covd_rec.line_renewal_type, 'FUL');
5132: --LRT
5133: okc_contract_pub.create_contract_line
5134: (p_api_version => l_api_version,
5135: p_init_msg_list => l_init_msg_list,
5136: p_restricted_update => okc_api.g_true,
5137: x_return_status => l_return_status,

Line 5150: 'okc_contract_pub.create_contract_line(Return status = '

5146: fnd_log.STRING
5147: (fnd_log.level_event,
5148: g_module_current
5149: || '.Create_K_Covered_Levels.after_create.top_line',
5150: 'okc_contract_pub.create_contract_line(Return status = '
5151: || l_return_status
5152: || ')'
5153: );
5154: END IF;

Line 5180: '(OKC_CONTRACT_PUB).CREATE_CONTRACT_LINE '

5176: fnd_message.set_encoded (l_msg_data);
5177: l_msg_data := fnd_message.get;
5178: fnd_file.put_line
5179: (fnd_file.LOG,
5180: '(OKC_CONTRACT_PUB).CREATE_CONTRACT_LINE '
5181: || l_msg_data
5182: );
5183: END IF;
5184: END LOOP;

Line 6753: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

6749: l_init_msg_list CONSTANT VARCHAR2 (1) := 'F';
6750: l_terminate_rec okc_terminate_pvt.terminate_in_cle_rec;
6751: l_srvc_stdt DATE;
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;

Line 6754: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

6750: l_terminate_rec okc_terminate_pvt.terminate_in_cle_rec;
6751: l_srvc_stdt DATE;
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;

Line 7638: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

7634: l_duration NUMBER;
7635: l_timeunits VARCHAR2 (240);
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;

Line 7639: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

7635: l_timeunits VARCHAR2 (240);
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;

Line 7886: okc_contract_pub.update_contract_line

7882:
7883: get_sts_code ('TERMINATED', NULL, l_ste_code, l_sts_code);
7884: l_clev_tbl_in (1).sts_code := l_sts_code;
7885:
7886: okc_contract_pub.update_contract_line
7887: (p_api_version => l_api_version,
7888: p_init_msg_list => l_init_msg_list,
7889: p_restricted_update => okc_api.g_true,
7890: x_return_status => l_return_status,

Line 7903: 'okc_contract_pub.update_contract_line(Return status = '

7899: fnd_log.STRING
7900: (fnd_log.level_event,
7901: g_module_current
7902: || '.CREATE_CONTRACT_IBREPLACE.update_cov_lvl',
7903: 'okc_contract_pub.update_contract_line(Return status = '
7904: || l_return_status
7905: || 'count = '
7906: || p_kdtl_tbl.COUNT
7907: || ')'

Line 7994: 'okc_contract_pub.update_contract_line(Return status ='

7990: THEN
7991: fnd_log.STRING
7992: (fnd_log.level_event,
7993: g_module_current || '.CREATE_CONTRACT_IBTERMINATE',
7994: 'okc_contract_pub.update_contract_line(Return status ='
7995: || l_return_status
7996: || ')'
7997: );
7998: END IF;

Line 8547: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

8543: l_oldamt NUMBER := 0;
8544: l_ctr NUMBER := 0;
8545: l_terminate_rec okc_terminate_pvt.terminate_in_cle_rec;
8546: --Contract Line Table
8547: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
8548: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
8549: l_api_version CONSTANT NUMBER := 1.0;
8550: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
8551: l_retdt DATE;

Line 8548: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

8544: l_ctr NUMBER := 0;
8545: l_terminate_rec okc_terminate_pvt.terminate_in_cle_rec;
8546: --Contract Line Table
8547: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
8548: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
8549: l_api_version CONSTANT NUMBER := 1.0;
8550: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
8551: l_retdt DATE;
8552: l_ste_code VARCHAR2 (30);

Line 8555: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

8551: l_retdt DATE;
8552: l_ste_code VARCHAR2 (30);
8553: l_sts_code VARCHAR2 (30);
8554: l_suppress_credit VARCHAR2 (2) := 'N';
8555: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
8556: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
8557: l_full_credit VARCHAR2 (2) := 'N';
8558: l_rnrl_rec_out oks_renew_util_pvt.rnrl_rec_type;
8559: l_service_name VARCHAR2 (2000);

Line 8556: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

8552: l_ste_code VARCHAR2 (30);
8553: l_sts_code VARCHAR2 (30);
8554: l_suppress_credit VARCHAR2 (2) := 'N';
8555: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
8556: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
8557: l_full_credit VARCHAR2 (2) := 'N';
8558: l_rnrl_rec_out oks_renew_util_pvt.rnrl_rec_type;
8559: l_service_name VARCHAR2 (2000);
8560: date_terminated DATE;

Line 8786: okc_contract_pub.update_contract_line

8782: If TRUNC (date_terminated)<= trunc(sysdate) Then
8783: l_clev_tbl_in (1).sts_code := l_sts_code;
8784: End If;
8785:
8786: okc_contract_pub.update_contract_line
8787: (p_api_version => l_api_version,
8788: p_init_msg_list => l_init_msg_list,
8789: p_restricted_update => okc_api.g_true,
8790: x_return_status => l_return_status,

Line 8826: okc_contract_pub.update_contract_header

8822: l_chrv_tbl_in (1).sts_code := l_sts_code;
8823: End If;
8824:
8825:
8826: okc_contract_pub.update_contract_header
8827: (p_api_version => l_api_version,
8828: p_init_msg_list => l_init_msg_list,
8829: p_restricted_update => okc_api.g_true,
8830: x_return_status => l_return_status,

Line 8844: 'okc_contract_pub.update_contract_header(Return status =

8840: fnd_log.STRING
8841: (fnd_log.level_event,
8842: g_module_current
8843: || '.CREATE_CONTRACT_IBRETURN.external_call.after',
8844: 'okc_contract_pub.update_contract_header(Return status =
8845: '
8846: || l_return_status
8847: || ')'
8848: );

Line 9362: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

9358: l_sts_code VARCHAR2 (40);
9359: l_ctr NUMBER;
9360: l_suppress_credit VARCHAR2 (10) := 'N';
9361: l_trfdt DATE;
9362: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
9363: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
9364: l_api_version CONSTANT NUMBER := 1.0;
9365: l_init_msg_list CONSTANT VARCHAR2 (1) := 'F';
9366: l_index NUMBER;

Line 9363: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

9359: l_ctr NUMBER;
9360: l_suppress_credit VARCHAR2 (10) := 'N';
9361: l_trfdt DATE;
9362: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
9363: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
9364: l_api_version CONSTANT NUMBER := 1.0;
9365: l_init_msg_list CONSTANT VARCHAR2 (1) := 'F';
9366: l_index NUMBER;
9367: l_relationship VARCHAR2 (40);

Line 9398: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

9394: l_new_party_name VARCHAR2 (360);
9395: l_old_party_name VARCHAR2 (360);
9396: date_terminated DATE;
9397: date_cancelled DATE;
9398: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
9399: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
9400: l_create_contract VARCHAR2 (1);
9401: l_party_id NUMBER;
9402: l_party_name VARCHAR2 (360);

Line 9399: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

9395: l_old_party_name VARCHAR2 (360);
9396: date_terminated DATE;
9397: date_cancelled DATE;
9398: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
9399: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
9400: l_create_contract VARCHAR2 (1);
9401: l_party_id NUMBER;
9402: l_party_name VARCHAR2 (360);
9403: l_opr_instance_id NUMBER;

Line 9596: l_cacv_tbl_in okc_contract_pub.cacv_tbl_type;

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);
9599: l_bill_to_id NUMBER;
9600: l_ship_to_id NUMBER;

Line 9597: l_cacv_tbl_out okc_contract_pub.cacv_tbl_type;

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);
9599: l_bill_to_id NUMBER;
9600: l_ship_to_id NUMBER;
9601: l_valid VARCHAR2 (1);

Line 9970: okc_contract_pub.create_contract_access

9966: l_cacv_tbl_in (1).chr_id := l_chrid;
9967: l_cacv_tbl_in (1).resource_id := l_resource_id;
9968: l_cacv_tbl_in (1).GROUP_ID := l_group_id;
9969: l_cacv_tbl_in (1).access_level := l_access_level;
9970: okc_contract_pub.create_contract_access
9971: (p_api_version => l_api_version,
9972: p_init_msg_list => l_init_msg_list,
9973: x_return_status => l_return_status,
9974: x_msg_count => x_msg_count,

Line 9986: 'okc_contract_pub.create_contract_access(Return status = '

9982: fnd_log.STRING
9983: (fnd_log.level_statement,
9984: g_module_current
9985: || '.CREATE_K_SYSTEM_TRF.create_contract_header',
9986: 'okc_contract_pub.create_contract_access(Return status = '
9987: || l_return_status
9988: || ')'
9989: );
9990: END IF;

Line 11146: okc_contract_pub.update_contract_line

11142: If TRUNC (date_terminated)<= trunc(sysdate) Then
11143: l_clev_tbl_in (1).sts_code := l_sts_code;
11144: End If;
11145:
11146: okc_contract_pub.update_contract_line
11147: (p_api_version => l_api_version,
11148: p_init_msg_list => l_init_msg_list,
11149: p_restricted_update => okc_api.g_true,
11150: x_return_status => l_return_status,

Line 11164: 'okc_contract_pub.update_contract_line(Return status = '

11160: THEN
11161: fnd_log.STRING
11162: (fnd_log.level_event,
11163: g_module_current || '.CREATE_K_SYSTEM_TRF',
11164: 'okc_contract_pub.update_contract_line(Return status = '
11165: || l_return_status
11166: || ')'
11167: );
11168: END IF;

Line 11196: okc_contract_pub.update_contract_header

11192: If TRUNC (date_terminated)<= trunc(sysdate) Then
11193: l_chrv_tbl_in (1).sts_code := l_sts_code;
11194: End If;
11195:
11196: okc_contract_pub.update_contract_header
11197: (p_api_version => l_api_version,
11198: p_init_msg_list => l_init_msg_list,
11199: p_restricted_update => okc_api.g_true,
11200: x_return_status => l_return_status,

Line 11215: 'okc_contract_pub.update_contract_header(Return status = '

11211: fnd_log.STRING
11212: (fnd_log.level_event,
11213: g_module_current
11214: || '.Update_Hdr_Dates.external_call.after',
11215: 'okc_contract_pub.update_contract_header(Return status = '
11216: || l_return_status
11217: || ')'
11218: );
11219: END IF;

Line 11273: 'okc_contract_pub.update_contract_line(Return status ='

11269: THEN
11270: fnd_log.STRING
11271: (fnd_log.level_event,
11272: g_module_current || '.CREATE_K_SYSTEM_TRF',
11273: 'okc_contract_pub.update_contract_line(Return status ='
11274: || l_return_status
11275: || ')'
11276: );
11277: END IF;

Line 11326: 'okc_contract_pub.update_contract_line(Return status = '

11322: THEN
11323: fnd_log.STRING
11324: (fnd_log.level_event,
11325: g_module_current || '.CREATE_K_SYSTEM_TRF',
11326: 'okc_contract_pub.update_contract_line(Return status = '
11327: || l_return_status
11328: || ')'
11329: );
11330: END IF;

Line 11656: okc_contract_pub.update_contract_line

11652: If TRUNC (date_terminated)<= trunc(sysdate) Then
11653: l_clev_tbl_in (1).sts_code := l_sts_code;
11654: End If;
11655:
11656: okc_contract_pub.update_contract_line
11657: (p_api_version => l_api_version,
11658: p_init_msg_list => l_init_msg_list,
11659: p_restricted_update => okc_api.g_true,
11660: x_return_status => l_return_status,

Line 11674: 'okc_contract_pub.update_contract_line(Return status = '

11670: THEN
11671: fnd_log.STRING
11672: (fnd_log.level_event,
11673: g_module_current || '.CREATE_K_SYSTEM_TRF',
11674: 'okc_contract_pub.update_contract_line(Return status = '
11675: || l_return_status
11676: || ')'
11677: );
11678: END IF;

Line 11706: okc_contract_pub.update_contract_header

11702: If TRUNC (date_terminated)<= trunc(sysdate) Then
11703: l_chrv_tbl_in (1).sts_code := l_sts_code;
11704: End If;
11705:
11706: okc_contract_pub.update_contract_header
11707: (p_api_version => l_api_version,
11708: p_init_msg_list => l_init_msg_list,
11709: p_restricted_update => okc_api.g_true,
11710: x_return_status => l_return_status,

Line 11725: 'okc_contract_pub.update_contract_header(Return status = '

11721: fnd_log.STRING
11722: (fnd_log.level_event,
11723: g_module_current
11724: || '.Update_Hdr_Dates.external_call.after',
11725: 'okc_contract_pub.update_contract_header(Return status = '
11726: || l_return_status
11727: || ')'
11728: );
11729: END IF;

Line 11828: 'okc_contract_pub.update_contract_line(Return status = '

11824: THEN
11825: fnd_log.STRING
11826: (fnd_log.level_event,
11827: g_module_current || '.CREATE_K_SYSTEM_TRF',
11828: 'okc_contract_pub.update_contract_line(Return status = '
11829: || l_return_status
11830: || ')'
11831: );
11832: END IF;

Line 13921: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

13917: x_insthist_rec oks_ins_pvt.insv_rec_type;
13918: l_parameters VARCHAR2 (2000);
13919: l_service_name VARCHAR2 (2000);
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;

Line 13922: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

13918: l_parameters VARCHAR2 (2000);
13919: l_service_name VARCHAR2 (2000);
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;

Line 13949: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

13945: date_terminated DATE;
13946: date_cancelled DATE;
13947: l_alllines_terminated VARCHAR2 (1);
13948: l_alllines_cancelled VARCHAR2 (1);
13949: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
13950: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
13951: l_ptr NUMBER;
13952: l_term_date_flag VARCHAR2 (1);
13953: l_credit_amount VARCHAR2 (50);

Line 13950: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

13946: date_cancelled DATE;
13947: l_alllines_terminated VARCHAR2 (1);
13948: l_alllines_cancelled VARCHAR2 (1);
13949: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
13950: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
13951: l_ptr NUMBER;
13952: l_term_date_flag VARCHAR2 (1);
13953: l_credit_amount VARCHAR2 (50);
13954: BEGIN

Line 14146: okc_contract_pub.update_contract_line

14142: If TRUNC (date_terminated)<= trunc(sysdate) Then
14143: l_clev_tbl_in (1).sts_code := l_sts_code;
14144: End If;
14145:
14146: okc_contract_pub.update_contract_line
14147: (p_api_version => l_api_version,
14148: p_init_msg_list => l_init_msg_list,
14149: p_restricted_update => okc_api.g_true,
14150: x_return_status => l_return_status,

Line 14196: okc_contract_pub.update_contract_header

14192: If TRUNC (date_terminated)<= trunc(sysdate) Then
14193: l_chrv_tbl_in (1).sts_code := l_sts_code;
14194: End If;
14195:
14196: okc_contract_pub.update_contract_header
14197: (p_api_version => l_api_version,
14198: p_init_msg_list => l_init_msg_list,
14199: p_restricted_update => okc_api.g_true,
14200: x_return_status => l_return_status,

Line 14214: 'okc_contract_pub.update_contract_header(Return status = '

14210: fnd_log.STRING
14211: (fnd_log.level_event,
14212: g_module_current
14213: || '.Update_Hdr_Dates.external_call.after',
14214: 'okc_contract_pub.update_contract_header(Return status = '
14215: || l_return_status
14216: || ')'
14217: );
14218: END IF;

Line 14260: 'okc_contract_pub.update_contract_line(Return status ='

14256: THEN
14257: fnd_log.STRING
14258: (fnd_log.level_event,
14259: g_module_current || '.CREATE_CONTRACT_IBTERMINATE',
14260: 'okc_contract_pub.update_contract_line(Return status ='
14261: || l_return_status
14262: || ')'
14263: );
14264: END IF;

Line 14310: 'okc_contract_pub.update_contract_line(Return status = '

14306: THEN
14307: fnd_log.STRING
14308: (fnd_log.level_event,
14309: g_module_current || '.CREATE_CONTRACT_IBTERMINATE',
14310: 'okc_contract_pub.update_contract_line(Return status = '
14311: || l_return_status
14312: || ')'
14313: );
14314: END IF;

Line 15526: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

15522: l_ref_num VARCHAR2 (30);
15523: l_parameters VARCHAR2 (2000);
15524: l_renewal_id NUMBER;
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;

Line 15527: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

15523: l_parameters VARCHAR2 (2000);
15524: l_renewal_id NUMBER;
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;