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 19: p_batch_id IN pqh_process_log.txn_id%TYPE,

15: ------------------------------------------------------------------*/
16:
17: PROCEDURE start_log
18: (
19: p_batch_id IN pqh_process_log.txn_id%TYPE,
20: p_module_cd IN pqh_process_log.module_cd%TYPE,
21: p_log_context IN pqh_process_log.log_context%TYPE,
22: p_information_category IN pqh_process_log.information_category%TYPE DEFAULT NULL,
23: p_information1 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 20: p_module_cd IN pqh_process_log.module_cd%TYPE,

16:
17: PROCEDURE start_log
18: (
19: p_batch_id IN pqh_process_log.txn_id%TYPE,
20: p_module_cd IN pqh_process_log.module_cd%TYPE,
21: p_log_context IN pqh_process_log.log_context%TYPE,
22: p_information_category IN pqh_process_log.information_category%TYPE DEFAULT NULL,
23: p_information1 IN pqh_process_log.information1%TYPE DEFAULT NULL,
24: p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 21: p_log_context IN pqh_process_log.log_context%TYPE,

17: PROCEDURE start_log
18: (
19: p_batch_id IN pqh_process_log.txn_id%TYPE,
20: p_module_cd IN pqh_process_log.module_cd%TYPE,
21: p_log_context IN pqh_process_log.log_context%TYPE,
22: p_information_category IN pqh_process_log.information_category%TYPE DEFAULT NULL,
23: p_information1 IN pqh_process_log.information1%TYPE DEFAULT NULL,
24: p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,
25: p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,

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

18: (
19: p_batch_id IN pqh_process_log.txn_id%TYPE,
20: p_module_cd IN pqh_process_log.module_cd%TYPE,
21: p_log_context IN pqh_process_log.log_context%TYPE,
22: p_information_category IN pqh_process_log.information_category%TYPE DEFAULT NULL,
23: p_information1 IN pqh_process_log.information1%TYPE DEFAULT NULL,
24: p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,
25: p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,
26: p_information4 IN pqh_process_log.information1%TYPE DEFAULT NULL,

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

19: p_batch_id IN pqh_process_log.txn_id%TYPE,
20: p_module_cd IN pqh_process_log.module_cd%TYPE,
21: p_log_context IN pqh_process_log.log_context%TYPE,
22: p_information_category IN pqh_process_log.information_category%TYPE DEFAULT NULL,
23: p_information1 IN pqh_process_log.information1%TYPE DEFAULT NULL,
24: p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,
25: p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,
26: p_information4 IN pqh_process_log.information1%TYPE DEFAULT NULL,
27: p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,

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

20: p_module_cd IN pqh_process_log.module_cd%TYPE,
21: p_log_context IN pqh_process_log.log_context%TYPE,
22: p_information_category IN pqh_process_log.information_category%TYPE DEFAULT NULL,
23: p_information1 IN pqh_process_log.information1%TYPE DEFAULT NULL,
24: p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,
25: p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,
26: p_information4 IN pqh_process_log.information1%TYPE DEFAULT NULL,
27: p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,
28: p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,

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

21: p_log_context IN pqh_process_log.log_context%TYPE,
22: p_information_category IN pqh_process_log.information_category%TYPE DEFAULT NULL,
23: p_information1 IN pqh_process_log.information1%TYPE DEFAULT NULL,
24: p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,
25: p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,
26: p_information4 IN pqh_process_log.information1%TYPE DEFAULT NULL,
27: p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,
28: p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,
29: p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,

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

22: p_information_category IN pqh_process_log.information_category%TYPE DEFAULT NULL,
23: p_information1 IN pqh_process_log.information1%TYPE DEFAULT NULL,
24: p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,
25: p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,
26: p_information4 IN pqh_process_log.information1%TYPE DEFAULT NULL,
27: p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,
28: p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,
29: p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,
30: p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 27: p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,

23: p_information1 IN pqh_process_log.information1%TYPE DEFAULT NULL,
24: p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,
25: p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,
26: p_information4 IN pqh_process_log.information1%TYPE DEFAULT NULL,
27: p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,
28: p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,
29: p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,
30: p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,
31: p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 28: p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,

24: p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,
25: p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,
26: p_information4 IN pqh_process_log.information1%TYPE DEFAULT NULL,
27: p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,
28: p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,
29: p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,
30: p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,
31: p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,
32: p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 29: p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,

25: p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,
26: p_information4 IN pqh_process_log.information1%TYPE DEFAULT NULL,
27: p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,
28: p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,
29: p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,
30: p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,
31: p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,
32: p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,
33: p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 30: p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,

26: p_information4 IN pqh_process_log.information1%TYPE DEFAULT NULL,
27: p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,
28: p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,
29: p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,
30: p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,
31: p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,
32: p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,
33: p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,
34: p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 31: p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,

27: p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,
28: p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,
29: p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,
30: p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,
31: p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,
32: p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,
33: p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,
34: p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,
35: p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 32: p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,

28: p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,
29: p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,
30: p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,
31: p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,
32: p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,
33: p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,
34: p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,
35: p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,
36: p_information14 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 33: p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,

29: p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,
30: p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,
31: p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,
32: p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,
33: p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,
34: p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,
35: p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,
36: p_information14 IN pqh_process_log.information1%TYPE DEFAULT NULL,
37: p_information15 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 34: p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,

30: p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,
31: p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,
32: p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,
33: p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,
34: p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,
35: p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,
36: p_information14 IN pqh_process_log.information1%TYPE DEFAULT NULL,
37: p_information15 IN pqh_process_log.information1%TYPE DEFAULT NULL,
38: p_information16 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 35: p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,

31: p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,
32: p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,
33: p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,
34: p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,
35: p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,
36: p_information14 IN pqh_process_log.information1%TYPE DEFAULT NULL,
37: p_information15 IN pqh_process_log.information1%TYPE DEFAULT NULL,
38: p_information16 IN pqh_process_log.information1%TYPE DEFAULT NULL,
39: p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,

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

32: p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,
33: p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,
34: p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,
35: p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,
36: p_information14 IN pqh_process_log.information1%TYPE DEFAULT NULL,
37: p_information15 IN pqh_process_log.information1%TYPE DEFAULT NULL,
38: p_information16 IN pqh_process_log.information1%TYPE DEFAULT NULL,
39: p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,
40: p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,

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

33: p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,
34: p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,
35: p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,
36: p_information14 IN pqh_process_log.information1%TYPE DEFAULT NULL,
37: p_information15 IN pqh_process_log.information1%TYPE DEFAULT NULL,
38: p_information16 IN pqh_process_log.information1%TYPE DEFAULT NULL,
39: p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,
40: p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,
41: p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,

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

34: p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,
35: p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,
36: p_information14 IN pqh_process_log.information1%TYPE DEFAULT NULL,
37: p_information15 IN pqh_process_log.information1%TYPE DEFAULT NULL,
38: p_information16 IN pqh_process_log.information1%TYPE DEFAULT NULL,
39: p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,
40: p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,
41: p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,
42: p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 39: p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,

35: p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,
36: p_information14 IN pqh_process_log.information1%TYPE DEFAULT NULL,
37: p_information15 IN pqh_process_log.information1%TYPE DEFAULT NULL,
38: p_information16 IN pqh_process_log.information1%TYPE DEFAULT NULL,
39: p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,
40: p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,
41: p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,
42: p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,
43: p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 40: p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,

36: p_information14 IN pqh_process_log.information1%TYPE DEFAULT NULL,
37: p_information15 IN pqh_process_log.information1%TYPE DEFAULT NULL,
38: p_information16 IN pqh_process_log.information1%TYPE DEFAULT NULL,
39: p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,
40: p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,
41: p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,
42: p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,
43: p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,
44: p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 41: p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,

37: p_information15 IN pqh_process_log.information1%TYPE DEFAULT NULL,
38: p_information16 IN pqh_process_log.information1%TYPE DEFAULT NULL,
39: p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,
40: p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,
41: p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,
42: p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,
43: p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,
44: p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,
45: p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 42: p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,

38: p_information16 IN pqh_process_log.information1%TYPE DEFAULT NULL,
39: p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,
40: p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,
41: p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,
42: p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,
43: p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,
44: p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,
45: p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,
46: p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 43: p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,

39: p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,
40: p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,
41: p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,
42: p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,
43: p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,
44: p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,
45: p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,
46: p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,
47: p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 44: p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,

40: p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,
41: p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,
42: p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,
43: p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,
44: p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,
45: p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,
46: p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,
47: p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,
48: p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 45: p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,

41: p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,
42: p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,
43: p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,
44: p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,
45: p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,
46: p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,
47: p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,
48: p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,
49: p_information27 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 46: p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,

42: p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,
43: p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,
44: p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,
45: p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,
46: p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,
47: p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,
48: p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,
49: p_information27 IN pqh_process_log.information1%TYPE DEFAULT NULL,
50: p_information28 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 47: p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,

43: p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,
44: p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,
45: p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,
46: p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,
47: p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,
48: p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,
49: p_information27 IN pqh_process_log.information1%TYPE DEFAULT NULL,
50: p_information28 IN pqh_process_log.information1%TYPE DEFAULT NULL,
51: p_information29 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 48: p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,

44: p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,
45: p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,
46: p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,
47: p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,
48: p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,
49: p_information27 IN pqh_process_log.information1%TYPE DEFAULT NULL,
50: p_information28 IN pqh_process_log.information1%TYPE DEFAULT NULL,
51: p_information29 IN pqh_process_log.information1%TYPE DEFAULT NULL,
52: p_information30 IN pqh_process_log.information1%TYPE DEFAULT NULL

Line 49: p_information27 IN pqh_process_log.information1%TYPE DEFAULT NULL,

45: p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,
46: p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,
47: p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,
48: p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,
49: p_information27 IN pqh_process_log.information1%TYPE DEFAULT NULL,
50: p_information28 IN pqh_process_log.information1%TYPE DEFAULT NULL,
51: p_information29 IN pqh_process_log.information1%TYPE DEFAULT NULL,
52: p_information30 IN pqh_process_log.information1%TYPE DEFAULT NULL
53: ) IS

Line 50: p_information28 IN pqh_process_log.information1%TYPE DEFAULT NULL,

46: p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,
47: p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,
48: p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,
49: p_information27 IN pqh_process_log.information1%TYPE DEFAULT NULL,
50: p_information28 IN pqh_process_log.information1%TYPE DEFAULT NULL,
51: p_information29 IN pqh_process_log.information1%TYPE DEFAULT NULL,
52: p_information30 IN pqh_process_log.information1%TYPE DEFAULT NULL
53: ) IS
54: --

Line 51: p_information29 IN pqh_process_log.information1%TYPE DEFAULT NULL,

47: p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,
48: p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,
49: p_information27 IN pqh_process_log.information1%TYPE DEFAULT NULL,
50: p_information28 IN pqh_process_log.information1%TYPE DEFAULT NULL,
51: p_information29 IN pqh_process_log.information1%TYPE DEFAULT NULL,
52: p_information30 IN pqh_process_log.information1%TYPE DEFAULT NULL
53: ) IS
54: --
55: -- local variables

Line 52: p_information30 IN pqh_process_log.information1%TYPE DEFAULT NULL

48: p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,
49: p_information27 IN pqh_process_log.information1%TYPE DEFAULT NULL,
50: p_information28 IN pqh_process_log.information1%TYPE DEFAULT NULL,
51: p_information29 IN pqh_process_log.information1%TYPE DEFAULT NULL,
52: p_information30 IN pqh_process_log.information1%TYPE DEFAULT NULL
53: ) IS
54: --
55: -- local variables
56: --

