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 2938: FROM okc_k_headers_all_b ren, okc_k_headers_all_b old,

2934:
2935: CURSOR c_hdr_dates(cp_chr_id IN NUMBER) IS
2936: SELECT ren.start_date, ren.end_date, old.start_date, old.end_date, old.id,
2937: rens.period_type, rens.period_start, olds.period_type, olds.period_start
2938: FROM okc_k_headers_all_b ren, okc_k_headers_all_b old,
2939: oks_k_headers_b rens, oks_k_headers_b olds
2940: WHERE ren.id = cp_chr_id
2941: AND rens.chr_id = ren.id
2942: AND old.id = ren.orig_system_id1

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

3468: a.conversion_euro_rate, b.renewal_po_number, b.trxn_extension_id,
3469: b.grace_period, b.grace_duration, c.date_renewed, -- added for bug 6086893
3470: a.start_date, a.end_date, c.scs_code, c.sts_code, c.estimated_amount,
3471: c.start_date, c.end_date, scs.cls_code, c.id
3472: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_k_headers_all_b c, OKC_SUBCLASSES_B SCS
3473: WHERE a.id = b.chr_id
3474: AND a.id = cp_chr_id
3475: AND c.id = a.orig_system_id1
3476: AND c.scs_code = scs.code;

Line 3479: l_new_start_date okc_k_headers_all_b.start_date%TYPE;

3475: AND c.id = a.orig_system_id1
3476: AND c.scs_code = scs.code;
3477:
3478: -- added for bug 6086893
3479: l_new_start_date okc_k_headers_all_b.start_date%TYPE;
3480: l_new_end_date okc_k_headers_all_b.end_date%TYPE;
3481: l_old_scs_code okc_k_headers_all_b.scs_code%TYPE;
3482: l_old_sts_code okc_k_headers_all_b.sts_code%TYPE;
3483: l_old_estimated_amount okc_k_headers_all_b.estimated_amount%TYPE;

Line 3480: l_new_end_date okc_k_headers_all_b.end_date%TYPE;

3476: AND c.scs_code = scs.code;
3477:
3478: -- added for bug 6086893
3479: l_new_start_date okc_k_headers_all_b.start_date%TYPE;
3480: l_new_end_date okc_k_headers_all_b.end_date%TYPE;
3481: l_old_scs_code okc_k_headers_all_b.scs_code%TYPE;
3482: l_old_sts_code okc_k_headers_all_b.sts_code%TYPE;
3483: l_old_estimated_amount okc_k_headers_all_b.estimated_amount%TYPE;
3484: l_old_start_date okc_k_headers_all_b.start_date%TYPE;

Line 3481: l_old_scs_code okc_k_headers_all_b.scs_code%TYPE;

3477:
3478: -- added for bug 6086893
3479: l_new_start_date okc_k_headers_all_b.start_date%TYPE;
3480: l_new_end_date okc_k_headers_all_b.end_date%TYPE;
3481: l_old_scs_code okc_k_headers_all_b.scs_code%TYPE;
3482: l_old_sts_code okc_k_headers_all_b.sts_code%TYPE;
3483: l_old_estimated_amount okc_k_headers_all_b.estimated_amount%TYPE;
3484: l_old_start_date okc_k_headers_all_b.start_date%TYPE;
3485: l_old_end_date okc_k_headers_all_b.end_date%TYPE;

Line 3482: l_old_sts_code okc_k_headers_all_b.sts_code%TYPE;

3478: -- added for bug 6086893
3479: l_new_start_date okc_k_headers_all_b.start_date%TYPE;
3480: l_new_end_date okc_k_headers_all_b.end_date%TYPE;
3481: l_old_scs_code okc_k_headers_all_b.scs_code%TYPE;
3482: l_old_sts_code okc_k_headers_all_b.sts_code%TYPE;
3483: l_old_estimated_amount okc_k_headers_all_b.estimated_amount%TYPE;
3484: l_old_start_date okc_k_headers_all_b.start_date%TYPE;
3485: l_old_end_date okc_k_headers_all_b.end_date%TYPE;
3486: l_cls_code okc_subclasses_b.cls_code%TYPE;

