APPS.OZF_DENORM_QUERIES_PVT_W dependencies on FND_API

Line 15: , p4_a1 VARCHAR2 := fnd_api.g_miss_char

11: , x_msg_count OUT NOCOPY NUMBER
12: , x_msg_data OUT NOCOPY VARCHAR2
13: , x_denorm_query_id OUT NOCOPY NUMBER
14: , p4_a0 NUMBER := 0-1962.0724
15: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
16: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
17: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
18: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
19: , p4_a5 VARCHAR2 := fnd_api.g_miss_char

Line 16: , p4_a2 VARCHAR2 := fnd_api.g_miss_char

12: , x_msg_data OUT NOCOPY VARCHAR2
13: , x_denorm_query_id OUT NOCOPY NUMBER
14: , p4_a0 NUMBER := 0-1962.0724
15: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
16: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
17: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
18: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
19: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
20: , p4_a6 VARCHAR2 := fnd_api.g_miss_char

Line 17: , p4_a3 VARCHAR2 := fnd_api.g_miss_char

13: , x_denorm_query_id OUT NOCOPY NUMBER
14: , p4_a0 NUMBER := 0-1962.0724
15: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
16: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
17: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
18: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
19: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
20: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
21: , p4_a7 VARCHAR2 := fnd_api.g_miss_char

Line 18: , p4_a4 VARCHAR2 := fnd_api.g_miss_char

14: , p4_a0 NUMBER := 0-1962.0724
15: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
16: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
17: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
18: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
19: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
20: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
21: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
22: , p4_a8 DATE := fnd_api.g_miss_date

Line 19: , p4_a5 VARCHAR2 := fnd_api.g_miss_char

15: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
16: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
17: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
18: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
19: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
20: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
21: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
22: , p4_a8 DATE := fnd_api.g_miss_date
23: , p4_a9 NUMBER := 0-1962.0724

Line 20: , p4_a6 VARCHAR2 := fnd_api.g_miss_char

16: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
17: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
18: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
19: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
20: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
21: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
22: , p4_a8 DATE := fnd_api.g_miss_date
23: , p4_a9 NUMBER := 0-1962.0724
24: , p4_a10 DATE := fnd_api.g_miss_date

Line 21: , p4_a7 VARCHAR2 := fnd_api.g_miss_char

17: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
18: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
19: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
20: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
21: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
22: , p4_a8 DATE := fnd_api.g_miss_date
23: , p4_a9 NUMBER := 0-1962.0724
24: , p4_a10 DATE := fnd_api.g_miss_date
25: , p4_a11 NUMBER := 0-1962.0724

Line 22: , p4_a8 DATE := fnd_api.g_miss_date

18: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
19: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
20: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
21: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
22: , p4_a8 DATE := fnd_api.g_miss_date
23: , p4_a9 NUMBER := 0-1962.0724
24: , p4_a10 DATE := fnd_api.g_miss_date
25: , p4_a11 NUMBER := 0-1962.0724
26: , p4_a12 NUMBER := 0-1962.0724

Line 24: , p4_a10 DATE := fnd_api.g_miss_date

20: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
21: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
22: , p4_a8 DATE := fnd_api.g_miss_date
23: , p4_a9 NUMBER := 0-1962.0724
24: , p4_a10 DATE := fnd_api.g_miss_date
25: , p4_a11 NUMBER := 0-1962.0724
26: , p4_a12 NUMBER := 0-1962.0724
27: , p4_a13 NUMBER := 0-1962.0724
28: , p4_a14 NUMBER := 0-1962.0724

Line 38: , p4_a1 VARCHAR2 := fnd_api.g_miss_char

34: , x_return_status OUT NOCOPY VARCHAR2
35: , x_msg_count OUT NOCOPY NUMBER
36: , x_msg_data OUT NOCOPY VARCHAR2
37: , p4_a0 NUMBER := 0-1962.0724
38: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
39: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
40: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
41: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
42: , p4_a5 VARCHAR2 := fnd_api.g_miss_char

Line 39: , p4_a2 VARCHAR2 := fnd_api.g_miss_char

