eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_DOCLIST_PVT dependencies on OKC_USER_BINS

Line 37: FROM okc_user_bins

33: CURSOR ubl_csr_type (cp_program IN VARCHAR2
34: ,cp_user IN NUMBER
35: ,cp_type IN VARCHAR2 ) IS
36: SELECT id, creation_date, contract_id
37: FROM okc_user_bins
38: WHERE program_name = cp_program
39: AND created_by = cp_user
40: AND bin_type = cp_type
41: ORDER BY creation_date;

Line 43: TYPE id_table_type IS TABLE OF okc_user_bins.id%TYPE INDEX BY BINARY_INTEGER;

39: AND created_by = cp_user
40: AND bin_type = cp_type
41: ORDER BY creation_date;
42:
43: TYPE id_table_type IS TABLE OF okc_user_bins.id%TYPE INDEX BY BINARY_INTEGER;
44: TYPE cdate_tbl_type IS TABLE OF okc_user_bins.creation_date%TYPE INDEX BY BINARY_INTEGER;
45: TYPE cid_tbl_type IS TABLE OF okc_user_bins.contract_id%TYPE INDEX BY BINARY_INTEGER;
46:
47: l_api_name VARCHAR2(20) := 'PROCESS_ROW';

Line 44: TYPE cdate_tbl_type IS TABLE OF okc_user_bins.creation_date%TYPE INDEX BY BINARY_INTEGER;

40: AND bin_type = cp_type
41: ORDER BY creation_date;
42:
43: TYPE id_table_type IS TABLE OF okc_user_bins.id%TYPE INDEX BY BINARY_INTEGER;
44: TYPE cdate_tbl_type IS TABLE OF okc_user_bins.creation_date%TYPE INDEX BY BINARY_INTEGER;
45: TYPE cid_tbl_type IS TABLE OF okc_user_bins.contract_id%TYPE INDEX BY BINARY_INTEGER;
46:
47: l_api_name VARCHAR2(20) := 'PROCESS_ROW';
48: l_dups_deleted NUMBER := 0;

Line 45: TYPE cid_tbl_type IS TABLE OF okc_user_bins.contract_id%TYPE INDEX BY BINARY_INTEGER;

41: ORDER BY creation_date;
42:
43: TYPE id_table_type IS TABLE OF okc_user_bins.id%TYPE INDEX BY BINARY_INTEGER;
44: TYPE cdate_tbl_type IS TABLE OF okc_user_bins.creation_date%TYPE INDEX BY BINARY_INTEGER;
45: TYPE cid_tbl_type IS TABLE OF okc_user_bins.contract_id%TYPE INDEX BY BINARY_INTEGER;
46:
47: l_api_name VARCHAR2(20) := 'PROCESS_ROW';
48: l_dups_deleted NUMBER := 0;
49: l_fifos_deleted NUMBER := 0;

Line 234: -- DESCRIPTION: Adds a recent document row (type R) to the okc_user_bins table --

230:
231: --
232: -- ---------------------------------------------------------------------------------
233: -- PROCEDURE: Add_Recent --
234: -- DESCRIPTION: Adds a recent document row (type R) to the okc_user_bins table --
235: -- using the record passed --
236: -- DEPENDENCIES: none --
237: -- CHANGE HISTORY: --
238: -- 12/aug/99 - created --

Line 248: ,p_program_name IN OKC_USER_BINS.program_name%TYPE

244: ,p_contract_number IN OKC_K_HEADERS_B.contract_number%TYPE
245: ,p_contract_type IN OKC_K_HEADERS_B.chr_type%TYPE
246: ,p_contract_modifier IN OKC_K_HEADERS_B.contract_number_modifier%TYPE
247: ,p_short_description IN OKC_K_HEADERS_TL.short_description%TYPE
248: ,p_program_name IN OKC_USER_BINS.program_name%TYPE
249: ,x_return_status OUT NOCOPY VARCHAR2
250: ,x_msg_count OUT NOCOPY NUMBER
251: ,x_msg_data OUT NOCOPY VARCHAR2 )
252: IS

Line 322: -- okc_user_bins using the row record passed --

318: --
319: -- ---------------------------------------------------------------------------------
320: -- PROCEDURE: Add_Bookmark --
321: -- DESCRIPTION: Inserts a row for a bookmarked contract (Type B) into --
322: -- okc_user_bins using the row record passed --
323: -- DEPENDENCIES: none --
324: -- CHANGE HISTORY: --
325: -- 12/aug/99 - created --
326: -- --

Line 419: p_ubl_id IN OKC_USER_BINS.id%TYPE

415: -- --
416: -- ---------------------------------------------------------------------------------
417: --
418: PROCEDURE delete_entry (
419: p_ubl_id IN OKC_USER_BINS.id%TYPE
420: ,x_return_status OUT NOCOPY VARCHAR2
421: ,x_msg_count OUT NOCOPY NUMBER
422: ,x_msg_data OUT NOCOPY VARCHAR2 )
423: IS