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_B

Line 21: p_ren_type IN okc_k_headers_b.renewal_type_code%TYPE,

17: p_new_uom_code IN MTL_UNITS_OF_MEASURE_TL.uom_code%TYPE,
18: p_old_start_date IN DATE,
19: p_old_end_date IN DATE,
20: p_renewal_end_date IN DATE,
21: p_ren_type IN okc_k_headers_b.renewal_type_code%TYPE,
22: x_return_status OUT NOCOPY VARCHAR2
23: )RETURN DATE
24: IS
25: l_api_name CONSTANT VARCHAR2(30) := 'GET_END_DATE';

Line 157: bulk operations to maximize performance. Since only start_date and end_date are updated in OKC_K_LINES_B and OKC_K_HEADERS_B, TAPI is ignored. It replaces the existing OKC procedure OKC_RENEW_PVT.update_renewal_dates.

153: /* Internal Procedure
154: This is a new module that will be called for all service contracts after copying the
155: old contract. It will update the new contract header and lines start dates and end dates
156: based on renewal type for the line (Full Duration, Keep Duration, Do not renew). It uses
157: bulk operations to maximize performance. Since only start_date and end_date are updated in OKC_K_LINES_B and OKC_K_HEADERS_B, TAPI is ignored. It replaces the existing OKC procedure OKC_RENEW_PVT.update_renewal_dates.
158:
159: Parameters
160: p_chr_id : id of the renewed contract
161: p_new_start_date : header start date for the renewed contract

Line 3999: l_k_app_id okc_k_headers_b.application_id%TYPE;

3995: WHERE kl.dnz_chr_id = cp_chr_id AND kl.lse_id IN (7, 8, 9, 10, 11, 13, 25, 35, 46)
3996: AND kl.sts_code = st.ste_code
3997: AND st.ste_code IN ('ACTIVE', 'EXPIRED', 'SIGNED', 'CANCELLED', 'TERMINATED');
3998:
3999: l_k_app_id okc_k_headers_b.application_id%TYPE;
4000: l_k_num okc_k_headers_b.contract_number%TYPE;
4001: l_k_mod okc_k_headers_b.contract_number_modifier%TYPE;
4002: l_k_ste_code okc_statuses_b.ste_code%TYPE;
4003: l_k_ste_meaning okc_statuses_tl.meaning%TYPE;

Line 4000: l_k_num okc_k_headers_b.contract_number%TYPE;

3996: AND kl.sts_code = st.ste_code
3997: AND st.ste_code IN ('ACTIVE', 'EXPIRED', 'SIGNED', 'CANCELLED', 'TERMINATED');
3998:
3999: l_k_app_id okc_k_headers_b.application_id%TYPE;
4000: l_k_num okc_k_headers_b.contract_number%TYPE;
4001: l_k_mod okc_k_headers_b.contract_number_modifier%TYPE;
4002: l_k_ste_code okc_statuses_b.ste_code%TYPE;
4003: l_k_ste_meaning okc_statuses_tl.meaning%TYPE;
4004: l_k_scs_code okc_k_headers_b.scs_code%TYPE;

Line 4001: l_k_mod okc_k_headers_b.contract_number_modifier%TYPE;

3997: AND st.ste_code IN ('ACTIVE', 'EXPIRED', 'SIGNED', 'CANCELLED', 'TERMINATED');
3998:
3999: l_k_app_id okc_k_headers_b.application_id%TYPE;
4000: l_k_num okc_k_headers_b.contract_number%TYPE;
4001: l_k_mod okc_k_headers_b.contract_number_modifier%TYPE;
4002: l_k_ste_code okc_statuses_b.ste_code%TYPE;
4003: l_k_ste_meaning okc_statuses_tl.meaning%TYPE;
4004: l_k_scs_code okc_k_headers_b.scs_code%TYPE;
4005: l_k_template_yn okc_k_headers_b.template_yn%TYPE;

Line 4004: l_k_scs_code okc_k_headers_b.scs_code%TYPE;

4000: l_k_num okc_k_headers_b.contract_number%TYPE;
4001: l_k_mod okc_k_headers_b.contract_number_modifier%TYPE;
4002: l_k_ste_code okc_statuses_b.ste_code%TYPE;
4003: l_k_ste_meaning okc_statuses_tl.meaning%TYPE;
4004: l_k_scs_code okc_k_headers_b.scs_code%TYPE;
4005: l_k_template_yn okc_k_headers_b.template_yn%TYPE;
4006: l_k_date_terminated okc_k_headers_b.date_terminated%TYPE;
4007: l_k_date_renewed okc_k_headers_b.date_renewed%TYPE;
4008: l_k_end_date okc_k_headers_b.end_date%TYPE;

Line 4005: l_k_template_yn okc_k_headers_b.template_yn%TYPE;

4001: l_k_mod okc_k_headers_b.contract_number_modifier%TYPE;
4002: l_k_ste_code okc_statuses_b.ste_code%TYPE;
4003: l_k_ste_meaning okc_statuses_tl.meaning%TYPE;
4004: l_k_scs_code okc_k_headers_b.scs_code%TYPE;
4005: l_k_template_yn okc_k_headers_b.template_yn%TYPE;
4006: l_k_date_terminated okc_k_headers_b.date_terminated%TYPE;
4007: l_k_date_renewed okc_k_headers_b.date_renewed%TYPE;
4008: l_k_end_date okc_k_headers_b.end_date%TYPE;
4009: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;

Line 4006: l_k_date_terminated okc_k_headers_b.date_terminated%TYPE;

4002: l_k_ste_code okc_statuses_b.ste_code%TYPE;
4003: l_k_ste_meaning okc_statuses_tl.meaning%TYPE;
4004: l_k_scs_code okc_k_headers_b.scs_code%TYPE;
4005: l_k_template_yn okc_k_headers_b.template_yn%TYPE;
4006: l_k_date_terminated okc_k_headers_b.date_terminated%TYPE;
4007: l_k_date_renewed okc_k_headers_b.date_renewed%TYPE;
4008: l_k_end_date okc_k_headers_b.end_date%TYPE;
4009: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;
4010:

Line 4007: l_k_date_renewed okc_k_headers_b.date_renewed%TYPE;

4003: l_k_ste_meaning okc_statuses_tl.meaning%TYPE;
4004: l_k_scs_code okc_k_headers_b.scs_code%TYPE;
4005: l_k_template_yn okc_k_headers_b.template_yn%TYPE;
4006: l_k_date_terminated okc_k_headers_b.date_terminated%TYPE;
4007: l_k_date_renewed okc_k_headers_b.date_renewed%TYPE;
4008: l_k_end_date okc_k_headers_b.end_date%TYPE;
4009: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;
4010:
4011: l_date DATE;

Line 4008: l_k_end_date okc_k_headers_b.end_date%TYPE;

4004: l_k_scs_code okc_k_headers_b.scs_code%TYPE;
4005: l_k_template_yn okc_k_headers_b.template_yn%TYPE;
4006: l_k_date_terminated okc_k_headers_b.date_terminated%TYPE;
4007: l_k_date_renewed okc_k_headers_b.date_renewed%TYPE;
4008: l_k_end_date okc_k_headers_b.end_date%TYPE;
4009: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;
4010:
4011: l_date DATE;
4012: l_k_num_mod VARCHAR2(250);

Line 4019: l_renk_num okc_k_headers_b.contract_number%TYPE;

4015: l_k_access_level VARCHAR2(1);
4016: l_k_line_id NUMBER;
4017: l_k_ren_type oks_k_defaults.renewal_type%TYPE;
4018:
4019: l_renk_num okc_k_headers_b.contract_number%TYPE;
4020: l_renk_mod okc_k_headers_b.contract_number_modifier%TYPE;
4021: l_renk_ste_code okc_statuses_b.ste_code%TYPE;
4022: l_valid_line_exists BOOLEAN := FALSE;
4023: BEGIN

Line 4020: l_renk_mod okc_k_headers_b.contract_number_modifier%TYPE;

4016: l_k_line_id NUMBER;
4017: l_k_ren_type oks_k_defaults.renewal_type%TYPE;
4018:
4019: l_renk_num okc_k_headers_b.contract_number%TYPE;
4020: l_renk_mod okc_k_headers_b.contract_number_modifier%TYPE;
4021: l_renk_ste_code okc_statuses_b.ste_code%TYPE;
4022: l_valid_line_exists BOOLEAN := FALSE;
4023: BEGIN
4024: --log key input parameters

Line 5072: p_new_contract_number IN okc_k_headers_b.contract_number%TYPE,

5068: p_api_version IN NUMBER,
5069: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5070: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5071: p_chr_id IN NUMBER,
5072: p_new_contract_number IN okc_k_headers_b.contract_number%TYPE,
5073: p_new_contract_modifier IN okc_k_headers_b.contract_number_modifier%TYPE,
5074: p_new_start_date IN DATE,
5075: p_new_end_date IN DATE,
5076: p_new_duration IN NUMBER,

Line 5073: p_new_contract_modifier IN okc_k_headers_b.contract_number_modifier%TYPE,

5069: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5070: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5071: p_chr_id IN NUMBER,
5072: p_new_contract_number IN okc_k_headers_b.contract_number%TYPE,
5073: p_new_contract_modifier IN okc_k_headers_b.contract_number_modifier%TYPE,
5074: p_new_start_date IN DATE,
5075: p_new_end_date IN DATE,
5076: p_new_duration IN NUMBER,
5077: p_new_uom_code IN MTL_UNITS_OF_MEASURE_TL.uom_code%TYPE,

Line 5102: l_k_num okc_k_headers_b.contract_number%TYPE;

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;
5104: l_k_start_date DATE;
5105: l_k_end_date DATE;
5106: l_k_ren_type okc_k_headers_b.renewal_type_code%TYPE;

Line 5103: l_k_mod okc_k_headers_b.contract_number_modifier%TYPE;

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;
5104: l_k_start_date DATE;
5105: l_k_end_date DATE;
5106: l_k_ren_type okc_k_headers_b.renewal_type_code%TYPE;
5107: l_k_renewal_end_date DATE;

Line 5106: l_k_ren_type okc_k_headers_b.renewal_type_code%TYPE;

5102: l_k_num okc_k_headers_b.contract_number%TYPE;
5103: l_k_mod okc_k_headers_b.contract_number_modifier%TYPE;
5104: l_k_start_date DATE;
5105: l_k_end_date DATE;
5106: l_k_ren_type okc_k_headers_b.renewal_type_code%TYPE;
5107: l_k_renewal_end_date DATE;
5108: l_k_currency_code VARCHAR2(15);
5109:
5110: l_validation_level VARCHAR2(1);

Line 5116: l_renk_num okc_k_headers_b.contract_number%TYPE;

5112: l_rnrl_rec_dummy OKS_RENEW_UTIL_PVT.rnrl_rec_type;
5113: l_validation_status VARCHAR2(1);
5114: l_validation_tbl validation_tbl_type;
5115:
5116: l_renk_num okc_k_headers_b.contract_number%TYPE;
5117: l_renk_mod okc_k_headers_b.contract_number_modifier%TYPE;
5118: l_renk_start_date DATE;
5119: l_renk_end_date DATE;
5120: l_renk_currency_code VARCHAR2(15);

Line 5117: l_renk_mod okc_k_headers_b.contract_number_modifier%TYPE;

5113: l_validation_status VARCHAR2(1);
5114: l_validation_tbl validation_tbl_type;
5115:
5116: l_renk_num okc_k_headers_b.contract_number%TYPE;
5117: l_renk_mod okc_k_headers_b.contract_number_modifier%TYPE;
5118: l_renk_start_date DATE;
5119: l_renk_end_date DATE;
5120: l_renk_currency_code VARCHAR2(15);
5121: l_renk_org_id NUMBER;