Line 3483: l_old_estimated_amount okc_k_headers_all_b.estimated_amount%TYPE;

3479: l_new_start_date okc_k_headers_all_b.start_date%TYPE;
3480: l_new_end_date okc_k_headers_all_b.end_date%TYPE;
3481: l_old_scs_code okc_k_headers_all_b.scs_code%TYPE;
3482: l_old_sts_code okc_k_headers_all_b.sts_code%TYPE;
3483: l_old_estimated_amount okc_k_headers_all_b.estimated_amount%TYPE;
3484: l_old_start_date okc_k_headers_all_b.start_date%TYPE;
3485: l_old_end_date okc_k_headers_all_b.end_date%TYPE;
3486: l_cls_code okc_subclasses_b.cls_code%TYPE;
3487: l_old_k_id okc_k_headers_all_b.id%TYPE;

Line 3484: l_old_start_date okc_k_headers_all_b.start_date%TYPE;

3480: l_new_end_date okc_k_headers_all_b.end_date%TYPE;
3481: l_old_scs_code okc_k_headers_all_b.scs_code%TYPE;
3482: l_old_sts_code okc_k_headers_all_b.sts_code%TYPE;
3483: l_old_estimated_amount okc_k_headers_all_b.estimated_amount%TYPE;
3484: l_old_start_date okc_k_headers_all_b.start_date%TYPE;
3485: l_old_end_date okc_k_headers_all_b.end_date%TYPE;
3486: l_cls_code okc_subclasses_b.cls_code%TYPE;
3487: l_old_k_id okc_k_headers_all_b.id%TYPE;
3488: -- end added for bug 6086893

Line 3485: l_old_end_date okc_k_headers_all_b.end_date%TYPE;

3481: l_old_scs_code okc_k_headers_all_b.scs_code%TYPE;
3482: l_old_sts_code okc_k_headers_all_b.sts_code%TYPE;
3483: l_old_estimated_amount okc_k_headers_all_b.estimated_amount%TYPE;
3484: l_old_start_date okc_k_headers_all_b.start_date%TYPE;
3485: l_old_end_date okc_k_headers_all_b.end_date%TYPE;
3486: l_cls_code okc_subclasses_b.cls_code%TYPE;
3487: l_old_k_id okc_k_headers_all_b.id%TYPE;
3488: -- end added for bug 6086893
3489:

Line 3487: l_old_k_id okc_k_headers_all_b.id%TYPE;

3483: l_old_estimated_amount okc_k_headers_all_b.estimated_amount%TYPE;
3484: l_old_start_date okc_k_headers_all_b.start_date%TYPE;
3485: l_old_end_date okc_k_headers_all_b.end_date%TYPE;
3486: l_cls_code okc_subclasses_b.cls_code%TYPE;
3487: l_old_k_id okc_k_headers_all_b.id%TYPE;
3488: -- end added for bug 6086893
3489:
3490: l_k_num VARCHAR2(120);
3491: l_k_mod VARCHAR2(120);

Line 3712: UPDATE okc_k_headers_all_b

3708: WHERE chr_id = p_chr_id;
3709:
3710: --update OKC header with the new attributes
3711: --note that we do not update the renewal type/approval type, we carry forward the old values
3712: UPDATE okc_k_headers_all_b
3713: SET qcl_id = l_qcl_id,
3714: payment_term_id = l_payment_term_id,
3715: cust_po_number = l_cust_po_number,
3716: cust_po_number_req_yn = l_cust_po_number_req_yn,

Line 3929: FROM okc_k_headers_all_b a, okc_statuses_v b

3925: CURSOR c_k_hdr(cp_chr_id IN NUMBER) IS
3926: SELECT a.application_id, a.contract_number, a.contract_number_modifier,
3927: b.ste_code, b.meaning, a.scs_code, a.template_yn,
3928: a.date_terminated, a.date_renewed, a.end_date
3929: FROM okc_k_headers_all_b a, okc_statuses_v b
3930: WHERE a.id = cp_chr_id AND a.sts_code = b.code;
3931:
3932: --cursor to check if all sublines and subscr toplines have been renew consolidated
3933: CURSOR c_check_line_rencon(cp_chr_id IN NUMBER) IS

