APPS.OKL_CURE_REQUEST_PVT dependencies on OKL_CURE_REPORTS

Line 36: l_request_date okl_cure_reports.report_date%TYPE := TRUNC(SYSDATE);

32: l_content_id JTF_AMV_ITEMS_B.ITEM_ID%TYPE;
33: l_from VARCHAR2(2000);
34: l_agent_id NUMBER;
35: l_request_id NUMBER;
36: l_request_date okl_cure_reports.report_date%TYPE := TRUNC(SYSDATE);
37: l_request_number okl_cure_reports.report_number%TYPE;
38:
39: l_organization_passed VARCHAR2(1) := OKL_API.G_TRUE;
40: l_set_of_books_passed VARCHAR2(1) := OKL_API.G_TRUE;

Line 37: l_request_number okl_cure_reports.report_number%TYPE;

33: l_from VARCHAR2(2000);
34: l_agent_id NUMBER;
35: l_request_id NUMBER;
36: l_request_date okl_cure_reports.report_date%TYPE := TRUNC(SYSDATE);
37: l_request_number okl_cure_reports.report_number%TYPE;
38:
39: l_organization_passed VARCHAR2(1) := OKL_API.G_TRUE;
40: l_set_of_books_passed VARCHAR2(1) := OKL_API.G_TRUE;
41: l_vendor_passed VARCHAR2(1) := OKL_API.G_TRUE;

Line 47: subtype crtv_rec_type is OKL_cure_reports_pub.crtv_rec_type;

43:
44: l_current_date DATE;
45: l_msg_index_out NUMBER :=0;
46:
47: subtype crtv_rec_type is OKL_cure_reports_pub.crtv_rec_type;
48: l_crtv_rec crtv_rec_type;
49: lx_crtv_rec crtv_rec_type;
50:
51: -- Get Report Data for Fulfilment

Line 63: FROM OKL_cure_reports crt

59: ,crt.report_number
60: ,crt.cure_report_id
61: ,crt.object_version_number
62: ,crt.report_type
63: FROM OKL_cure_reports crt
64: ,po_vendor_sites_all pvs
65: WHERE trunc(crt.report_date) = NVL(l_report_date , trunc(crt.report_date))
66: AND crt.report_number = NVL(l_request_number, crt.report_number)
67: AND crt.vendor_id = NVL(l_vendor_id,crt.vendor_id)

Line 188: OKL_cure_reports_pub.update_cure_reports(

184: l_crtv_rec.approval_status :='SENT_TO_VENDOR';
185: l_crtv_rec.cure_report_id :=i.cure_report_id;
186: l_crtv_rec.object_version_number := i.object_version_number;
187:
188: OKL_cure_reports_pub.update_cure_reports(
189: p_api_version => l_api_version
190: ,p_init_msg_list => okl_api.G_TRUE
191: ,x_return_status => l_return_status
192: ,x_msg_count => l_msg_count