35: , x_msg_count OUT NOCOPY NUMBER
36: , x_msg_data OUT NOCOPY VARCHAR2
37: , p4_a0 NUMBER := 0-1962.0724
38: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
39: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
40: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
41: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
42: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
43: , p4_a6 VARCHAR2 := fnd_api.g_miss_char

Line 40: , p4_a3 VARCHAR2 := fnd_api.g_miss_char

36: , x_msg_data OUT NOCOPY VARCHAR2
37: , p4_a0 NUMBER := 0-1962.0724
38: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
39: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
40: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
41: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
42: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
43: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
44: , p4_a7 VARCHAR2 := fnd_api.g_miss_char

Line 41: , p4_a4 VARCHAR2 := fnd_api.g_miss_char

37: , p4_a0 NUMBER := 0-1962.0724
38: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
39: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
40: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
41: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
42: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
43: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
44: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
45: , p4_a8 DATE := fnd_api.g_miss_date

Line 42: , p4_a5 VARCHAR2 := fnd_api.g_miss_char

38: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
39: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
40: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
41: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
42: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
43: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
44: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
45: , p4_a8 DATE := fnd_api.g_miss_date
46: , p4_a9 NUMBER := 0-1962.0724

Line 43: , p4_a6 VARCHAR2 := fnd_api.g_miss_char

39: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
40: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
41: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
42: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
43: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
44: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
45: , p4_a8 DATE := fnd_api.g_miss_date
46: , p4_a9 NUMBER := 0-1962.0724
47: , p4_a10 DATE := fnd_api.g_miss_date

Line 44: , p4_a7 VARCHAR2 := fnd_api.g_miss_char

40: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
41: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
42: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
43: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
44: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
45: , p4_a8 DATE := fnd_api.g_miss_date
46: , p4_a9 NUMBER := 0-1962.0724
47: , p4_a10 DATE := fnd_api.g_miss_date
48: , p4_a11 NUMBER := 0-1962.0724

Line 45: , p4_a8 DATE := fnd_api.g_miss_date

41: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
42: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
43: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
44: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
45: , p4_a8 DATE := fnd_api.g_miss_date
46: , p4_a9 NUMBER := 0-1962.0724
47: , p4_a10 DATE := fnd_api.g_miss_date
48: , p4_a11 NUMBER := 0-1962.0724
49: , p4_a12 NUMBER := 0-1962.0724

Line 47: , p4_a10 DATE := fnd_api.g_miss_date

43: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
44: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
45: , p4_a8 DATE := fnd_api.g_miss_date
46: , p4_a9 NUMBER := 0-1962.0724
47: , p4_a10 DATE := fnd_api.g_miss_date
48: , p4_a11 NUMBER := 0-1962.0724
49: , p4_a12 NUMBER := 0-1962.0724
50: , p4_a13 NUMBER := 0-1962.0724
51: , p4_a14 NUMBER := 0-1962.0724

Line 61: , p4_a1 VARCHAR2 := fnd_api.g_miss_char

57: , x_return_status OUT NOCOPY VARCHAR2
58: , x_msg_count OUT NOCOPY NUMBER
59: , x_msg_data OUT NOCOPY VARCHAR2
60: , p4_a0 NUMBER := 0-1962.0724
61: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
62: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
63: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
64: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
65: , p4_a5 VARCHAR2 := fnd_api.g_miss_char

Line 62: , p4_a2 VARCHAR2 := fnd_api.g_miss_char

58: , x_msg_count OUT NOCOPY NUMBER
59: , x_msg_data OUT NOCOPY VARCHAR2
60: , p4_a0 NUMBER := 0-1962.0724
61: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
62: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
63: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
64: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
65: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
66: , p4_a6 VARCHAR2 := fnd_api.g_miss_char

Line 63: , p4_a3 VARCHAR2 := fnd_api.g_miss_char

59: , x_msg_data OUT NOCOPY VARCHAR2
60: , p4_a0 NUMBER := 0-1962.0724
61: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
62: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
63: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
64: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
65: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
66: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
67: , p4_a7 VARCHAR2 := fnd_api.g_miss_char

