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 4034: l_k_app_id okc_k_headers_b.application_id%TYPE;

4030: WHERE kl.dnz_chr_id = cp_chr_id AND kl.lse_id IN (7, 8, 9, 10, 11, 13, 25, 35, 46)
4031: AND kl.sts_code = st.ste_code
4032: AND st.ste_code IN ('ACTIVE', 'EXPIRED', 'SIGNED', 'CANCELLED', 'TERMINATED');
4033:
4034: l_k_app_id okc_k_headers_b.application_id%TYPE;
4035: l_k_num okc_k_headers_b.contract_number%TYPE;
4036: l_k_mod okc_k_headers_b.contract_number_modifier%TYPE;
4037: l_k_ste_code okc_statuses_b.ste_code%TYPE;
4038: l_k_ste_meaning okc_statuses_tl.meaning%TYPE;

Line 4035: l_k_num okc_k_headers_b.contract_number%TYPE;

4031: AND kl.sts_code = st.ste_code
4032: AND st.ste_code IN ('ACTIVE', 'EXPIRED', 'SIGNED', 'CANCELLED', 'TERMINATED');
4033:
4034: l_k_app_id okc_k_headers_b.application_id%TYPE;
4035: l_k_num okc_k_headers_b.contract_number%TYPE;
4036: l_k_mod okc_k_headers_b.contract_number_modifier%TYPE;
4037: l_k_ste_code okc_statuses_b.ste_code%TYPE;
4038: l_k_ste_meaning okc_statuses_tl.meaning%TYPE;
4039: l_k_scs_code okc_k_headers_b.scs_code%TYPE;

Line 4036: l_k_mod okc_k_headers_b.contract_number_modifier%TYPE;

4032: AND st.ste_code IN ('ACTIVE', 'EXPIRED', 'SIGNED', 'CANCELLED', 'TERMINATED');
4033:
4034: l_k_app_id okc_k_headers_b.application_id%TYPE;
4035: l_k_num okc_k_headers_b.contract_number%TYPE;
4036: l_k_mod okc_k_headers_b.contract_number_modifier%TYPE;
4037: l_k_ste_code okc_statuses_b.ste_code%TYPE;
4038: l_k_ste_meaning okc_statuses_tl.meaning%TYPE;
4039: l_k_scs_code okc_k_headers_b.scs_code%TYPE;
4040: l_k_template_yn okc_k_headers_b.template_yn%TYPE;

Line 4039: l_k_scs_code okc_k_headers_b.scs_code%TYPE;

4035: l_k_num okc_k_headers_b.contract_number%TYPE;
4036: l_k_mod okc_k_headers_b.contract_number_modifier%TYPE;
4037: l_k_ste_code okc_statuses_b.ste_code%TYPE;
4038: l_k_ste_meaning okc_statuses_tl.meaning%TYPE;
4039: l_k_scs_code okc_k_headers_b.scs_code%TYPE;
4040: l_k_template_yn okc_k_headers_b.template_yn%TYPE;
4041: l_k_date_terminated okc_k_headers_b.date_terminated%TYPE;
4042: l_k_date_renewed okc_k_headers_b.date_renewed%TYPE;
4043: l_k_end_date okc_k_headers_b.end_date%TYPE;

Line 4040: l_k_template_yn okc_k_headers_b.template_yn%TYPE;

4036: l_k_mod okc_k_headers_b.contract_number_modifier%TYPE;
4037: l_k_ste_code okc_statuses_b.ste_code%TYPE;
4038: l_k_ste_meaning okc_statuses_tl.meaning%TYPE;
4039: l_k_scs_code okc_k_headers_b.scs_code%TYPE;
4040: l_k_template_yn okc_k_headers_b.template_yn%TYPE;
4041: l_k_date_terminated okc_k_headers_b.date_terminated%TYPE;
4042: l_k_date_renewed okc_k_headers_b.date_renewed%TYPE;
4043: l_k_end_date okc_k_headers_b.end_date%TYPE;
4044: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;

Line 4041: l_k_date_terminated okc_k_headers_b.date_terminated%TYPE;

4037: l_k_ste_code okc_statuses_b.ste_code%TYPE;
4038: l_k_ste_meaning okc_statuses_tl.meaning%TYPE;
4039: l_k_scs_code okc_k_headers_b.scs_code%TYPE;
4040: l_k_template_yn okc_k_headers_b.template_yn%TYPE;
4041: l_k_date_terminated okc_k_headers_b.date_terminated%TYPE;
4042: l_k_date_renewed okc_k_headers_b.date_renewed%TYPE;
4043: l_k_end_date okc_k_headers_b.end_date%TYPE;
4044: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;
4045:

Line 4042: l_k_date_renewed okc_k_headers_b.date_renewed%TYPE;

4038: l_k_ste_meaning okc_statuses_tl.meaning%TYPE;
4039: l_k_scs_code okc_k_headers_b.scs_code%TYPE;
4040: l_k_template_yn okc_k_headers_b.template_yn%TYPE;
4041: l_k_date_terminated okc_k_headers_b.date_terminated%TYPE;
4042: l_k_date_renewed okc_k_headers_b.date_renewed%TYPE;
4043: l_k_end_date okc_k_headers_b.end_date%TYPE;
4044: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;
4045:
4046: l_date DATE;

