APPS.OKC_RENEWAL_OUTCOME_PUB dependencies on OKC_K_HEADERS_V

Line 43: l_contract_number okc_k_headers_v.contract_number%type;

39: -- l_renew_in_parameters_rec renew_in_parameters_rec;
40: l_renew_in_parameters_rec OKC_RENEW_PVT.renew_in_parameters_rec;
41:
42: l_contract_id number;
43: l_contract_number okc_k_headers_v.contract_number%type;
44: l_contract_version varchar2(9);
45: l_contract_modifier okc_k_headers_v.contract_number_modifier%type;
46: l_object_version_number number;
47: l_new_contract_number okc_k_headers_v.contract_number%type;

Line 45: l_contract_modifier okc_k_headers_v.contract_number_modifier%type;

41:
42: l_contract_id number;
43: l_contract_number okc_k_headers_v.contract_number%type;
44: l_contract_version varchar2(9);
45: l_contract_modifier okc_k_headers_v.contract_number_modifier%type;
46: l_object_version_number number;
47: l_new_contract_number okc_k_headers_v.contract_number%type;
48: l_new_contract_modifier okc_k_headers_v.contract_number_modifier%type;
49: l_start_date date;

Line 47: l_new_contract_number okc_k_headers_v.contract_number%type;

43: l_contract_number okc_k_headers_v.contract_number%type;
44: l_contract_version varchar2(9);
45: l_contract_modifier okc_k_headers_v.contract_number_modifier%type;
46: l_object_version_number number;
47: l_new_contract_number okc_k_headers_v.contract_number%type;
48: l_new_contract_modifier okc_k_headers_v.contract_number_modifier%type;
49: l_start_date date;
50: l_end_date date;
51: l_new_end_date date;

Line 48: l_new_contract_modifier okc_k_headers_v.contract_number_modifier%type;

44: l_contract_version varchar2(9);
45: l_contract_modifier okc_k_headers_v.contract_number_modifier%type;
46: l_object_version_number number;
47: l_new_contract_number okc_k_headers_v.contract_number%type;
48: l_new_contract_modifier okc_k_headers_v.contract_number_modifier%type;
49: l_start_date date;
50: l_end_date date;
51: l_new_end_date date;
52: l_orig_start_date date;

Line 60: l_default_contract_number okc_k_headers_v.contract_number%type;

56: l_context VARCHAR2(30);
57: l_perpetual_flag VARCHAR2(1);
58:
59:
60: l_default_contract_number okc_k_headers_v.contract_number%type;
61:
62: -- get new start date and end date
63: /* CURSOR c_new_start_date IS
64: SELECT contract_number, end_date + 1, end_date + 1 + (end_date - start_date)

Line 65: FROM okc_k_headers_v

61:
62: -- get new start date and end date
63: /* CURSOR c_new_start_date IS
64: SELECT contract_number, end_date + 1, end_date + 1 + (end_date - start_date)
65: FROM okc_k_headers_v
66: where id = p_contract_id;*/
67: CURSOR c_get_dates IS
68: SELECT contract_number, start_date, end_date
69: FROM okc_k_headers_v

Line 69: FROM okc_k_headers_v

65: FROM okc_k_headers_v
66: where id = p_contract_id;*/
67: CURSOR c_get_dates IS
68: SELECT contract_number, start_date, end_date
69: FROM okc_k_headers_v
70: where id = p_contract_id;
71:
72: BEGIN
73: