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_RENEW_CONTRACT_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 414: update okc_k_headers_all_b SET

410: --start date and end date
411: --If time component is nulled out, duration can be different and this will affect pricing
412:
413: --first update contract header
414: update okc_k_headers_all_b SET
415: start_date = to_date(to_char(p_new_start_date, 'DD/MM/YYYY')|| to_char(start_date,'HH24:MI:SS'), 'DD/MM/YYYYHH24:MI:SS'),
416: end_date = to_date(to_char(p_new_end_date, 'DD/MM/YYYY')|| to_char(end_date,'HH24:MI:SS'), 'DD/MM/YYYYHH24:MI:SS')
417: WHERE id = p_chr_id;
418:

Line 712: UPDATE okc_k_headers_all_b

708: END IF;
709: x_return_status := FND_API.G_RET_STS_SUCCESS;
710:
711:
712: UPDATE okc_k_headers_all_b
713: SET date_renewed = l_date,
714: object_version_number = (object_version_number + 1)
715: WHERE id = p_old_chr_id;
716:

Line 1019: UPDATE okc_k_headers_all_b h

1015: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update_header', 'updating okc-oks header etimated_amount and tax_amount');
1016: END IF;
1017:
1018: --update the header
1019: UPDATE okc_k_headers_all_b h
1020: SET h.estimated_amount =
1021: (SELECT sum(price_negotiated) FROM okc_k_lines_b tl
1022: WHERE tl.dnz_chr_id = p_chr_id AND tl.cle_id IS NULL
1023: AND tl.lse_id IN (1,12,19,46))

Line 1331: FROM okc_k_headers_all_b a, okc_k_party_roles_b b

1327:
1328: --gets the contract org id and customer/subscriber party id
1329: CURSOR c_k_hdr(cp_chr_id IN NUMBER) IS
1330: SELECT nvl(a.org_id, a.authoring_org_id), to_number(b.object1_id1)
1331: FROM okc_k_headers_all_b a, okc_k_party_roles_b b
1332: WHERE a.id = cp_chr_id
1333: AND b.rle_code IN ('CUSTOMER', 'SUBSCRIBER')
1334: AND b.dnz_chr_id = a.id
1335: AND b.cle_id IS NULL;

Line 2949: FROM okc_k_headers_all_b ren, okc_k_headers_all_b old,

2945:
2946: CURSOR c_hdr_dates(cp_chr_id IN NUMBER) IS
2947: SELECT ren.start_date, ren.end_date, old.start_date, old.end_date, old.id,
2948: rens.period_type, rens.period_start, olds.period_type, olds.period_start
2949: FROM okc_k_headers_all_b ren, okc_k_headers_all_b old,
2950: oks_k_headers_b rens, oks_k_headers_b olds
2951: WHERE ren.id = cp_chr_id
2952: AND rens.chr_id = ren.id
2953: AND old.id = ren.orig_system_id1

Line 3483: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_k_headers_all_b c, OKC_SUBCLASSES_B SCS

3479: a.conversion_euro_rate, b.renewal_po_number, b.trxn_extension_id,
3480: b.grace_period, b.grace_duration, c.date_renewed, -- added for bug 6086893
3481: a.start_date, a.end_date, c.scs_code, c.sts_code, c.estimated_amount,
3482: c.start_date, c.end_date, scs.cls_code, c.id
3483: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_k_headers_all_b c, OKC_SUBCLASSES_B SCS
3484: WHERE a.id = b.chr_id
3485: AND a.id = cp_chr_id
3486: AND c.id = a.orig_system_id1
3487: AND c.scs_code = scs.code;

Line 3497: l_new_start_date okc_k_headers_all_b.start_date%TYPE;

3493: /*added for bug 9020536*/
3494:
3495:
3496: -- added for bug 6086893
3497: l_new_start_date okc_k_headers_all_b.start_date%TYPE;
3498: l_new_end_date okc_k_headers_all_b.end_date%TYPE;
3499: l_old_scs_code okc_k_headers_all_b.scs_code%TYPE;
3500: l_old_sts_code okc_k_headers_all_b.sts_code%TYPE;
3501: l_old_estimated_amount okc_k_headers_all_b.estimated_amount%TYPE;

Line 3498: l_new_end_date okc_k_headers_all_b.end_date%TYPE;

3494:
3495:
3496: -- added for bug 6086893
3497: l_new_start_date okc_k_headers_all_b.start_date%TYPE;
3498: l_new_end_date okc_k_headers_all_b.end_date%TYPE;
3499: l_old_scs_code okc_k_headers_all_b.scs_code%TYPE;
3500: l_old_sts_code okc_k_headers_all_b.sts_code%TYPE;
3501: l_old_estimated_amount okc_k_headers_all_b.estimated_amount%TYPE;
3502: l_old_start_date okc_k_headers_all_b.start_date%TYPE;

