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.PQH_PROCESS_BATCH_LOG dependencies on PQH_PROCESS_LOG

Line 7: ( txn_id pqh_process_log.txn_id%TYPE,

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,

Line 8: txn_table_route_id pqh_process_log.txn_table_route_id%TYPE,

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)

Line 10: log_context pqh_process_log.log_context%TYPE DEFAULT NULL,

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:

Line 11: process_log_id pqh_process_log.process_log_id%TYPE,

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

Line 24: g_batch_id pqh_process_log.txn_id%TYPE;

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:

Line 25: g_module_cd pqh_process_log.module_cd%TYPE;

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:

Line 26: g_master_process_log_id pqh_process_log.master_process_log_id%TYPE;

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

Line 32: p_batch_id IN pqh_process_log.txn_id%TYPE,

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,

Line 33: p_module_cd IN pqh_process_log.module_cd%TYPE,

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,

Line 34: p_log_context IN pqh_process_log.log_context%TYPE DEFAULT NULL,

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,

Line 35: p_information_category IN pqh_process_log.information_category%TYPE DEFAULT NULL,

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,

Line 36: p_information1 IN pqh_process_log.information1%TYPE DEFAULT NULL,

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,

Line 37: p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,

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,

Line 38: p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,

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,

Line 39: p_information4 IN pqh_process_log.information1%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,

Line 40: p_information5 IN pqh_process_log.information1%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,

Line 41: p_information6 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,

Line 42: p_information7 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,

Line 43: p_information8 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,

Line 44: p_information9 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,

Line 45: p_information10 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,

Line 46: p_information11 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,

Line 47: p_information12 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,

Line 48: p_information13 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,

Line 49: p_information14 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,

Line 50: p_information15 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,

Line 51: p_information16 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,

Line 52: p_information17 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,

Line 53: p_information18 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,

Line 54: p_information19 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,

Line 55: p_information20 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,

Line 56: p_information21 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,

Line 57: p_information22 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,

Line 58: p_information23 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,

Line 59: p_information24 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,

Line 60: p_information25 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,

Line 61: p_information26 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

Line 62: p_information27 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: );

Line 63: p_information28 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:

Line 64: p_information29 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

Line 65: p_information30 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: (

Line 70: p_message_type_cd IN pqh_process_log.message_type_cd%TYPE,

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,

Line 71: p_message_text IN pqh_process_log.message_text%TYPE,

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,

Line 72: p_information_category IN pqh_process_log.information_category%TYPE DEFAULT NULL,

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,

Line 73: p_information1 IN pqh_process_log.information1%TYPE DEFAULT NULL,

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,

Line 74: p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,

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,

Line 75: p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,

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,

Line 76: p_information4 IN pqh_process_log.information1%TYPE DEFAULT NULL,

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,

Line 77: p_information5 IN pqh_process_log.information1%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,

Line 78: p_information6 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,

Line 79: p_information7 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,

Line 80: p_information8 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,

Line 81: p_information9 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,

Line 82: p_information10 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,

Line 83: p_information11 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,

Line 84: p_information12 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,

Line 85: p_information13 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,

Line 86: p_information14 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,

Line 87: p_information15 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,

Line 88: p_information16 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,

Line 89: p_information17 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,

Line 90: p_information18 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,

Line 91: p_information19 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,

Line 92: p_information20 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,

Line 93: p_information21 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,

Line 94: p_information22 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,

Line 95: p_information23 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,

Line 96: p_information24 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,

Line 97: p_information25 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,

Line 98: p_information26 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

Line 99: p_information27 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: );

Line 100: p_information28 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:

Line 101: p_information29 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

Line 102: p_information30 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: (

Line 107: p_txn_id IN pqh_process_log.txn_id%TYPE,

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: );

Line 108: p_txn_table_route_id IN pqh_process_log.txn_table_route_id%TYPE,

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:

Line 110: p_log_context IN pqh_process_log.log_context%TYPE DEFAULT NULL

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:

Line 119: END; -- Package Specification PQH_PROCESS_LOG

115:
116:
117:
118:
119: END; -- Package Specification PQH_PROCESS_LOG