APPS.OKC_CHANGE_REQUEST_PVT dependencies on OKC_CHANGE_REQUESTS_V

Line 53: select '!' from okc_change_requests_v

49:
50: l_dummy varchar2(1);
51:
52: cursor chk_dup_cr_csr is
53: select '!' from okc_change_requests_v
54: where chr_id = p_crtv_rec.chr_id
55: and name = p_crtv_rec.name
56: and datetime_applied is null;
57:

Line 145: p_token1_value => 'OKC_CHANGE_REQUESTS_V',

141: if (l_dummy = '!') then
142: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
143: p_msg_name => G_CHILD_RECORD_FOUND,
144: p_token1 => G_PARENT_TABLE_TOKEN,
145: p_token1_value => 'OKC_CHANGE_REQUESTS_V',
146: p_token2 => G_CHILD_TABLE_TOKEN,
147: p_token2_value => 'OKC_CHANGES_V');
148: x_return_status := OKC_API.G_RET_STS_ERROR;
149: return;

Line 160: p_token1_value => 'OKC_CHANGE_REQUESTS_V',

156: if (l_dummy = '!') then
157: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
158: p_msg_name => G_CHILD_RECORD_FOUND,
159: p_token1 => G_PARENT_TABLE_TOKEN,
160: p_token1_value => 'OKC_CHANGE_REQUESTS_V',
161: p_token2 => G_CHILD_TABLE_TOKEN,
162: p_token2_value => 'OKC_CHANGE_PARTY_ROLE_V');
163: x_return_status := OKC_API.G_RET_STS_ERROR;
164: return;

Line 198: from okc_change_requests_v

194: l_crtv_rec OKC_CHANGE_REQUEST_PUB.crtv_rec_type;
195:
196: Cursor cur_crt_details is
197: select id,name,chr_id,crs_code,datetime_applied,object_version_number
198: from okc_change_requests_v
199: where id = p_crtv_rec.id;
200:
201: cursor key_csr is
202: select substr(CONTRACT_NUMBER||CONTRACT_NUMBER_MODIFIER||l_crtv_rec.NAME,1,240) key

Line 385: OKC_CHANGE_REQUESTS_V C,

381: cursor key_csr is
382: select C.crs_code,
383: substr(K.CONTRACT_NUMBER||K.CONTRACT_NUMBER_MODIFIER||C.NAME,1,240) key
384: from
385: OKC_CHANGE_REQUESTS_V C,
386: OKC_K_HDR_AGREEDS_V K
387: where C.ID = p_corv_rec.CRT_ID
388: and K.ID = C.chr_id;
389: --