Line 3499: l_old_scs_code okc_k_headers_all_b.scs_code%TYPE;

3495:
3496: -- added for bug 6086893
3497: l_new_start_date okc_k_headers_all_b.start_date%TYPE;
3498: l_new_end_date okc_k_headers_all_b.end_date%TYPE;
3499: l_old_scs_code okc_k_headers_all_b.scs_code%TYPE;
3500: l_old_sts_code okc_k_headers_all_b.sts_code%TYPE;
3501: l_old_estimated_amount okc_k_headers_all_b.estimated_amount%TYPE;
3502: l_old_start_date okc_k_headers_all_b.start_date%TYPE;
3503: l_old_end_date okc_k_headers_all_b.end_date%TYPE;

Line 3500: l_old_sts_code okc_k_headers_all_b.sts_code%TYPE;

3496: -- added for bug 6086893
3497: l_new_start_date okc_k_headers_all_b.start_date%TYPE;
3498: l_new_end_date okc_k_headers_all_b.end_date%TYPE;
3499: l_old_scs_code okc_k_headers_all_b.scs_code%TYPE;
3500: l_old_sts_code okc_k_headers_all_b.sts_code%TYPE;
3501: l_old_estimated_amount okc_k_headers_all_b.estimated_amount%TYPE;
3502: l_old_start_date okc_k_headers_all_b.start_date%TYPE;
3503: l_old_end_date okc_k_headers_all_b.end_date%TYPE;
3504: l_cls_code okc_subclasses_b.cls_code%TYPE;

Line 3501: l_old_estimated_amount okc_k_headers_all_b.estimated_amount%TYPE;

3497: l_new_start_date okc_k_headers_all_b.start_date%TYPE;
3498: l_new_end_date okc_k_headers_all_b.end_date%TYPE;
3499: l_old_scs_code okc_k_headers_all_b.scs_code%TYPE;
3500: l_old_sts_code okc_k_headers_all_b.sts_code%TYPE;
3501: l_old_estimated_amount okc_k_headers_all_b.estimated_amount%TYPE;
3502: l_old_start_date okc_k_headers_all_b.start_date%TYPE;
3503: l_old_end_date okc_k_headers_all_b.end_date%TYPE;
3504: l_cls_code okc_subclasses_b.cls_code%TYPE;
3505: l_old_k_id okc_k_headers_all_b.id%TYPE;

Line 3502: l_old_start_date okc_k_headers_all_b.start_date%TYPE;

3498: l_new_end_date okc_k_headers_all_b.end_date%TYPE;
3499: l_old_scs_code okc_k_headers_all_b.scs_code%TYPE;
3500: l_old_sts_code okc_k_headers_all_b.sts_code%TYPE;
3501: l_old_estimated_amount okc_k_headers_all_b.estimated_amount%TYPE;
3502: l_old_start_date okc_k_headers_all_b.start_date%TYPE;
3503: l_old_end_date okc_k_headers_all_b.end_date%TYPE;
3504: l_cls_code okc_subclasses_b.cls_code%TYPE;
3505: l_old_k_id okc_k_headers_all_b.id%TYPE;
3506: -- end added for bug 6086893

Line 3503: l_old_end_date okc_k_headers_all_b.end_date%TYPE;

3499: l_old_scs_code okc_k_headers_all_b.scs_code%TYPE;
3500: l_old_sts_code okc_k_headers_all_b.sts_code%TYPE;
3501: l_old_estimated_amount okc_k_headers_all_b.estimated_amount%TYPE;
3502: l_old_start_date okc_k_headers_all_b.start_date%TYPE;
3503: l_old_end_date okc_k_headers_all_b.end_date%TYPE;
3504: l_cls_code okc_subclasses_b.cls_code%TYPE;
3505: l_old_k_id okc_k_headers_all_b.id%TYPE;
3506: -- end added for bug 6086893
3507:

Line 3505: l_old_k_id okc_k_headers_all_b.id%TYPE;

3501: l_old_estimated_amount okc_k_headers_all_b.estimated_amount%TYPE;
3502: l_old_start_date okc_k_headers_all_b.start_date%TYPE;
3503: l_old_end_date okc_k_headers_all_b.end_date%TYPE;
3504: l_cls_code okc_subclasses_b.cls_code%TYPE;
3505: l_old_k_id okc_k_headers_all_b.id%TYPE;
3506: -- end added for bug 6086893
3507:
3508: l_k_num VARCHAR2(120);
3509: l_k_mod VARCHAR2(120);

Line 3744: UPDATE okc_k_headers_all_b

3740: WHERE chr_id = p_chr_id;
3741:
3742: --update OKC header with the new attributes
3743: --note that we do not update the renewal type/approval type, we carry forward the old values
3744: UPDATE okc_k_headers_all_b
3745: SET qcl_id = l_qcl_id,
3746: inv_rule_id=Nvl(inv_id,inv_rule_id), --added for bug 9020536
3747: payment_term_id = l_payment_term_id,
3748: cust_po_number = l_cust_po_number,

