APPS.OKC_KEXP_PVT dependencies on OKC_KEXP_REPORT

Line 12: TYPE okc_kexp_report_tbl_type IS

8: x_return_status OUT NOCOPY VARCHAR2,
9: x_report_id OUT NOCOPY NUMBER )
10: IS
11: -- Collection table definition
12: TYPE okc_kexp_report_tbl_type IS
13: TABLE OF ROWID INDEX BY BINARY_INTEGER;
14: okc_kexp_pls_tbl okc_kexp_report_tbl_type;
15:
16: -- Ref Cursor to concatenate with the where clause from KSEARCH form.

Line 14: okc_kexp_pls_tbl okc_kexp_report_tbl_type;

10: IS
11: -- Collection table definition
12: TYPE okc_kexp_report_tbl_type IS
13: TABLE OF ROWID INDEX BY BINARY_INTEGER;
14: okc_kexp_pls_tbl okc_kexp_report_tbl_type;
15:
16: -- Ref Cursor to concatenate with the where clause from KSEARCH form.
17: TYPE okc_kexp_cur_type IS REF CURSOR;
18: okc_kexp_cur okc_kexp_cur_type;

Line 32: SELECT okc_kexp_report_s1.NEXTVAL

28:
29: -- -------------------------------------------------------------------
30: -- Assign Sequence number for this search criteria based call.
31: -- -------------------------------------------------------------------
32: SELECT okc_kexp_report_s1.NEXTVAL
33: INTO l_report_seq
34: FROM dual;
35:
36: -- --------------------------------------------------------------------

Line 76: INTO OKC_KEXP_REPORT

72: -- Bulk Insert into Temp Table
73: -- ------------------------------------------------------
74: FORALL i IN okc_kexp_pls_tbl.FIRST .. okc_kexp_pls_tbl.LAST
75: INSERT
76: INTO OKC_KEXP_REPORT
77: (
78: CONTRACT_HEADER_ROWID,
79: REPORT_ID,
80: REPORT_DATE )

Line 140: DELETE FROM okc_kexp_report

136: -- ------------------------------------------------------
137: IF p_from_date <= p_to_date
138: THEN
139:
140: DELETE FROM okc_kexp_report
141: WHERE report_date
142: BETWEEN p_from_date AND p_to_date;
143:
144: -- --------------------------------------------------