[Home] [Help]
PACKAGE: APPS.PQH_PROCESS_BATCH_LOG
Source
1 PACKAGE pqh_process_batch_log AUTHID CURRENT_USER AS
2 /* $Header: pqerrlog.pkh 115.4 2003/10/10 05:40:28 vevenkat ship $ */
3
4 -- record
5
6 TYPE t_log_struct_type IS RECORD
7 ( txn_id pqh_process_log.txn_id%TYPE,
8 txn_table_route_id pqh_process_log.txn_table_route_id%TYPE,
9 level NUMBER,
10 log_context pqh_process_log.log_context%TYPE DEFAULT NULL,
11 process_log_id pqh_process_log.process_log_id%TYPE,
12 insert_flag VARCHAR2(10)
13 );
14
15 -- PL/SQL based on the above structure
16
17 TYPE t_log_tab IS TABLE OF t_log_struct_type
18 INDEX BY BINARY_INTEGER;
19
20 -- global variables for the PL/SQL table of record defined above
21 g_log_tab t_log_tab;
22
23 -- global variables
24 g_batch_id pqh_process_log.txn_id%TYPE;
25 g_module_cd pqh_process_log.module_cd%TYPE;
26 g_master_process_log_id pqh_process_log.master_process_log_id%TYPE;
27
28
29
30 PROCEDURE start_log
31 (
32 p_batch_id IN pqh_process_log.txn_id%TYPE,
33 p_module_cd IN pqh_process_log.module_cd%TYPE,
34 p_log_context IN pqh_process_log.log_context%TYPE DEFAULT NULL,
35 p_information_category IN pqh_process_log.information_category%TYPE DEFAULT NULL,
36 p_information1 IN pqh_process_log.information1%TYPE DEFAULT NULL,
37 p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,
38 p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,
39 p_information4 IN pqh_process_log.information1%TYPE DEFAULT NULL,
40 p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,
41 p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,
42 p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,
43 p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,
44 p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,
45 p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,
46 p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,
47 p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,
48 p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,
49 p_information14 IN pqh_process_log.information1%TYPE DEFAULT NULL,
50 p_information15 IN pqh_process_log.information1%TYPE DEFAULT NULL,
51 p_information16 IN pqh_process_log.information1%TYPE DEFAULT NULL,
52 p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,
53 p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,
54 p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,
55 p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,
56 p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,
57 p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,
58 p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,
59 p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,
60 p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,
61 p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,
62 p_information27 IN pqh_process_log.information1%TYPE DEFAULT NULL,
63 p_information28 IN pqh_process_log.information1%TYPE DEFAULT NULL,
64 p_information29 IN pqh_process_log.information1%TYPE DEFAULT NULL,
65 p_information30 IN pqh_process_log.information1%TYPE DEFAULT NULL
66 );
67
68 PROCEDURE insert_log
69 (
70 p_message_type_cd IN pqh_process_log.message_type_cd%TYPE,
71 p_message_text IN pqh_process_log.message_text%TYPE,
72 p_information_category IN pqh_process_log.information_category%TYPE DEFAULT NULL,
73 p_information1 IN pqh_process_log.information1%TYPE DEFAULT NULL,
74 p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,
75 p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,
76 p_information4 IN pqh_process_log.information1%TYPE DEFAULT NULL,
77 p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,
78 p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,
79 p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,
80 p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,
81 p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,
82 p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,
83 p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,
84 p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,
85 p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,
86 p_information14 IN pqh_process_log.information1%TYPE DEFAULT NULL,
87 p_information15 IN pqh_process_log.information1%TYPE DEFAULT NULL,
88 p_information16 IN pqh_process_log.information1%TYPE DEFAULT NULL,
89 p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,
90 p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,
91 p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,
92 p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,
93 p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,
94 p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,
95 p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,
96 p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,
97 p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,
98 p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,
99 p_information27 IN pqh_process_log.information1%TYPE DEFAULT NULL,
100 p_information28 IN pqh_process_log.information1%TYPE DEFAULT NULL,
101 p_information29 IN pqh_process_log.information1%TYPE DEFAULT NULL,
102 p_information30 IN pqh_process_log.information1%TYPE DEFAULT NULL
103 );
104
105 PROCEDURE set_context_level
106 (
107 p_txn_id IN pqh_process_log.txn_id%TYPE,
108 p_txn_table_route_id IN pqh_process_log.txn_table_route_id%TYPE,
109 p_level IN NUMBER,
110 p_log_context IN pqh_process_log.log_context%TYPE DEFAULT NULL
111 );
112
113 PROCEDURE end_log ;
114
115
116
117
118
119 END; -- Package Specification PQH_PROCESS_LOG