APPS.OKL_REQ_WF dependencies on OKL_CURE_REPORTS

Line 28: FROM OKL_CURE_REPORTS

24: -- Get Report data
25: CURSOR get_request_csr
26: IS
27: SELECT cure_report_id
28: FROM OKL_CURE_REPORTS
29: WHERE approval_status='COMPLETE';
30:
31:
32: BEGIN

Line 122: FROM OKL_CURE_REPORTS

118:
119: CURSOR report_dtls_csr (a_trans_id NUMBER)
120: IS
121: SELECT REPORT_NUMBER,REPORT_DATE,VENDOR_ID,VENDOR_CONTACT_ID,VENDOR_SITE_ID,CREATED_BY
122: FROM OKL_CURE_REPORTS
123: WHERE CURE_REPORT_ID= a_trans_id;
124:
125: CURSOR vendor_csr (a_vendor_id NUMBER)
126: IS

Line 162: FROM OKL_CURE_REPORTS

158: WHERE b.source_id = a.source_mgr_id
159: AND a.user_id
160: IN
161: (SELECT created_by
162: FROM OKL_CURE_REPORTS
163: WHERE CURE_REPORT_ID = a_trans_id);
164:
165: BEGIN
166: IF (funcmode = 'RUN') then

Line 289: FROM OKL_CURE_REPORTS

285:
286: CURSOR approval_csr (a_trans_id NUMBER)
287: IS
288: SELECT REPORT_NUMBER,REPORT_DATE,VENDOR_ID,OBJECT_VERSION_NUMBER
289: FROM OKL_CURE_REPORTS
290: WHERE CURE_REPORT_ID= a_trans_id;
291:
292:
293: BEGIN

Line 313: OKL_cure_reports_pub.update_cure_reports(

309: l_crtv_rec.VENDOR_ID := l_vendor_id ;
310: l_crtv_rec.REPORT_DATE := l_date ;
311:
312: --Now inserting the populated table of records above
313: OKL_cure_reports_pub.update_cure_reports(
314: p_api_version => l_api_version
315: ,p_init_msg_list => fnd_api.g_false
316: ,x_return_status => l_return_status
317: ,x_msg_count => l_msg_count

Line 378: FROM OKL_CURE_REPORTS

374:
375: CURSOR approval_csr (a_trans_id NUMBER)
376: IS
377: SELECT REPORT_NUMBER,REPORT_DATE,VENDOR_ID,OBJECT_VERSION_NUMBER
378: FROM OKL_CURE_REPORTS
379: WHERE CURE_REPORT_ID= a_trans_id;
380:
381:
382: BEGIN

Line 402: OKL_cure_reports_pub.update_cure_reports(

398: l_crtv_rec.REPORT_DATE := l_date ;
399:
400:
401: --Now inserting the populated table of records above
402: OKL_cure_reports_pub.update_cure_reports(
403: p_api_version => l_api_version
404: ,p_init_msg_list => fnd_api.g_false
405: ,x_return_status => l_return_status
406: ,x_msg_count => l_msg_count