Line 64: , p4_a4 VARCHAR2 := fnd_api.g_miss_char

60: , p4_a0 NUMBER := 0-1962.0724
61: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
62: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
63: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
64: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
65: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
66: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
67: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
68: , p4_a8 DATE := fnd_api.g_miss_date

Line 65: , p4_a5 VARCHAR2 := fnd_api.g_miss_char

61: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
62: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
63: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
64: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
65: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
66: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
67: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
68: , p4_a8 DATE := fnd_api.g_miss_date
69: , p4_a9 NUMBER := 0-1962.0724

Line 66: , p4_a6 VARCHAR2 := fnd_api.g_miss_char

62: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
63: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
64: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
65: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
66: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
67: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
68: , p4_a8 DATE := fnd_api.g_miss_date
69: , p4_a9 NUMBER := 0-1962.0724
70: , p4_a10 DATE := fnd_api.g_miss_date

Line 67: , p4_a7 VARCHAR2 := fnd_api.g_miss_char

63: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
64: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
65: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
66: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
67: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
68: , p4_a8 DATE := fnd_api.g_miss_date
69: , p4_a9 NUMBER := 0-1962.0724
70: , p4_a10 DATE := fnd_api.g_miss_date
71: , p4_a11 NUMBER := 0-1962.0724

Line 68: , p4_a8 DATE := fnd_api.g_miss_date

64: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
65: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
66: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
67: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
68: , p4_a8 DATE := fnd_api.g_miss_date
69: , p4_a9 NUMBER := 0-1962.0724
70: , p4_a10 DATE := fnd_api.g_miss_date
71: , p4_a11 NUMBER := 0-1962.0724
72: , p4_a12 NUMBER := 0-1962.0724

Line 70: , p4_a10 DATE := fnd_api.g_miss_date

66: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
67: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
68: , p4_a8 DATE := fnd_api.g_miss_date
69: , p4_a9 NUMBER := 0-1962.0724
70: , p4_a10 DATE := fnd_api.g_miss_date
71: , p4_a11 NUMBER := 0-1962.0724
72: , p4_a12 NUMBER := 0-1962.0724
73: , p4_a13 NUMBER := 0-1962.0724
74: , p4_a14 NUMBER := 0-1962.0724

Line 79: , p0_a1 VARCHAR2 := fnd_api.g_miss_char