Line 3952: okc_statuses_b st, okc_k_headers_all_b k

3948: --active_yn = 'N'. So we want to get the active renewals (such as entered/signed status etc) first
3949: CURSOR c_check_hdr_renew (cp_chr_id IN NUMBER) IS
3950: SELECT k.contract_number, k.contract_number_modifier, st.ste_code
3951: FROM okc_operation_lines ol, okc_operation_instances oi, okc_class_operations oo,
3952: okc_statuses_b st, okc_k_headers_all_b k
3953: WHERE oo.cls_code = 'SERVICE' AND oo.opn_code = 'RENEWAL'
3954: AND oo.id = oi.cop_id
3955: AND ol.oie_id = oi.id AND ol.object_chr_id = cp_chr_id
3956: AND ol.subject_chr_id IS NOT NULL AND ol.object_cle_id IS NULL

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

4570: T.DESCRIPTION NAME, B.CONCATENATED_SEGMENTS DESCRIPTION, B.ORGANIZATION_ID INV_ORG_ID
4571: FROM MTL_SYSTEM_ITEMS_B_KFV B,MTL_SYSTEM_ITEMS_TL T
4572: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
4573: AND T.LANGUAGE = USERENV('LANG')
4574: ) iv, okc_k_items it, oks_k_lines_b sl, okc_k_lines_b kl, okc_k_headers_all_b kh
4575: WHERE iv.type = it.jtot_object1_code -- bug 5218936
4576: AND iv.id1 = it.object1_id1
4577: AND iv.id2 = it.object1_id2
4578: AND decode(iv.inv_org_id, null, kh.inv_organization_id, iv.inv_org_id) = kh.inv_organization_id

Line 4597: okc_k_headers_all_b khr

4593: csi_item_instances cp ,
4594: mtl_system_items_kfv it,
4595: okc_k_items items,
4596: oks_k_lines_b kl,
4597: okc_k_headers_all_b khr
4598: WHERE ccb.counter_id = cct.counter_id
4599: AND cct.language = USERENV('LANG')
4600: AND ccb.group_id = cg.counter_group_id
4601: AND ccb.counter_id = cca.counter_id

Line 4821: FROM okc_k_headers_all_b a LEFT OUTER JOIN okc_k_party_roles_b b

4817: --should be an outer join with party roles, so that
4818: --if we don't get a vendor/merchant party we atleast get an org
4819: CURSOR c_k_hdr(cp_chr_id IN NUMBER) IS
4820: SELECT nvl(a.org_id, a.authoring_org_id), b.id
4821: FROM okc_k_headers_all_b a LEFT OUTER JOIN okc_k_party_roles_b b
4822: ON a.id = b.dnz_chr_id
4823: AND b.cle_id IS NULL
4824: AND b.rle_code IN ('VENDOR', 'MERCHANT')
4825: WHERE a.id = cp_chr_id;

Line 5094: FROM okc_k_headers_all_b

5090: --also check if it is a service contract
5091: CURSOR c_k_hdr(cp_chr_id IN NUMBER) IS
5092: SELECT contract_number, contract_number_modifier, start_date, end_date,
5093: renewal_type_code, renewal_end_date, currency_code
5094: FROM okc_k_headers_all_b
5095: WHERE id = cp_chr_id AND application_id = 515;
5096:
5097: CURSOR c_renk_hdr(cp_chr_id IN NUMBER) IS
5098: SELECT currency_code, org_id

Line 5099: FROM okc_k_headers_all_b WHERE id = cp_chr_id;

5095: WHERE id = cp_chr_id AND application_id = 515;
5096:
5097: CURSOR c_renk_hdr(cp_chr_id IN NUMBER) IS
5098: SELECT currency_code, org_id
5099: FROM okc_k_headers_all_b WHERE id = cp_chr_id;
5100:
5101:
5102: l_k_num okc_k_headers_b.contract_number%TYPE;
5103: l_k_mod okc_k_headers_b.contract_number_modifier%TYPE;