[Home] [Help]
PACKAGE: APPS.HRI_BPL_CONC_LOG
Source
1 PACKAGE hri_bpl_conc_log AS
2 /* $Header: hribcncl.pkh 120.3 2005/11/24 05:23:33 jtitmas noship $ */
3 --
4 -- Global type for passing lists of table columns
5 --
6 TYPE col_list_rec_type IS RECORD
7 (column_value VARCHAR2(240),
8 column_length PLS_INTEGER);
9
10 TYPE col_list_tab_type IS TABLE OF col_list_rec_type
11 INDEX BY BINARY_INTEGER;
12
13 g_empty_col_list col_list_tab_type;
14 --
15 -- Global varibale to store a row in the process log table
16 --
17 g_msg_log_record hri_adm_msg_log%rowtype;
18 --
19 FUNCTION get_last_collect_to_date
20 (p_process_code IN VARCHAR2
21 ,p_table_name IN VARCHAR2
22 )
23 RETURN VARCHAR2;
24 --
25 PROCEDURE delete_process_log( p_process_code IN VARCHAR2 );
26 --
27 -- Generic output procedure
28 --
29 PROCEDURE output(p_text IN VARCHAR2,
30 p_mode IN VARCHAR2,
31 p_line_type IN VARCHAR2,
32 p_col_list IN col_list_tab_type DEFAULT g_empty_col_list,
33 p_format IN VARCHAR2 DEFAULT null);
34 --
35 -- Procedure to store row in concurrent program log
36 --
37 PROCEDURE output(p_text VARCHAR2);
38 --
39 -- Procedure to store row in concurrent program log if debug is enabled
40 --
41 PROCEDURE dbg(p_text VARCHAR2);
42 --
43 -- Procedure to store the the process start information
44 --
45 PROCEDURE record_process_start(p_process_code IN VARCHAR2);
46 --
47 PROCEDURE log_process_info
48 (p_msg_type VARCHAR2
49 ,p_package_name VARCHAR2 DEFAULT NULL
50 ,p_msg_group VARCHAR2 DEFAULT NULL
51 ,p_msg_sub_group VARCHAR2 DEFAULT NULL
52 ,p_sql_err_code VARCHAR2 DEFAULT NULL
53 ,p_note VARCHAR2 DEFAULT NULL
54 ,p_effective_date DATE DEFAULT TRUNC(SYSDATE)
55 ,p_assignment_id NUMBER DEFAULT NULL
56 ,p_person_id NUMBER DEFAULT NULL
57 ,p_job_id NUMBER DEFAULT NULL
58 ,p_location_id NUMBER DEFAULT NULL
59 ,p_event_id NUMBER DEFAULT NULL
60 ,p_supervisor_id NUMBER DEFAULT NULL
61 ,p_person_type_id NUMBER DEFAULT NULL
62 ,p_formula_id NUMBER DEFAULT NULL
63 ,p_other_ref_id NUMBER DEFAULT NULL
64 ,p_other_ref_column VARCHAR2 DEFAULT NULL
65 ,p_fnd_msg_name VARCHAR2 DEFAULT NULL
66 );
67 --
68 PROCEDURE flush_process_info(p_package_name IN VARCHAR2);
69 --
70 PROCEDURE log_process_end
71 (p_status IN BOOLEAN
72 ,p_count IN NUMBER DEFAULT 0
73 ,p_message IN VARCHAR2 DEFAULT NULL
74 ,p_period_from IN DATE DEFAULT to_date(NULL)
75 ,p_period_to IN DATE DEFAULT to_date(NULL)
76 ,p_attribute1 IN VARCHAR2 DEFAULT NULL
77 ,p_attribute2 IN VARCHAR2 DEFAULT NULL
78 ,p_attribute3 IN VARCHAR2 DEFAULT NULL
79 ,p_attribute4 IN VARCHAR2 DEFAULT NULL
80 ,p_attribute5 IN VARCHAR2 DEFAULT NULL
81 ,p_attribute6 IN VARCHAR2 DEFAULT NULL
82 ,p_attribute7 IN VARCHAR2 DEFAULT NULL
83 ,p_attribute8 IN VARCHAR2 DEFAULT NULL
84 ,p_attribute9 IN VARCHAR2 DEFAULT NULL
85 ,p_attribute10 IN VARCHAR2 DEFAULT NULL
86 --
87 -- New parameters for bug fix 4043240
88 --
89 ,p_process_type IN VARCHAR2 DEFAULT NULL
90 ,p_package_name IN VARCHAR2 DEFAULT NULL
91 ,p_full_refresh IN VARCHAR2 DEFAULT NULL
92 ,p_attribute11 IN VARCHAR2 DEFAULT NULL
93 ,p_attribute12 IN VARCHAR2 DEFAULT NULL
94 ,p_attribute13 IN VARCHAR2 DEFAULT NULL
95 ,p_attribute14 IN VARCHAR2 DEFAULT NULL
96 ,p_attribute15 IN VARCHAR2 DEFAULT NULL
97 ,p_attribute16 IN VARCHAR2 DEFAULT NULL
98 ,p_attribute17 IN VARCHAR2 DEFAULT NULL
99 ,p_attribute18 IN VARCHAR2 DEFAULT NULL
100 ,p_attribute19 IN VARCHAR2 DEFAULT NULL
101 ,p_attribute20 IN VARCHAR2 DEFAULT NULL
102 );
103 --
104 PROCEDURE obsoleted_message(errbuf OUT NOCOPY VARCHAR2,
105 retcode OUT NOCOPY VARCHAR2);
106 --
107 END hri_bpl_conc_log;