75: );
76: procedure check_denorm_queries_items(p_validation_mode VARCHAR2
77: , x_return_status OUT NOCOPY VARCHAR2
78: , p0_a0 NUMBER := 0-1962.0724
79: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
80: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
81: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
82: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
83: , p0_a5 VARCHAR2 := fnd_api.g_miss_char

Line 80: , p0_a2 VARCHAR2 := fnd_api.g_miss_char

76: procedure check_denorm_queries_items(p_validation_mode VARCHAR2
77: , x_return_status OUT NOCOPY VARCHAR2
78: , p0_a0 NUMBER := 0-1962.0724
79: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
80: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
81: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
82: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
83: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
84: , p0_a6 VARCHAR2 := fnd_api.g_miss_char

Line 81: , p0_a3 VARCHAR2 := fnd_api.g_miss_char

77: , x_return_status OUT NOCOPY VARCHAR2
78: , p0_a0 NUMBER := 0-1962.0724
79: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
80: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
81: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
82: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
83: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
84: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
85: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 82: , p0_a4 VARCHAR2 := fnd_api.g_miss_char

78: , p0_a0 NUMBER := 0-1962.0724
79: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
80: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
81: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
82: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
83: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
84: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
85: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p0_a8 DATE := fnd_api.g_miss_date

Line 83: , p0_a5 VARCHAR2 := fnd_api.g_miss_char

79: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
80: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
81: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
82: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
83: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
84: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
85: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p0_a8 DATE := fnd_api.g_miss_date
87: , p0_a9 NUMBER := 0-1962.0724

Line 84: , p0_a6 VARCHAR2 := fnd_api.g_miss_char

80: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
81: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
82: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
83: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
84: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
85: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p0_a8 DATE := fnd_api.g_miss_date
87: , p0_a9 NUMBER := 0-1962.0724
88: , p0_a10 DATE := fnd_api.g_miss_date

Line 85: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

81: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
82: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
83: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
84: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
85: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p0_a8 DATE := fnd_api.g_miss_date
87: , p0_a9 NUMBER := 0-1962.0724
88: , p0_a10 DATE := fnd_api.g_miss_date
89: , p0_a11 NUMBER := 0-1962.0724

Line 86: , p0_a8 DATE := fnd_api.g_miss_date

82: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
83: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
84: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
85: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p0_a8 DATE := fnd_api.g_miss_date
87: , p0_a9 NUMBER := 0-1962.0724
88: , p0_a10 DATE := fnd_api.g_miss_date
89: , p0_a11 NUMBER := 0-1962.0724
90: , p0_a12 NUMBER := 0-1962.0724

Line 88: , p0_a10 DATE := fnd_api.g_miss_date

84: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
85: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p0_a8 DATE := fnd_api.g_miss_date
87: , p0_a9 NUMBER := 0-1962.0724
88: , p0_a10 DATE := fnd_api.g_miss_date
89: , p0_a11 NUMBER := 0-1962.0724
90: , p0_a12 NUMBER := 0-1962.0724
91: , p0_a13 NUMBER := 0-1962.0724
92: , p0_a14 NUMBER := 0-1962.0724

Line 96: , p0_a1 VARCHAR2 := fnd_api.g_miss_char

92: , p0_a14 NUMBER := 0-1962.0724
93: );
94: procedure check_denorm_queries_record(x_return_status OUT NOCOPY VARCHAR2
95: , p0_a0 NUMBER := 0-1962.0724
96: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
97: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
98: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
99: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
100: , p0_a5 VARCHAR2 := fnd_api.g_miss_char

Line 97: , p0_a2 VARCHAR2 := fnd_api.g_miss_char

93: );
94: procedure check_denorm_queries_record(x_return_status OUT NOCOPY VARCHAR2
95: , p0_a0 NUMBER := 0-1962.0724
96: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
97: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
98: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
99: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
100: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
101: , p0_a6 VARCHAR2 := fnd_api.g_miss_char

Line 98: , p0_a3 VARCHAR2 := fnd_api.g_miss_char

94: procedure check_denorm_queries_record(x_return_status OUT NOCOPY VARCHAR2
95: , p0_a0 NUMBER := 0-1962.0724
96: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
97: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
98: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
99: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
100: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
101: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
102: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 99: , p0_a4 VARCHAR2 := fnd_api.g_miss_char

95: , p0_a0 NUMBER := 0-1962.0724
96: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
97: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
98: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
99: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
100: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
101: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
102: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
103: , p0_a8 DATE := fnd_api.g_miss_date

Line 100: , p0_a5 VARCHAR2 := fnd_api.g_miss_char

96: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
97: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
98: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
99: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
100: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
101: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
102: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
103: , p0_a8 DATE := fnd_api.g_miss_date
104: , p0_a9 NUMBER := 0-1962.0724

Line 101: , p0_a6 VARCHAR2 := fnd_api.g_miss_char

97: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
98: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
99: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
100: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
101: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
102: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
103: , p0_a8 DATE := fnd_api.g_miss_date
104: , p0_a9 NUMBER := 0-1962.0724
105: , p0_a10 DATE := fnd_api.g_miss_date

Line 102: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

98: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
99: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
100: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
101: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
102: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
103: , p0_a8 DATE := fnd_api.g_miss_date
104: , p0_a9 NUMBER := 0-1962.0724
105: , p0_a10 DATE := fnd_api.g_miss_date
106: , p0_a11 NUMBER := 0-1962.0724

Line 103: , p0_a8 DATE := fnd_api.g_miss_date

99: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
100: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
101: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
102: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
103: , p0_a8 DATE := fnd_api.g_miss_date
104: , p0_a9 NUMBER := 0-1962.0724
105: , p0_a10 DATE := fnd_api.g_miss_date
106: , p0_a11 NUMBER := 0-1962.0724
107: , p0_a12 NUMBER := 0-1962.0724

Line 105: , p0_a10 DATE := fnd_api.g_miss_date

101: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
102: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
103: , p0_a8 DATE := fnd_api.g_miss_date
104: , p0_a9 NUMBER := 0-1962.0724
105: , p0_a10 DATE := fnd_api.g_miss_date
106: , p0_a11 NUMBER := 0-1962.0724
107: , p0_a12 NUMBER := 0-1962.0724
108: , p0_a13 NUMBER := 0-1962.0724
109: , p0_a14 NUMBER := 0-1962.0724

Line 143: , p0_a1 VARCHAR2 := fnd_api.g_miss_char

139: , p1_a12 OUT NOCOPY NUMBER
140: , p1_a13 OUT NOCOPY NUMBER
141: , p1_a14 OUT NOCOPY NUMBER
142: , p0_a0 NUMBER := 0-1962.0724
143: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
144: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
145: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
146: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
147: , p0_a5 VARCHAR2 := fnd_api.g_miss_char

Line 144: , p0_a2 VARCHAR2 := fnd_api.g_miss_char

140: , p1_a13 OUT NOCOPY NUMBER
141: , p1_a14 OUT NOCOPY NUMBER
142: , p0_a0 NUMBER := 0-1962.0724
143: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
144: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
145: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
146: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
147: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
148: , p0_a6 VARCHAR2 := fnd_api.g_miss_char

Line 145: , p0_a3 VARCHAR2 := fnd_api.g_miss_char

141: , p1_a14 OUT NOCOPY NUMBER
142: , p0_a0 NUMBER := 0-1962.0724
143: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
144: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
145: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
146: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
147: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
148: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
149: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 146: , p0_a4 VARCHAR2 := fnd_api.g_miss_char

142: , p0_a0 NUMBER := 0-1962.0724
143: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
144: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
145: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
146: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
147: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
148: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
149: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
150: , p0_a8 DATE := fnd_api.g_miss_date

Line 147: , p0_a5 VARCHAR2 := fnd_api.g_miss_char

143: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
144: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
145: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
146: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
147: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
148: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
149: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
150: , p0_a8 DATE := fnd_api.g_miss_date
151: , p0_a9 NUMBER := 0-1962.0724

Line 148: , p0_a6 VARCHAR2 := fnd_api.g_miss_char

144: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
145: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
146: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
147: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
148: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
149: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
150: , p0_a8 DATE := fnd_api.g_miss_date
151: , p0_a9 NUMBER := 0-1962.0724
152: , p0_a10 DATE := fnd_api.g_miss_date

Line 149: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

145: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
146: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
147: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
148: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
149: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
150: , p0_a8 DATE := fnd_api.g_miss_date
151: , p0_a9 NUMBER := 0-1962.0724
152: , p0_a10 DATE := fnd_api.g_miss_date
153: , p0_a11 NUMBER := 0-1962.0724

Line 150: , p0_a8 DATE := fnd_api.g_miss_date

146: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
147: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
148: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
149: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
150: , p0_a8 DATE := fnd_api.g_miss_date
151: , p0_a9 NUMBER := 0-1962.0724
152: , p0_a10 DATE := fnd_api.g_miss_date
153: , p0_a11 NUMBER := 0-1962.0724
154: , p0_a12 NUMBER := 0-1962.0724

Line 152: , p0_a10 DATE := fnd_api.g_miss_date

148: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
149: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
150: , p0_a8 DATE := fnd_api.g_miss_date
151: , p0_a9 NUMBER := 0-1962.0724
152: , p0_a10 DATE := fnd_api.g_miss_date
153: , p0_a11 NUMBER := 0-1962.0724
154: , p0_a12 NUMBER := 0-1962.0724
155: , p0_a13 NUMBER := 0-1962.0724
156: , p0_a14 NUMBER := 0-1962.0724