Line 58: l_process_log_id pqh_process_log.process_log_id%TYPE;

54: --
55: -- local variables
56: --
57: l_proc varchar2(72) := g_package||'start_log';
58: l_process_log_id pqh_process_log.process_log_id%TYPE;
59: l_object_version_number pqh_process_log.object_version_number%TYPE;
60: PRAGMA AUTONOMOUS_TRANSACTION;
61:
62:

Line 59: l_object_version_number pqh_process_log.object_version_number%TYPE;

55: -- local variables
56: --
57: l_proc varchar2(72) := g_package||'start_log';
58: l_process_log_id pqh_process_log.process_log_id%TYPE;
59: l_object_version_number pqh_process_log.object_version_number%TYPE;
60: PRAGMA AUTONOMOUS_TRANSACTION;
61:
62:
63:

Line 81: -- delete all records for this batch from pqh_process_log table

77: -- initialize the pl / sql table
78:
79: g_log_tab.DELETE;
80:
81: -- delete all records for this batch from pqh_process_log table
82: -- this is a tree structure so delete the entire tree below the batch_id
83:
84: DELETE FROM pqh_process_log
85: WHERE process_log_id IN

Line 84: DELETE FROM pqh_process_log

80:
81: -- delete all records for this batch from pqh_process_log table
82: -- this is a tree structure so delete the entire tree below the batch_id
83:
84: DELETE FROM pqh_process_log
85: WHERE process_log_id IN
86: ( SELECT process_log_id
87: FROM pqh_process_log
88: START WITH master_process_log_id IS NULL

Line 87: FROM pqh_process_log

83:
84: DELETE FROM pqh_process_log
85: WHERE process_log_id IN
86: ( SELECT process_log_id
87: FROM pqh_process_log
88: START WITH master_process_log_id IS NULL
89: AND txn_id = g_batch_id
90: AND module_cd = g_module_cd
91: CONNECT BY PRIOR process_log_id = master_process_log_id

Line 96: insert start record in pqh_process_log with message_type_cd = 'START'

92: );
93:
94:
95: /*
96: insert start record in pqh_process_log with message_type_cd = 'START'
97: */
98: -- Insert API call
99: pqh_process_log_api.create_process_log
100: (

Line 99: pqh_process_log_api.create_process_log

95: /*
96: insert start record in pqh_process_log with message_type_cd = 'START'
97: */
98: -- Insert API call
99: pqh_process_log_api.create_process_log
100: (
101: p_validate => false
102: ,p_process_log_id => l_process_log_id
103: ,p_module_cd => g_module_cd

Line 187: p_message_type_cd IN pqh_process_log.message_type_cd%TYPE,

183: ------------------------------------------------------------------*/
184:
185: PROCEDURE insert_log
186: (
187: p_message_type_cd IN pqh_process_log.message_type_cd%TYPE,
188: p_message_text IN pqh_process_log.message_text%TYPE,
189: p_information_category IN pqh_process_log.information_category%TYPE DEFAULT NULL,
190: p_information1 IN pqh_process_log.information1%TYPE DEFAULT NULL,
191: p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 188: p_message_text IN pqh_process_log.message_text%TYPE,

184:
185: PROCEDURE insert_log
186: (
187: p_message_type_cd IN pqh_process_log.message_type_cd%TYPE,
188: p_message_text IN pqh_process_log.message_text%TYPE,
189: p_information_category IN pqh_process_log.information_category%TYPE DEFAULT NULL,
190: p_information1 IN pqh_process_log.information1%TYPE DEFAULT NULL,
191: p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,
192: p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,

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

185: PROCEDURE insert_log
186: (
187: p_message_type_cd IN pqh_process_log.message_type_cd%TYPE,
188: p_message_text IN pqh_process_log.message_text%TYPE,
189: p_information_category IN pqh_process_log.information_category%TYPE DEFAULT NULL,
190: p_information1 IN pqh_process_log.information1%TYPE DEFAULT NULL,
191: p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,
192: p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,
193: p_information4 IN pqh_process_log.information1%TYPE DEFAULT NULL,

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

186: (
187: p_message_type_cd IN pqh_process_log.message_type_cd%TYPE,
188: p_message_text IN pqh_process_log.message_text%TYPE,
189: p_information_category IN pqh_process_log.information_category%TYPE DEFAULT NULL,
190: p_information1 IN pqh_process_log.information1%TYPE DEFAULT NULL,
191: p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,
192: p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,
193: p_information4 IN pqh_process_log.information1%TYPE DEFAULT NULL,
194: p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,

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

187: p_message_type_cd IN pqh_process_log.message_type_cd%TYPE,
188: p_message_text IN pqh_process_log.message_text%TYPE,
189: p_information_category IN pqh_process_log.information_category%TYPE DEFAULT NULL,
190: p_information1 IN pqh_process_log.information1%TYPE DEFAULT NULL,
191: p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,
192: p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,
193: p_information4 IN pqh_process_log.information1%TYPE DEFAULT NULL,
194: p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,
195: p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,

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

188: p_message_text IN pqh_process_log.message_text%TYPE,
189: p_information_category IN pqh_process_log.information_category%TYPE DEFAULT NULL,
190: p_information1 IN pqh_process_log.information1%TYPE DEFAULT NULL,
191: p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,
192: p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,
193: p_information4 IN pqh_process_log.information1%TYPE DEFAULT NULL,
194: p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,
195: p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,
196: p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,

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

189: p_information_category IN pqh_process_log.information_category%TYPE DEFAULT NULL,
190: p_information1 IN pqh_process_log.information1%TYPE DEFAULT NULL,
191: p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,
192: p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,
193: p_information4 IN pqh_process_log.information1%TYPE DEFAULT NULL,
194: p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,
195: p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,
196: p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,
197: p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 194: p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,

190: p_information1 IN pqh_process_log.information1%TYPE DEFAULT NULL,
191: p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,
192: p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,
193: p_information4 IN pqh_process_log.information1%TYPE DEFAULT NULL,
194: p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,
195: p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,
196: p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,
197: p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,
198: p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 195: p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,

191: p_information2 IN pqh_process_log.information1%TYPE DEFAULT NULL,
192: p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,
193: p_information4 IN pqh_process_log.information1%TYPE DEFAULT NULL,
194: p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,
195: p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,
196: p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,
197: p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,
198: p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,
199: p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 196: p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,

192: p_information3 IN pqh_process_log.information1%TYPE DEFAULT NULL,
193: p_information4 IN pqh_process_log.information1%TYPE DEFAULT NULL,
194: p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,
195: p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,
196: p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,
197: p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,
198: p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,
199: p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,
200: p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 197: p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,

193: p_information4 IN pqh_process_log.information1%TYPE DEFAULT NULL,
194: p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,
195: p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,
196: p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,
197: p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,
198: p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,
199: p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,
200: p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,
201: p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 198: p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,

194: p_information5 IN pqh_process_log.information1%TYPE DEFAULT NULL,
195: p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,
196: p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,
197: p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,
198: p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,
199: p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,
200: p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,
201: p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,
202: p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 199: p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,

195: p_information6 IN pqh_process_log.information1%TYPE DEFAULT NULL,
196: p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,
197: p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,
198: p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,
199: p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,
200: p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,
201: p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,
202: p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,
203: p_information14 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 200: p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,

196: p_information7 IN pqh_process_log.information1%TYPE DEFAULT NULL,
197: p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,
198: p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,
199: p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,
200: p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,
201: p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,
202: p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,
203: p_information14 IN pqh_process_log.information1%TYPE DEFAULT NULL,
204: p_information15 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 201: p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,

197: p_information8 IN pqh_process_log.information1%TYPE DEFAULT NULL,
198: p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,
199: p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,
200: p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,
201: p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,
202: p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,
203: p_information14 IN pqh_process_log.information1%TYPE DEFAULT NULL,
204: p_information15 IN pqh_process_log.information1%TYPE DEFAULT NULL,
205: p_information16 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 202: p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,

198: p_information9 IN pqh_process_log.information1%TYPE DEFAULT NULL,
199: p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,
200: p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,
201: p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,
202: p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,
203: p_information14 IN pqh_process_log.information1%TYPE DEFAULT NULL,
204: p_information15 IN pqh_process_log.information1%TYPE DEFAULT NULL,
205: p_information16 IN pqh_process_log.information1%TYPE DEFAULT NULL,
206: p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 203: p_information14 IN pqh_process_log.information1%TYPE DEFAULT NULL,

199: p_information10 IN pqh_process_log.information1%TYPE DEFAULT NULL,
200: p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,
201: p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,
202: p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,
203: p_information14 IN pqh_process_log.information1%TYPE DEFAULT NULL,
204: p_information15 IN pqh_process_log.information1%TYPE DEFAULT NULL,
205: p_information16 IN pqh_process_log.information1%TYPE DEFAULT NULL,
206: p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,
207: p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 204: p_information15 IN pqh_process_log.information1%TYPE DEFAULT NULL,

200: p_information11 IN pqh_process_log.information1%TYPE DEFAULT NULL,
201: p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,
202: p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,
203: p_information14 IN pqh_process_log.information1%TYPE DEFAULT NULL,
204: p_information15 IN pqh_process_log.information1%TYPE DEFAULT NULL,
205: p_information16 IN pqh_process_log.information1%TYPE DEFAULT NULL,
206: p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,
207: p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,
208: p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 205: p_information16 IN pqh_process_log.information1%TYPE DEFAULT NULL,

201: p_information12 IN pqh_process_log.information1%TYPE DEFAULT NULL,
202: p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,
203: p_information14 IN pqh_process_log.information1%TYPE DEFAULT NULL,
204: p_information15 IN pqh_process_log.information1%TYPE DEFAULT NULL,
205: p_information16 IN pqh_process_log.information1%TYPE DEFAULT NULL,
206: p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,
207: p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,
208: p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,
209: p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 206: p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,

202: p_information13 IN pqh_process_log.information1%TYPE DEFAULT NULL,
203: p_information14 IN pqh_process_log.information1%TYPE DEFAULT NULL,
204: p_information15 IN pqh_process_log.information1%TYPE DEFAULT NULL,
205: p_information16 IN pqh_process_log.information1%TYPE DEFAULT NULL,
206: p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,
207: p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,
208: p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,
209: p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,
210: p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 207: p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,

203: p_information14 IN pqh_process_log.information1%TYPE DEFAULT NULL,
204: p_information15 IN pqh_process_log.information1%TYPE DEFAULT NULL,
205: p_information16 IN pqh_process_log.information1%TYPE DEFAULT NULL,
206: p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,
207: p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,
208: p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,
209: p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,
210: p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,
211: p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 208: p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,

204: p_information15 IN pqh_process_log.information1%TYPE DEFAULT NULL,
205: p_information16 IN pqh_process_log.information1%TYPE DEFAULT NULL,
206: p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,
207: p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,
208: p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,
209: p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,
210: p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,
211: p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,
212: p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 209: p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,

205: p_information16 IN pqh_process_log.information1%TYPE DEFAULT NULL,
206: p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,
207: p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,
208: p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,
209: p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,
210: p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,
211: p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,
212: p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,
213: p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 210: p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,

206: p_information17 IN pqh_process_log.information1%TYPE DEFAULT NULL,
207: p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,
208: p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,
209: p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,
210: p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,
211: p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,
212: p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,
213: p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,
214: p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 211: p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,

207: p_information18 IN pqh_process_log.information1%TYPE DEFAULT NULL,
208: p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,
209: p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,
210: p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,
211: p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,
212: p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,
213: p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,
214: p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,
215: p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 212: p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,

208: p_information19 IN pqh_process_log.information1%TYPE DEFAULT NULL,
209: p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,
210: p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,
211: p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,
212: p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,
213: p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,
214: p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,
215: p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,
216: p_information27 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 213: p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,

209: p_information20 IN pqh_process_log.information1%TYPE DEFAULT NULL,
210: p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,
211: p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,
212: p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,
213: p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,
214: p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,
215: p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,
216: p_information27 IN pqh_process_log.information1%TYPE DEFAULT NULL,
217: p_information28 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 214: p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,

210: p_information21 IN pqh_process_log.information1%TYPE DEFAULT NULL,
211: p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,
212: p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,
213: p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,
214: p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,
215: p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,
216: p_information27 IN pqh_process_log.information1%TYPE DEFAULT NULL,
217: p_information28 IN pqh_process_log.information1%TYPE DEFAULT NULL,
218: p_information29 IN pqh_process_log.information1%TYPE DEFAULT NULL,

Line 215: p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,

211: p_information22 IN pqh_process_log.information1%TYPE DEFAULT NULL,
212: p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,
213: p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,
214: p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,
215: p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,
216: p_information27 IN pqh_process_log.information1%TYPE DEFAULT NULL,
217: p_information28 IN pqh_process_log.information1%TYPE DEFAULT NULL,
218: p_information29 IN pqh_process_log.information1%TYPE DEFAULT NULL,
219: p_information30 IN pqh_process_log.information1%TYPE DEFAULT NULL

Line 216: p_information27 IN pqh_process_log.information1%TYPE DEFAULT NULL,

212: p_information23 IN pqh_process_log.information1%TYPE DEFAULT NULL,
213: p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,
214: p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,
215: p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,
216: p_information27 IN pqh_process_log.information1%TYPE DEFAULT NULL,
217: p_information28 IN pqh_process_log.information1%TYPE DEFAULT NULL,
218: p_information29 IN pqh_process_log.information1%TYPE DEFAULT NULL,
219: p_information30 IN pqh_process_log.information1%TYPE DEFAULT NULL
220: ) IS

Line 217: p_information28 IN pqh_process_log.information1%TYPE DEFAULT NULL,

213: p_information24 IN pqh_process_log.information1%TYPE DEFAULT NULL,
214: p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,
215: p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,
216: p_information27 IN pqh_process_log.information1%TYPE DEFAULT NULL,
217: p_information28 IN pqh_process_log.information1%TYPE DEFAULT NULL,
218: p_information29 IN pqh_process_log.information1%TYPE DEFAULT NULL,
219: p_information30 IN pqh_process_log.information1%TYPE DEFAULT NULL
220: ) IS
221:

Line 218: p_information29 IN pqh_process_log.information1%TYPE DEFAULT NULL,

214: p_information25 IN pqh_process_log.information1%TYPE DEFAULT NULL,
215: p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,
216: p_information27 IN pqh_process_log.information1%TYPE DEFAULT NULL,
217: p_information28 IN pqh_process_log.information1%TYPE DEFAULT NULL,
218: p_information29 IN pqh_process_log.information1%TYPE DEFAULT NULL,
219: p_information30 IN pqh_process_log.information1%TYPE DEFAULT NULL
220: ) IS
221:
222: /*

Line 219: p_information30 IN pqh_process_log.information1%TYPE DEFAULT NULL

215: p_information26 IN pqh_process_log.information1%TYPE DEFAULT NULL,
216: p_information27 IN pqh_process_log.information1%TYPE DEFAULT NULL,
217: p_information28 IN pqh_process_log.information1%TYPE DEFAULT NULL,
218: p_information29 IN pqh_process_log.information1%TYPE DEFAULT NULL,
219: p_information30 IN pqh_process_log.information1%TYPE DEFAULT NULL
220: ) IS
221:
222: /*
223: Before inserting we check if row is already existing as the same node may have been

Line 230: l_txn_id pqh_process_log.txn_id%TYPE;

226: --
227: -- local variables
228: --
229: l_proc varchar2(72) := g_package||'insert_log';
230: l_txn_id pqh_process_log.txn_id%TYPE;
231: l_log_context pqh_process_log.log_context%TYPE;
232: l_txn_table_route_id pqh_process_log.txn_table_route_id%TYPE;
233: l_process_log_id pqh_process_log.process_log_id%TYPE;
234: l_master_process_log_id pqh_process_log.master_process_log_id%TYPE;

Line 231: l_log_context pqh_process_log.log_context%TYPE;

227: -- local variables
228: --
229: l_proc varchar2(72) := g_package||'insert_log';
230: l_txn_id pqh_process_log.txn_id%TYPE;
231: l_log_context pqh_process_log.log_context%TYPE;
232: l_txn_table_route_id pqh_process_log.txn_table_route_id%TYPE;
233: l_process_log_id pqh_process_log.process_log_id%TYPE;
234: l_master_process_log_id pqh_process_log.master_process_log_id%TYPE;
235: l_object_version_number pqh_process_log.object_version_number%TYPE;

Line 232: l_txn_table_route_id pqh_process_log.txn_table_route_id%TYPE;

228: --
229: l_proc varchar2(72) := g_package||'insert_log';
230: l_txn_id pqh_process_log.txn_id%TYPE;
231: l_log_context pqh_process_log.log_context%TYPE;
232: l_txn_table_route_id pqh_process_log.txn_table_route_id%TYPE;
233: l_process_log_id pqh_process_log.process_log_id%TYPE;
234: l_master_process_log_id pqh_process_log.master_process_log_id%TYPE;
235: l_object_version_number pqh_process_log.object_version_number%TYPE;
236: l_current_level NUMBER := 0;

Line 233: l_process_log_id pqh_process_log.process_log_id%TYPE;

229: l_proc varchar2(72) := g_package||'insert_log';
230: l_txn_id pqh_process_log.txn_id%TYPE;
231: l_log_context pqh_process_log.log_context%TYPE;
232: l_txn_table_route_id pqh_process_log.txn_table_route_id%TYPE;
233: l_process_log_id pqh_process_log.process_log_id%TYPE;
234: l_master_process_log_id pqh_process_log.master_process_log_id%TYPE;
235: l_object_version_number pqh_process_log.object_version_number%TYPE;
236: l_current_level NUMBER := 0;
237: l_message_text pqh_process_log.message_text%TYPE;

Line 234: l_master_process_log_id pqh_process_log.master_process_log_id%TYPE;

230: l_txn_id pqh_process_log.txn_id%TYPE;
231: l_log_context pqh_process_log.log_context%TYPE;
232: l_txn_table_route_id pqh_process_log.txn_table_route_id%TYPE;
233: l_process_log_id pqh_process_log.process_log_id%TYPE;
234: l_master_process_log_id pqh_process_log.master_process_log_id%TYPE;
235: l_object_version_number pqh_process_log.object_version_number%TYPE;
236: l_current_level NUMBER := 0;
237: l_message_text pqh_process_log.message_text%TYPE;
238: l_message_type_cd pqh_process_log.message_type_cd%TYPE;

Line 235: l_object_version_number pqh_process_log.object_version_number%TYPE;

231: l_log_context pqh_process_log.log_context%TYPE;
232: l_txn_table_route_id pqh_process_log.txn_table_route_id%TYPE;
233: l_process_log_id pqh_process_log.process_log_id%TYPE;
234: l_master_process_log_id pqh_process_log.master_process_log_id%TYPE;
235: l_object_version_number pqh_process_log.object_version_number%TYPE;
236: l_current_level NUMBER := 0;
237: l_message_text pqh_process_log.message_text%TYPE;
238: l_message_type_cd pqh_process_log.message_type_cd%TYPE;
239: l_row_exists varchar2(10) := 'N';

Line 237: l_message_text pqh_process_log.message_text%TYPE;

233: l_process_log_id pqh_process_log.process_log_id%TYPE;
234: l_master_process_log_id pqh_process_log.master_process_log_id%TYPE;
235: l_object_version_number pqh_process_log.object_version_number%TYPE;
236: l_current_level NUMBER := 0;
237: l_message_text pqh_process_log.message_text%TYPE;
238: l_message_type_cd pqh_process_log.message_type_cd%TYPE;
239: l_row_exists varchar2(10) := 'N';
240: l_curr_process_log_id pqh_process_log.process_log_id%TYPE;
241: PRAGMA AUTONOMOUS_TRANSACTION;

Line 238: l_message_type_cd pqh_process_log.message_type_cd%TYPE;

234: l_master_process_log_id pqh_process_log.master_process_log_id%TYPE;
235: l_object_version_number pqh_process_log.object_version_number%TYPE;
236: l_current_level NUMBER := 0;
237: l_message_text pqh_process_log.message_text%TYPE;
238: l_message_type_cd pqh_process_log.message_type_cd%TYPE;
239: l_row_exists varchar2(10) := 'N';
240: l_curr_process_log_id pqh_process_log.process_log_id%TYPE;
241: PRAGMA AUTONOMOUS_TRANSACTION;
242:

Line 240: l_curr_process_log_id pqh_process_log.process_log_id%TYPE;

236: l_current_level NUMBER := 0;
237: l_message_text pqh_process_log.message_text%TYPE;
238: l_message_type_cd pqh_process_log.message_type_cd%TYPE;
239: l_row_exists varchar2(10) := 'N';
240: l_curr_process_log_id pqh_process_log.process_log_id%TYPE;
241: PRAGMA AUTONOMOUS_TRANSACTION;
242:
243: CURSOR csr_row_exists(p_txn_id IN number) is
244: SELECT 'Y', process_log_id

Line 245: FROM pqh_process_log

241: PRAGMA AUTONOMOUS_TRANSACTION;
242:
243: CURSOR csr_row_exists(p_txn_id IN number) is
244: SELECT 'Y', process_log_id
245: FROM pqh_process_log
246: WHERE txn_id = p_txn_id
247: AND master_process_log_id IS NOT NULL
248: START WITH master_process_log_id IS NULL
249: AND txn_id = g_batch_id

Line 297: pqh_process_log_api.create_process_log

293: l_message_text := p_message_text;
294: l_message_type_cd := p_message_type_cd;
295:
296: -- Insert API call
297: pqh_process_log_api.create_process_log
298: (
299: p_validate => false
300: ,p_process_log_id => l_process_log_id
301: ,p_module_cd => g_module_cd

Line 350: pqh_process_log_api.create_process_log

346: l_message_text := 'No error';
347: l_message_type_cd := 'COMPLETE';
348:
349: -- Insert API call
350: pqh_process_log_api.create_process_log
351: (
352: p_validate => false
353: ,p_process_log_id => l_process_log_id
354: ,p_module_cd => g_module_cd

Line 402: pqh_process_log_api.create_process_log

398: END IF;
399:
400: /*
401: -- Insert API call
402: pqh_process_log_api.create_process_log
403: (
404: p_validate => false
405: ,p_process_log_id => l_process_log_id
406: ,p_module_cd => g_module_cd

Line 507: p_txn_id IN pqh_process_log.txn_id%TYPE,

503: ------------------------------------------------------------------*/
504:
505: PROCEDURE set_context_level
506: (
507: p_txn_id IN pqh_process_log.txn_id%TYPE,
508: p_txn_table_route_id IN pqh_process_log.txn_table_route_id%TYPE,
509: p_level IN NUMBER,
510: p_log_context IN pqh_process_log.log_context%TYPE DEFAULT NULL
511: ) IS

Line 508: p_txn_table_route_id IN pqh_process_log.txn_table_route_id%TYPE,

504:
505: PROCEDURE set_context_level
506: (
507: p_txn_id IN pqh_process_log.txn_id%TYPE,
508: p_txn_table_route_id IN pqh_process_log.txn_table_route_id%TYPE,
509: p_level IN NUMBER,
510: p_log_context IN pqh_process_log.log_context%TYPE DEFAULT NULL
511: ) IS
512: --

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

506: (
507: p_txn_id IN pqh_process_log.txn_id%TYPE,
508: p_txn_table_route_id IN pqh_process_log.txn_table_route_id%TYPE,
509: p_level IN NUMBER,
510: p_log_context IN pqh_process_log.log_context%TYPE DEFAULT NULL
511: ) IS
512: --
513: -- local variables
514: --

Line 584: FROM pqh_process_log

580: PRAGMA AUTONOMOUS_TRANSACTION;
581:
582: CURSOR csr_status (p_message_type_cd IN VARCHAR2 ) IS
583: SELECT COUNT(*)
584: FROM pqh_process_log
585: WHERE message_type_cd = p_message_type_cd
586: START WITH master_process_log_id IS NULL AND txn_id = g_batch_id AND module_cd = g_module_cd
587: CONNECT BY PRIOR process_log_id = master_process_log_id;
588:

Line 635: UPDATE pqh_process_log

631: update the 'start' record for this batch with message_type_cd = 'COMPLETE' and
632: update the batch_end_date with current date time
633: */
634:
635: UPDATE pqh_process_log
636: SET message_type_cd = 'COMPLETE',
637: message_text = fnd_message.get_string('PQH','PQH_PROCESS_COMPLETED'),
638: batch_status = l_status,
639: batch_end_date = sysdate