Line 4043: l_k_end_date okc_k_headers_b.end_date%TYPE;

4039: l_k_scs_code okc_k_headers_b.scs_code%TYPE;
4040: l_k_template_yn okc_k_headers_b.template_yn%TYPE;
4041: l_k_date_terminated okc_k_headers_b.date_terminated%TYPE;
4042: l_k_date_renewed okc_k_headers_b.date_renewed%TYPE;
4043: l_k_end_date okc_k_headers_b.end_date%TYPE;
4044: l_rnrl_rec OKS_RENEW_UTIL_PVT.rnrl_rec_type;
4045:
4046: l_date DATE;
4047: l_k_num_mod VARCHAR2(250);

Line 4054: l_renk_num okc_k_headers_b.contract_number%TYPE;

4050: l_k_access_level VARCHAR2(1);
4051: l_k_line_id NUMBER;
4052: l_k_ren_type oks_k_defaults.renewal_type%TYPE;
4053:
4054: l_renk_num okc_k_headers_b.contract_number%TYPE;
4055: l_renk_mod okc_k_headers_b.contract_number_modifier%TYPE;
4056: l_renk_ste_code okc_statuses_b.ste_code%TYPE;
4057: l_valid_line_exists BOOLEAN := FALSE;
4058: BEGIN

Line 4055: l_renk_mod okc_k_headers_b.contract_number_modifier%TYPE;

4051: l_k_line_id NUMBER;
4052: l_k_ren_type oks_k_defaults.renewal_type%TYPE;
4053:
4054: l_renk_num okc_k_headers_b.contract_number%TYPE;
4055: l_renk_mod okc_k_headers_b.contract_number_modifier%TYPE;
4056: l_renk_ste_code okc_statuses_b.ste_code%TYPE;
4057: l_valid_line_exists BOOLEAN := FALSE;
4058: BEGIN
4059: --log key input parameters

Line 5107: p_new_contract_number IN okc_k_headers_b.contract_number%TYPE,

5103: p_api_version IN NUMBER,
5104: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5105: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5106: p_chr_id IN NUMBER,
5107: p_new_contract_number IN okc_k_headers_b.contract_number%TYPE,
5108: p_new_contract_modifier IN okc_k_headers_b.contract_number_modifier%TYPE,
5109: p_new_start_date IN DATE,
5110: p_new_end_date IN DATE,
5111: p_new_duration IN NUMBER,

Line 5108: p_new_contract_modifier IN okc_k_headers_b.contract_number_modifier%TYPE,

5104: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5105: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5106: p_chr_id IN NUMBER,
5107: p_new_contract_number IN okc_k_headers_b.contract_number%TYPE,
5108: p_new_contract_modifier IN okc_k_headers_b.contract_number_modifier%TYPE,
5109: p_new_start_date IN DATE,
5110: p_new_end_date IN DATE,
5111: p_new_duration IN NUMBER,
5112: p_new_uom_code IN MTL_UNITS_OF_MEASURE_TL.uom_code%TYPE,

Line 5137: l_k_num okc_k_headers_b.contract_number%TYPE;

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;
5139: l_k_start_date DATE;
5140: l_k_end_date DATE;
5141: l_k_ren_type okc_k_headers_b.renewal_type_code%TYPE;

Line 5138: l_k_mod okc_k_headers_b.contract_number_modifier%TYPE;

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;
5139: l_k_start_date DATE;
5140: l_k_end_date DATE;
5141: l_k_ren_type okc_k_headers_b.renewal_type_code%TYPE;
5142: l_k_renewal_end_date DATE;

Line 5141: l_k_ren_type okc_k_headers_b.renewal_type_code%TYPE;

5137: l_k_num okc_k_headers_b.contract_number%TYPE;
5138: l_k_mod okc_k_headers_b.contract_number_modifier%TYPE;
5139: l_k_start_date DATE;
5140: l_k_end_date DATE;
5141: l_k_ren_type okc_k_headers_b.renewal_type_code%TYPE;
5142: l_k_renewal_end_date DATE;
5143: l_k_currency_code VARCHAR2(15);
5144:
5145: l_validation_level VARCHAR2(1);

Line 5151: l_renk_num okc_k_headers_b.contract_number%TYPE;

5147: l_rnrl_rec_dummy OKS_RENEW_UTIL_PVT.rnrl_rec_type;
5148: l_validation_status VARCHAR2(1);
5149: l_validation_tbl validation_tbl_type;
5150:
5151: l_renk_num okc_k_headers_b.contract_number%TYPE;
5152: l_renk_mod okc_k_headers_b.contract_number_modifier%TYPE;
5153: l_renk_start_date DATE;
5154: l_renk_end_date DATE;
5155: l_renk_currency_code VARCHAR2(15);

Line 5152: l_renk_mod okc_k_headers_b.contract_number_modifier%TYPE;

5148: l_validation_status VARCHAR2(1);
5149: l_validation_tbl validation_tbl_type;
5150:
5151: l_renk_num okc_k_headers_b.contract_number%TYPE;
5152: l_renk_mod okc_k_headers_b.contract_number_modifier%TYPE;
5153: l_renk_start_date DATE;
5154: l_renk_end_date DATE;
5155: l_renk_currency_code VARCHAR2(15);
5156: l_renk_org_id NUMBER;