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 1666: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

1662: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
1663: l_return_status VARCHAR2 (1) := 'S';
1664: l_index VARCHAR2 (2000);
1665: --Contract Line
1666: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
1667: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
1668: l_cleid NUMBER;
1669: l_rgp_id NUMBER;
1670: l_rule_id NUMBER;

Line 1667: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

1663: l_return_status VARCHAR2 (1) := 'S';
1664: l_index VARCHAR2 (2000);
1665: --Contract Line
1666: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
1667: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
1668: l_cleid NUMBER;
1669: l_rgp_id NUMBER;
1670: l_rule_id NUMBER;
1671: l_invoice_rule_id NUMBER;

Line 1698: okc_contract_pub.update_contract_line

1694: --Contract Header Date Update
1695: l_clev_tbl_in (1).ID := p_cle_id;
1696: l_clev_tbl_in (1).start_date := p_new_sdt;
1697: l_clev_tbl_in (1).end_date := p_new_edt;
1698: okc_contract_pub.update_contract_line
1699: (p_api_version => l_api_version,
1700: p_init_msg_list => l_init_msg_list,
1701: p_restricted_update => okc_api.g_true,
1702: x_return_status => l_return_status,

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

1710: THEN
1711: fnd_log.STRING
1712: (fnd_log.level_event,
1713: g_module_current || '.Update_Line_Dates.external_call.after',
1714: 'okc_contract_pub.update_contract_line(Return status = '
1715: || l_return_status
1716: || ')'
1717: );
1718: END IF;

Line 1928: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

1924: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
1925: l_return_status VARCHAR2 (1) := 'S';
1926: l_index VARCHAR2 (2000);
1927: --Contract Header
1928: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
1929: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
1930: --Rule Related
1931: --l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
1932: --l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;

Line 1929: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

1925: l_return_status VARCHAR2 (1) := 'S';
1926: l_index VARCHAR2 (2000);
1927: --Contract Header
1928: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
1929: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
1930: --Rule Related
1931: --l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
1932: --l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
1933: --Time Value Related

Line 1966: okc_contract_pub.update_contract_header

1962: --Contract Header Date Update
1963: l_chrv_tbl_in (1).ID := p_chr_id;
1964: l_chrv_tbl_in (1).start_date := p_new_sdt;
1965: l_chrv_tbl_in (1).end_date := p_new_edt;
1966: okc_contract_pub.update_contract_header
1967: (p_api_version => l_api_version,
1968: p_init_msg_list => l_init_msg_list,
1969: p_restricted_update => okc_api.g_true,
1970: x_return_status => l_return_status,

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

1978: THEN
1979: fnd_log.STRING
1980: (fnd_log.level_event,
1981: g_module_current || '.Update_Hdr_Dates.external_call.after',
1982: 'okc_contract_pub.update_contract_header(Return status = '
1983: || l_return_status
1984: || ')'
1985: );
1986: END IF;

Line 2097: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

2093: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
2094: l_return_status VARCHAR2 (1) := 'S';
2095: l_index VARCHAR2 (2000);
2096: --Contract Line Table
2097: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
2098: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
2099: --Contract Item
2100: l_cimv_tbl_in okc_contract_item_pub.cimv_tbl_type;
2101: l_cimv_tbl_out okc_contract_item_pub.cimv_tbl_type;

Line 2098: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

2094: l_return_status VARCHAR2 (1) := 'S';
2095: l_index VARCHAR2 (2000);
2096: --Contract Line Table
2097: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
2098: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
2099: --Contract Item
2100: l_cimv_tbl_in okc_contract_item_pub.cimv_tbl_type;
2101: l_cimv_tbl_out okc_contract_item_pub.cimv_tbl_type;
2102: l_parent_line_id NUMBER;

Line 2111: okc_contract_pub.update_contract_line

2107: THEN
2108: x_return_status := okc_api.g_ret_sts_success;
2109: l_clev_tbl_in (1).ID := p_covered_line_id;
2110: l_clev_tbl_in (1).end_date := p_new_end_date;
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 2128: 'okc_contract_pub.update_contract_line(Return status = '

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

Line 2151: okc_contract_pub.update_contract_line

2147: x_return_status := okc_api.g_ret_sts_success;
2148: l_clev_tbl_in (1).ID := p_covered_line_id;
2149: l_clev_tbl_in (1).price_negotiated := p_new_negotiated_amt;
2150: l_clev_tbl_in (1).price_unit := p_list_price;
2151: okc_contract_pub.update_contract_line
2152: (p_api_version => l_api_version,
2153: p_init_msg_list => l_init_msg_list,
2154: p_restricted_update => okc_api.g_true,
2155: x_return_status => l_return_status,

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

2163: THEN
2164: fnd_log.STRING
2165: (fnd_log.level_event,
2166: g_module_current || '.Update_Cov_level.external_call.after',
2167: 'okc_contract_pub.update_contract_line(Return status = '
2168: || l_return_status
2169: || ')'
2170: );
2171: END IF;

Line 2409: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

2405: l_return_status VARCHAR2 (1) := 'S';
2406: l_index VARCHAR2 (2000);
2407: i NUMBER;
2408: --Contract Header
2409: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
2410: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
2411: l_khrv_tbl_in oks_khr_pvt.khrv_tbl_type;
2412: l_khrv_tbl_out oks_khr_pvt.khrv_tbl_type;
2413: --SalesCredit

Line 2410: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

2406: l_index VARCHAR2 (2000);
2407: i NUMBER;
2408: --Contract Header
2409: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
2410: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
2411: l_khrv_tbl_in oks_khr_pvt.khrv_tbl_type;
2412: l_khrv_tbl_out oks_khr_pvt.khrv_tbl_type;
2413: --SalesCredit
2414: l_scrv_tbl_in oks_sales_credit_pub.scrv_tbl_type;

Line 2423: l_gvev_tbl_in okc_contract_pub.gvev_tbl_type;

2419: --Contacts
2420: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
2421: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
2422: --Agreements/Governance
2423: l_gvev_tbl_in okc_contract_pub.gvev_tbl_type;
2424: l_gvev_tbl_out okc_contract_pub.gvev_tbl_type;
2425: --Time Value Related
2426: l_isev_ext_tbl_in okc_time_pub.isev_ext_tbl_type;
2427: l_isev_ext_tbl_out okc_time_pub.isev_ext_tbl_type;

Line 2424: l_gvev_tbl_out okc_contract_pub.gvev_tbl_type;

2420: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
2421: l_ctcv_tbl_out okc_contract_party_pub.ctcv_tbl_type;
2422: --Agreements/Governance
2423: l_gvev_tbl_in okc_contract_pub.gvev_tbl_type;
2424: l_gvev_tbl_out okc_contract_pub.gvev_tbl_type;
2425: --Time Value Related
2426: l_isev_ext_tbl_in okc_time_pub.isev_ext_tbl_type;
2427: l_isev_ext_tbl_out okc_time_pub.isev_ext_tbl_type;
2428: --Approval WorkFlow

Line 2429: l_cpsv_tbl_in okc_contract_pub.cpsv_tbl_type;

2425: --Time Value Related
2426: l_isev_ext_tbl_in okc_time_pub.isev_ext_tbl_type;
2427: l_isev_ext_tbl_out okc_time_pub.isev_ext_tbl_type;
2428: --Approval WorkFlow
2429: l_cpsv_tbl_in okc_contract_pub.cpsv_tbl_type;
2430: l_cpsv_tbl_out okc_contract_pub.cpsv_tbl_type;
2431: --REL OBJS
2432: l_crjv_tbl_out okc_k_rel_objs_pub.crjv_tbl_type;
2433: --Return IDs

Line 2430: l_cpsv_tbl_out okc_contract_pub.cpsv_tbl_type;

2426: l_isev_ext_tbl_in okc_time_pub.isev_ext_tbl_type;
2427: l_isev_ext_tbl_out okc_time_pub.isev_ext_tbl_type;
2428: --Approval WorkFlow
2429: l_cpsv_tbl_in okc_contract_pub.cpsv_tbl_type;
2430: l_cpsv_tbl_out okc_contract_pub.cpsv_tbl_type;
2431: --REL OBJS
2432: l_crjv_tbl_out okc_k_rel_objs_pub.crjv_tbl_type;
2433: --Return IDs
2434: l_chrid NUMBER;

Line 2665: okc_contract_pub.create_contract_header

2661: THEN
2662: l_chrv_tbl_in (1).attribute1 := p_k_header_rec.merge_object_id;
2663: END IF;
2664:
2665: okc_contract_pub.create_contract_header
2666: (p_api_version => l_api_version,
2667: p_init_msg_list => l_init_msg_list,
2668: x_return_status => l_return_status,
2669: x_msg_count => x_msg_count,

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

2676: THEN
2677: fnd_log.STRING
2678: (fnd_log.level_event,
2679: g_module_current || '.Create_K_Hdr.external_call.after',
2680: 'okc_contract_pub.create_contract_header(Return Status = '
2681: || l_return_status
2682: || ')'
2683: );
2684: END IF;

Line 2710: '(okc_contract_pub).create_contract_header '

2706: fnd_message.set_encoded (l_msg_data);
2707: l_msg_data := fnd_message.get;
2708: fnd_file.put_line
2709: (fnd_file.LOG,
2710: '(okc_contract_pub).create_contract_header '
2711: || l_msg_data
2712: );
2713: END IF;
2714: END LOOP;

Line 3671: okc_contract_pub.create_contract_process

3667: l_cpsv_tbl_in (1).creation_date := okc_api.g_miss_date;
3668: l_cpsv_tbl_in (1).last_updated_by := okc_api.g_miss_num;
3669: l_cpsv_tbl_in (1).last_update_date := okc_api.g_miss_date;
3670: l_cpsv_tbl_in (1).last_update_login := okc_api.g_miss_num;
3671: okc_contract_pub.create_contract_process
3672: (p_api_version => l_api_version,
3673: p_init_msg_list => l_init_msg_list,
3674: x_return_status => l_return_status,
3675: x_msg_count => x_msg_count,

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

3682: THEN
3683: fnd_log.STRING
3684: (fnd_log.level_event,
3685: g_module_current || '.Create_K_Hdr.external_call.after',
3686: 'okc_contract_pub.create_contract_process(Return status = '
3687: || l_return_status
3688: || ')'
3689: );
3690: END IF;

Line 3712: okc_contract_pub.create_governance

3708: l_gvev_tbl_in (1).chr_id := l_chrid;
3709: l_gvev_tbl_in (1).isa_agreement_id := p_k_header_rec.agreement_id;
3710: l_gvev_tbl_in (1).copied_only_yn := 'Y';
3711: l_gvev_tbl_in (1).dnz_chr_id := l_chrid;
3712: okc_contract_pub.create_governance
3713: (p_api_version => l_api_version,
3714: p_init_msg_list => l_init_msg_list,
3715: x_return_status => l_return_status,
3716: x_msg_count => x_msg_count,

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

3723: THEN
3724: fnd_log.STRING
3725: (fnd_log.level_event,
3726: g_module_current || '.Create_K_Hdr.external_call.after',
3727: 'okc_contract_pub.create_governance(Return status = '
3728: || l_return_status
3729: || ')'
3730: );
3731: END IF;

Line 3939: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

3935: l_sales_group_id NUMBER;
3936: l_ctr_grpid VARCHAR2 (40);
3937: l_ste_code VARCHAR2 (30);
3938: --Contract Line Table
3939: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
3940: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
3941: l_klnv_tbl_in oks_kln_pvt.klnv_tbl_type;
3942: l_klnv_tbl_out oks_kln_pvt.klnv_tbl_type;
3943: --Contract Item

Line 3940: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

3936: l_ctr_grpid VARCHAR2 (40);
3937: l_ste_code VARCHAR2 (30);
3938: --Contract Line Table
3939: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
3940: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
3941: l_klnv_tbl_in oks_kln_pvt.klnv_tbl_type;
3942: l_klnv_tbl_out oks_kln_pvt.klnv_tbl_type;
3943: --Contract Item
3944: l_cimv_tbl_in okc_contract_item_pub.cimv_tbl_type;

Line 4235: okc_contract_pub.create_contract_line

4231: l_clev_tbl_in (1).bill_to_site_use_id := p_k_line_rec.bill_to_id; --BTO
4232: l_clev_tbl_in (1).ship_to_site_use_id := p_k_line_rec.ship_to_id; --STO
4233: l_clev_tbl_in (1).price_list_id := p_k_line_rec.ln_price_list_id;
4234: -- price list
4235: okc_contract_pub.create_contract_line
4236: (p_api_version => l_api_version,
4237: p_init_msg_list => l_init_msg_list,
4238: p_restricted_update => okc_api.g_true,
4239: x_return_status => l_return_status,

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

4248: fnd_log.STRING
4249: (fnd_log.level_event,
4250: g_module_current
4251: || '.Create_K_Service_Lines.External_call.after',
4252: 'okc_contract_pub.create_contract_line(Return status = '
4253: || l_return_status
4254: );
4255: END IF;
4256:

Line 4281: '(okc_contract_pub).create_contract_line '

4277: fnd_message.set_encoded (l_msg_data);
4278: l_msg_data := fnd_message.get;
4279: fnd_file.put_line
4280: (fnd_file.LOG,
4281: '(okc_contract_pub).create_contract_line '
4282: || l_msg_data
4283: );
4284: END IF;
4285: END LOOP;

Line 4972: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

4968: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
4969: l_return_status VARCHAR2 (1) := 'S';
4970: l_index VARCHAR2 (2000);
4971: --Contract Line Table
4972: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
4973: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
4974: l_klnv_tbl_in oks_kln_pvt.klnv_tbl_type;
4975: l_klnv_tbl_out oks_kln_pvt.klnv_tbl_type;
4976: --Contract Item

Line 4973: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

4969: l_return_status VARCHAR2 (1) := 'S';
4970: l_index VARCHAR2 (2000);
4971: --Contract Line Table
4972: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
4973: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
4974: l_klnv_tbl_in oks_kln_pvt.klnv_tbl_type;
4975: l_klnv_tbl_out oks_kln_pvt.klnv_tbl_type;
4976: --Contract Item
4977: l_cimv_tbl okc_contract_item_pub.cimv_tbl_type;

Line 5301: okc_contract_pub.create_contract_line

5297: -- rules inserted by okc
5298: l_clev_tbl_in (1).line_renewal_type_code :=
5299: NVL (p_k_covd_rec.line_renewal_type, 'FUL');
5300: --LRT
5301: okc_contract_pub.create_contract_line
5302: (p_api_version => l_api_version,
5303: p_init_msg_list => l_init_msg_list,
5304: p_restricted_update => okc_api.g_true,
5305: x_return_status => l_return_status,

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

5314: fnd_log.STRING
5315: (fnd_log.level_event,
5316: g_module_current
5317: || '.Create_K_Covered_Levels.after_create.top_line',
5318: 'okc_contract_pub.create_contract_line(Return status = '
5319: || l_return_status
5320: || ')'
5321: );
5322: END IF;

Line 5348: '(OKC_CONTRACT_PUB).CREATE_CONTRACT_LINE '

5344: fnd_message.set_encoded (l_msg_data);
5345: l_msg_data := fnd_message.get;
5346: fnd_file.put_line
5347: (fnd_file.LOG,
5348: '(OKC_CONTRACT_PUB).CREATE_CONTRACT_LINE '
5349: || l_msg_data
5350: );
5351: END IF;
5352: END LOOP;

Line 6934: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

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

Line 6935: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

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

Line 7832: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

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

Line 7833: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

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

Line 8104: okc_contract_pub.update_contract_line

8100:
8101: get_sts_code ('TERMINATED', NULL, l_ste_code, l_sts_code);
8102: l_clev_tbl_in (1).sts_code := l_sts_code;
8103:
8104: okc_contract_pub.update_contract_line
8105: (p_api_version => l_api_version,
8106: p_init_msg_list => l_init_msg_list,
8107: p_restricted_update => okc_api.g_true,
8108: x_return_status => l_return_status,

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

8117: fnd_log.STRING
8118: (fnd_log.level_event,
8119: g_module_current
8120: || '.CREATE_CONTRACT_IBREPLACE.update_cov_lvl',
8121: 'okc_contract_pub.update_contract_line(Return status = '
8122: || l_return_status
8123: || 'count = '
8124: || p_kdtl_tbl.COUNT
8125: || ')'

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

8208: THEN
8209: fnd_log.STRING
8210: (fnd_log.level_event,
8211: g_module_current || '.CREATE_CONTRACT_IBTERMINATE',
8212: 'okc_contract_pub.update_contract_line(Return status ='
8213: || l_return_status
8214: || ')'
8215: );
8216: END IF;

Line 8778: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

8774: l_oldamt NUMBER := 0;
8775: l_ctr NUMBER := 0;
8776: l_terminate_rec okc_terminate_pvt.terminate_in_cle_rec;
8777: --Contract Line Table
8778: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
8779: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
8780: l_api_version CONSTANT NUMBER := 1.0;
8781: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
8782: l_retdt DATE;

Line 8779: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

8775: l_ctr NUMBER := 0;
8776: l_terminate_rec okc_terminate_pvt.terminate_in_cle_rec;
8777: --Contract Line Table
8778: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
8779: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
8780: l_api_version CONSTANT NUMBER := 1.0;
8781: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;
8782: l_retdt DATE;
8783: l_ste_code VARCHAR2 (30);

Line 8786: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

8782: l_retdt DATE;
8783: l_ste_code VARCHAR2 (30);
8784: l_sts_code VARCHAR2 (30);
8785: l_suppress_credit VARCHAR2 (2) := 'N';
8786: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
8787: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
8788: l_full_credit VARCHAR2 (2) := 'N';
8789: l_rnrl_rec_out oks_renew_util_pvt.rnrl_rec_type;
8790: l_service_name VARCHAR2 (2000);

Line 8787: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

8783: l_ste_code VARCHAR2 (30);
8784: l_sts_code VARCHAR2 (30);
8785: l_suppress_credit VARCHAR2 (2) := 'N';
8786: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
8787: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
8788: l_full_credit VARCHAR2 (2) := 'N';
8789: l_rnrl_rec_out oks_renew_util_pvt.rnrl_rec_type;
8790: l_service_name VARCHAR2 (2000);
8791: date_terminated DATE;

Line 9017: okc_contract_pub.update_contract_line

9013: If TRUNC (date_terminated)<= trunc(sysdate) Then
9014: l_clev_tbl_in (1).sts_code := l_sts_code;
9015: End If;
9016:
9017: okc_contract_pub.update_contract_line
9018: (p_api_version => l_api_version,
9019: p_init_msg_list => l_init_msg_list,
9020: p_restricted_update => okc_api.g_true,
9021: x_return_status => l_return_status,

Line 9057: okc_contract_pub.update_contract_header

9053: l_chrv_tbl_in (1).sts_code := l_sts_code;
9054: End If;
9055:
9056:
9057: okc_contract_pub.update_contract_header
9058: (p_api_version => l_api_version,
9059: p_init_msg_list => l_init_msg_list,
9060: p_restricted_update => okc_api.g_true,
9061: x_return_status => l_return_status,

Line 9075: 'okc_contract_pub.update_contract_header(Return status =

9071: fnd_log.STRING
9072: (fnd_log.level_event,
9073: g_module_current
9074: || '.CREATE_CONTRACT_IBRETURN.external_call.after',
9075: 'okc_contract_pub.update_contract_header(Return status =
9076: '
9077: || l_return_status
9078: || ')'
9079: );

Line 9606: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

9602: l_sts_code VARCHAR2 (40);
9603: l_ctr NUMBER;
9604: l_suppress_credit VARCHAR2 (10) := 'N';
9605: l_trfdt DATE;
9606: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
9607: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
9608: l_api_version CONSTANT NUMBER := 1.0;
9609: l_init_msg_list CONSTANT VARCHAR2 (1) := 'F';
9610: l_index NUMBER;

Line 9607: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

9603: l_ctr NUMBER;
9604: l_suppress_credit VARCHAR2 (10) := 'N';
9605: l_trfdt DATE;
9606: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
9607: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
9608: l_api_version CONSTANT NUMBER := 1.0;
9609: l_init_msg_list CONSTANT VARCHAR2 (1) := 'F';
9610: l_index NUMBER;
9611: l_relationship VARCHAR2 (40);

Line 9642: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

9638: l_new_party_name VARCHAR2 (360);
9639: l_old_party_name VARCHAR2 (360);
9640: date_terminated DATE;
9641: date_cancelled DATE;
9642: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
9643: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
9644: l_create_contract VARCHAR2 (1);
9645: l_party_id NUMBER;
9646: l_party_name VARCHAR2 (360);

Line 9643: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

9639: l_old_party_name VARCHAR2 (360);
9640: date_terminated DATE;
9641: date_cancelled DATE;
9642: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
9643: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
9644: l_create_contract VARCHAR2 (1);
9645: l_party_id NUMBER;
9646: l_party_name VARCHAR2 (360);
9647: l_opr_instance_id NUMBER;

Line 9840: l_cacv_tbl_in okc_contract_pub.cacv_tbl_type;

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);
9843: l_bill_to_id NUMBER;
9844: l_ship_to_id NUMBER;

Line 9841: l_cacv_tbl_out okc_contract_pub.cacv_tbl_type;

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);
9843: l_bill_to_id NUMBER;
9844: l_ship_to_id NUMBER;
9845: l_valid VARCHAR2 (1);

Line 10218: okc_contract_pub.create_contract_access

10214: l_cacv_tbl_in (1).chr_id := l_chrid;
10215: l_cacv_tbl_in (1).resource_id := l_resource_id;
10216: l_cacv_tbl_in (1).GROUP_ID := l_group_id;
10217: l_cacv_tbl_in (1).access_level := l_access_level;
10218: okc_contract_pub.create_contract_access
10219: (p_api_version => l_api_version,
10220: p_init_msg_list => l_init_msg_list,
10221: x_return_status => l_return_status,
10222: x_msg_count => x_msg_count,

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

10230: fnd_log.STRING
10231: (fnd_log.level_statement,
10232: g_module_current
10233: || '.CREATE_K_SYSTEM_TRF.create_contract_header',
10234: 'okc_contract_pub.create_contract_access(Return status = '
10235: || l_return_status
10236: || ')'
10237: );
10238: END IF;

Line 11394: okc_contract_pub.update_contract_line

11390: If TRUNC (date_terminated)<= trunc(sysdate) Then
11391: l_clev_tbl_in (1).sts_code := l_sts_code;
11392: End If;
11393:
11394: okc_contract_pub.update_contract_line
11395: (p_api_version => l_api_version,
11396: p_init_msg_list => l_init_msg_list,
11397: p_restricted_update => okc_api.g_true,
11398: x_return_status => l_return_status,

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

11408: THEN
11409: fnd_log.STRING
11410: (fnd_log.level_event,
11411: g_module_current || '.CREATE_K_SYSTEM_TRF',
11412: 'okc_contract_pub.update_contract_line(Return status = '
11413: || l_return_status
11414: || ')'
11415: );
11416: END IF;

Line 11444: okc_contract_pub.update_contract_header

11440: If TRUNC (date_terminated)<= trunc(sysdate) Then
11441: l_chrv_tbl_in (1).sts_code := l_sts_code;
11442: End If;
11443:
11444: okc_contract_pub.update_contract_header
11445: (p_api_version => l_api_version,
11446: p_init_msg_list => l_init_msg_list,
11447: p_restricted_update => okc_api.g_true,
11448: x_return_status => l_return_status,

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

11459: fnd_log.STRING
11460: (fnd_log.level_event,
11461: g_module_current
11462: || '.Update_Hdr_Dates.external_call.after',
11463: 'okc_contract_pub.update_contract_header(Return status = '
11464: || l_return_status
11465: || ')'
11466: );
11467: END IF;

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

11517: THEN
11518: fnd_log.STRING
11519: (fnd_log.level_event,
11520: g_module_current || '.CREATE_K_SYSTEM_TRF',
11521: 'okc_contract_pub.update_contract_line(Return status ='
11522: || l_return_status
11523: || ')'
11524: );
11525: END IF;

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

11570: THEN
11571: fnd_log.STRING
11572: (fnd_log.level_event,
11573: g_module_current || '.CREATE_K_SYSTEM_TRF',
11574: 'okc_contract_pub.update_contract_line(Return status = '
11575: || l_return_status
11576: || ')'
11577: );
11578: END IF;

Line 11904: okc_contract_pub.update_contract_line

11900: If TRUNC (date_terminated)<= trunc(sysdate) Then
11901: l_clev_tbl_in (1).sts_code := l_sts_code;
11902: End If;
11903:
11904: okc_contract_pub.update_contract_line
11905: (p_api_version => l_api_version,
11906: p_init_msg_list => l_init_msg_list,
11907: p_restricted_update => okc_api.g_true,
11908: x_return_status => l_return_status,

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

11918: THEN
11919: fnd_log.STRING
11920: (fnd_log.level_event,
11921: g_module_current || '.CREATE_K_SYSTEM_TRF',
11922: 'okc_contract_pub.update_contract_line(Return status = '
11923: || l_return_status
11924: || ')'
11925: );
11926: END IF;

Line 11954: okc_contract_pub.update_contract_header

11950: If TRUNC (date_terminated)<= trunc(sysdate) Then
11951: l_chrv_tbl_in (1).sts_code := l_sts_code;
11952: End If;
11953:
11954: okc_contract_pub.update_contract_header
11955: (p_api_version => l_api_version,
11956: p_init_msg_list => l_init_msg_list,
11957: p_restricted_update => okc_api.g_true,
11958: x_return_status => l_return_status,

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

11969: fnd_log.STRING
11970: (fnd_log.level_event,
11971: g_module_current
11972: || '.Update_Hdr_Dates.external_call.after',
11973: 'okc_contract_pub.update_contract_header(Return status = '
11974: || l_return_status
11975: || ')'
11976: );
11977: END IF;

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

12072: THEN
12073: fnd_log.STRING
12074: (fnd_log.level_event,
12075: g_module_current || '.CREATE_K_SYSTEM_TRF',
12076: 'okc_contract_pub.update_contract_line(Return status = '
12077: || l_return_status
12078: || ')'
12079: );
12080: END IF;

Line 14206: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

14202: x_insthist_rec oks_ins_pvt.insv_rec_type;
14203: l_parameters VARCHAR2 (2000);
14204: l_service_name VARCHAR2 (2000);
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;

Line 14207: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

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

Line 14234: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;

14230: date_terminated DATE;
14231: date_cancelled DATE;
14232: l_alllines_terminated VARCHAR2 (1);
14233: l_alllines_cancelled VARCHAR2 (1);
14234: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
14235: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
14236: l_ptr NUMBER;
14237: l_term_date_flag VARCHAR2 (1);
14238: l_credit_amount VARCHAR2 (50);

Line 14235: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;

14231: date_cancelled DATE;
14232: l_alllines_terminated VARCHAR2 (1);
14233: l_alllines_cancelled VARCHAR2 (1);
14234: l_chrv_tbl_in okc_contract_pub.chrv_tbl_type;
14235: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
14236: l_ptr NUMBER;
14237: l_term_date_flag VARCHAR2 (1);
14238: l_credit_amount VARCHAR2 (50);
14239: BEGIN

Line 14431: okc_contract_pub.update_contract_line

14427: If TRUNC (date_terminated)<= trunc(sysdate) Then
14428: l_clev_tbl_in (1).sts_code := l_sts_code;
14429: End If;
14430:
14431: okc_contract_pub.update_contract_line
14432: (p_api_version => l_api_version,
14433: p_init_msg_list => l_init_msg_list,
14434: p_restricted_update => okc_api.g_true,
14435: x_return_status => l_return_status,

Line 14481: okc_contract_pub.update_contract_header

14477: If TRUNC (date_terminated)<= trunc(sysdate) Then
14478: l_chrv_tbl_in (1).sts_code := l_sts_code;
14479: End If;
14480:
14481: okc_contract_pub.update_contract_header
14482: (p_api_version => l_api_version,
14483: p_init_msg_list => l_init_msg_list,
14484: p_restricted_update => okc_api.g_true,
14485: x_return_status => l_return_status,

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

14495: fnd_log.STRING
14496: (fnd_log.level_event,
14497: g_module_current
14498: || '.Update_Hdr_Dates.external_call.after',
14499: 'okc_contract_pub.update_contract_header(Return status = '
14500: || l_return_status
14501: || ')'
14502: );
14503: END IF;

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

14541: THEN
14542: fnd_log.STRING
14543: (fnd_log.level_event,
14544: g_module_current || '.CREATE_CONTRACT_IBTERMINATE',
14545: 'okc_contract_pub.update_contract_line(Return status ='
14546: || l_return_status
14547: || ')'
14548: );
14549: END IF;

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

14591: THEN
14592: fnd_log.STRING
14593: (fnd_log.level_event,
14594: g_module_current || '.CREATE_CONTRACT_IBTERMINATE',
14595: 'okc_contract_pub.update_contract_line(Return status = '
14596: || l_return_status
14597: || ')'
14598: );
14599: END IF;

Line 15824: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

15820: l_ref_num VARCHAR2 (30);
15821: l_parameters VARCHAR2 (2000);
15822: l_renewal_id NUMBER;
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;

Line 15825: l_clev_tbl_out okc_contract_pub.clev_tbl_type;

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