APPS.OKS_RENEW_CONTRACT_PVT dependencies on OKS_K_HEADERS_B

Line 1026: UPDATE oks_k_headers_b h

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))
1024: WHERE h.id = p_chr_id;
1025:
1026: UPDATE oks_k_headers_b h
1027: SET h.tax_amount =
1028: (SELECT sum(stl.tax_amount) FROM okc_k_lines_b ctl, oks_k_lines_b stl
1029: WHERE ctl.dnz_chr_id = p_chr_id AND ctl.cle_id IS NULL
1030: AND ctl.lse_id IN (1,12,19,46) AND stl.cle_id = ctl.id)

Line 2950: oks_k_headers_b rens, oks_k_headers_b olds

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
2954: AND olds.chr_id = old.id;

Line 2961: l_new_period_type oks_k_headers_b.period_type%TYPE;

2957: l_new_end_date DATE;
2958: l_old_start_date DATE;
2959: l_old_end_date DATE;
2960: l_old_chr_id NUMBER;
2961: l_new_period_type oks_k_headers_b.period_type%TYPE;
2962: l_new_period_start oks_k_headers_b.period_start%TYPE;
2963: l_old_period_type oks_k_headers_b.period_type%TYPE;
2964: l_old_period_start oks_k_headers_b.period_start%TYPE;
2965:

Line 2962: l_new_period_start oks_k_headers_b.period_start%TYPE;

2958: l_old_start_date DATE;
2959: l_old_end_date DATE;
2960: l_old_chr_id NUMBER;
2961: l_new_period_type oks_k_headers_b.period_type%TYPE;
2962: l_new_period_start oks_k_headers_b.period_start%TYPE;
2963: l_old_period_type oks_k_headers_b.period_type%TYPE;
2964: l_old_period_start oks_k_headers_b.period_start%TYPE;
2965:
2966: l_new_duration NUMBER;

Line 2963: l_old_period_type oks_k_headers_b.period_type%TYPE;

2959: l_old_end_date DATE;
2960: l_old_chr_id NUMBER;
2961: l_new_period_type oks_k_headers_b.period_type%TYPE;
2962: l_new_period_start oks_k_headers_b.period_start%TYPE;
2963: l_old_period_type oks_k_headers_b.period_type%TYPE;
2964: l_old_period_start oks_k_headers_b.period_start%TYPE;
2965:
2966: l_new_duration NUMBER;
2967: l_new_period VARCHAR2(64);

Line 2964: l_old_period_start oks_k_headers_b.period_start%TYPE;

2960: l_old_chr_id NUMBER;
2961: l_new_period_type oks_k_headers_b.period_type%TYPE;
2962: l_new_period_start oks_k_headers_b.period_start%TYPE;
2963: l_old_period_type oks_k_headers_b.period_type%TYPE;
2964: l_old_period_start oks_k_headers_b.period_start%TYPE;
2965:
2966: l_new_duration NUMBER;
2967: l_new_period VARCHAR2(64);
2968: l_old_duration NUMBER;

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 3713: UPDATE oks_k_headers_b

3709:
3710:
3711:
3712: --update oks with the new attributes
3713: UPDATE oks_k_headers_b
3714: SET renewal_status = l_renewal_status,
3715: acct_rule_id = Nvl(acct_id,acct_rule_id), --added for bug 9020536
3716: est_rev_percent = l_est_rev_percent,
3717: est_rev_date = l_est_rev_date,