APPS.OKC_CHANGE_CONTRACT_PVT dependencies on OKC_K_PROCESSES

Line 110: OKC_K_PROCESSES cpr,

106: U.USER_NAME AUTH_USERNAME,
107: C.AUTHORITY REQUESTOR,
108: C.SIGNATURE_REQUIRED_YN
109: from okc_change_requests_v C,
110: OKC_K_PROCESSES cpr,
111: OKC_K_HDR_AGREEDS_V K,
112: fnd_user_view U
113: where C.ID = p_change_request_id
114: and K.ID = C.CHR_ID

Line 127: from okc_k_processes KP,

123: l_process_id number;
124: --
125: cursor process_def_csr is
126: select PDF.ID, PDF.WF_NAME, PDF.WF_PROCESS_NAME, PDF.USAGE
127: from okc_k_processes KP,
128: OKC_PROCESS_DEFS_B PDF
129: where KP.crt_id = p_change_request_id
130: and PDF.ID = KP.PDF_ID
131: and PDF.begin_date<=sysdate

Line 148: from okc_k_processes

144: -- because of bug in lock API
145: --
146: cursor k_pid is
147: select ID,OBJECT_VERSION_NUMBER
148: from okc_k_processes
149: where CRT_ID = p_change_request_id
150: for update of process_id nowait;
151: --
152: --

Line 944: OKC_K_PROCESSES P

940: cursor in_use_csr is
941: select '!'
942: from
943: OKC_CHANGE_REQUESTS_B C,
944: OKC_K_PROCESSES P
945: where C.chr_id = (select chr_id from OKC_CHANGE_REQUESTS_B
946: where id = p_change_request_id)
947: and C.ID <> p_change_request_id
948: and C.datetime_applied is NULL

Line 953: select id,object_version_number from OKC_K_PROCESSES

949: and P.crt_id = C.id
950: and P.in_process_yn = 'Y';
951: --
952: cursor process_csr is
953: select id,object_version_number from OKC_K_PROCESSES
954: where crt_id = p_change_request_id;
955: begin
956: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
957: G_PKG_NAME,

Line 1078: select id,object_version_number from OKC_K_PROCESSES

1074: l_cpsv_rec OKC_CONTRACT_PUB.cpsv_rec_type;
1075: l1_cpsv_rec OKC_CONTRACT_PUB.cpsv_rec_type;
1076: --
1077: cursor process_csr is
1078: select id,object_version_number from OKC_K_PROCESSES
1079: where crt_id = p_change_request_id;
1080: begin
1081: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
1082: G_PKG_NAME,