Line 3964: FROM okc_k_headers_all_b a, okc_statuses_v b

3960: CURSOR c_k_hdr(cp_chr_id IN NUMBER) IS
3961: SELECT a.application_id, a.contract_number, a.contract_number_modifier,
3962: b.ste_code, b.meaning, a.scs_code, a.template_yn,
3963: a.date_terminated, a.date_renewed, a.end_date
3964: FROM okc_k_headers_all_b a, okc_statuses_v b
3965: WHERE a.id = cp_chr_id AND a.sts_code = b.code;
3966:
3967: --cursor to check if all sublines and subscr toplines have been renew consolidated
3968: CURSOR c_check_line_rencon(cp_chr_id IN NUMBER) IS

Line 3987: okc_statuses_b st, okc_k_headers_all_b k

3983: --active_yn = 'N'. So we want to get the active renewals (such as entered/signed status etc) first
3984: CURSOR c_check_hdr_renew (cp_chr_id IN NUMBER) IS
3985: SELECT k.contract_number, k.contract_number_modifier, st.ste_code
3986: FROM okc_operation_lines ol, okc_operation_instances oi, okc_class_operations oo,
3987: okc_statuses_b st, okc_k_headers_all_b k
3988: WHERE oo.cls_code = 'SERVICE' AND oo.opn_code = 'RENEWAL'
3989: AND oo.id = oi.cop_id
3990: AND ol.oie_id = oi.id AND ol.object_chr_id = cp_chr_id
3991: AND ol.subject_chr_id IS NOT NULL AND ol.object_cle_id IS NULL

Line 4609: ) iv, okc_k_items it, oks_k_lines_b sl, okc_k_lines_b kl, okc_k_headers_all_b kh

4605: T.DESCRIPTION NAME, B.CONCATENATED_SEGMENTS DESCRIPTION, B.ORGANIZATION_ID INV_ORG_ID
4606: FROM MTL_SYSTEM_ITEMS_B_KFV B,MTL_SYSTEM_ITEMS_TL T
4607: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
4608: AND T.LANGUAGE = USERENV('LANG')
4609: ) iv, okc_k_items it, oks_k_lines_b sl, okc_k_lines_b kl, okc_k_headers_all_b kh
4610: WHERE iv.type = it.jtot_object1_code -- bug 5218936
4611: AND iv.id1 = it.object1_id1
4612: AND iv.id2 = it.object1_id2
4613: AND decode(iv.inv_org_id, null, kh.inv_organization_id, iv.inv_org_id) = kh.inv_organization_id

Line 4632: okc_k_headers_all_b khr

4628: csi_item_instances cp ,
4629: mtl_system_items_kfv it,
4630: okc_k_items items,
4631: oks_k_lines_b kl,
4632: okc_k_headers_all_b khr
4633: WHERE ccb.counter_id = cct.counter_id
4634: AND cct.language = USERENV('LANG')
4635: AND ccb.group_id = cg.counter_group_id
4636: AND ccb.counter_id = cca.counter_id

Line 4856: FROM okc_k_headers_all_b a LEFT OUTER JOIN okc_k_party_roles_b b

4852: --should be an outer join with party roles, so that
4853: --if we don't get a vendor/merchant party we atleast get an org
4854: CURSOR c_k_hdr(cp_chr_id IN NUMBER) IS
4855: SELECT nvl(a.org_id, a.authoring_org_id), b.id
4856: FROM okc_k_headers_all_b a LEFT OUTER JOIN okc_k_party_roles_b b
4857: ON a.id = b.dnz_chr_id
4858: AND b.cle_id IS NULL
4859: AND b.rle_code IN ('VENDOR', 'MERCHANT')
4860: WHERE a.id = cp_chr_id;

Line 5129: FROM okc_k_headers_all_b

5125: --also check if it is a service contract
5126: CURSOR c_k_hdr(cp_chr_id IN NUMBER) IS
5127: SELECT contract_number, contract_number_modifier, start_date, end_date,
5128: renewal_type_code, renewal_end_date, currency_code
5129: FROM okc_k_headers_all_b
5130: WHERE id = cp_chr_id AND application_id = 515;
5131:
5132: CURSOR c_renk_hdr(cp_chr_id IN NUMBER) IS
5133: SELECT currency_code, org_id

Line 5134: FROM okc_k_headers_all_b WHERE id = cp_chr_id;

5130: WHERE id = cp_chr_id AND application_id = 515;
5131:
5132: CURSOR c_renk_hdr(cp_chr_id IN NUMBER) IS
5133: SELECT currency_code, org_id
5134: FROM okc_k_headers_all_b WHERE id = cp_chr_id;
5135:
5136:
5137: l_k_num okc_k_headers_b.contract_number%TYPE;
5138: l_k_mod okc_k_headers_b.contract_number_modifier%TYPE;