APPS.PV_GE_NOTIF_RULES_PVT_W dependencies on FND_API

Line 62: , p7_a2 VARCHAR2 := fnd_api.g_miss_char

58: , x_msg_data out nocopy VARCHAR2
59: , x_notif_rule_id out nocopy NUMBER
60: , p7_a0 NUMBER := 0-1962.0724
61: , p7_a1 NUMBER := 0-1962.0724
62: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
63: , p7_a3 NUMBER := 0-1962.0724
64: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
65: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
66: , p7_a6 VARCHAR2 := fnd_api.g_miss_char

Line 64: , p7_a4 VARCHAR2 := fnd_api.g_miss_char

60: , p7_a0 NUMBER := 0-1962.0724
61: , p7_a1 NUMBER := 0-1962.0724
62: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
63: , p7_a3 NUMBER := 0-1962.0724
64: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
65: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
66: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
67: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
68: , p7_a8 NUMBER := 0-1962.0724

Line 65: , p7_a5 VARCHAR2 := fnd_api.g_miss_char

61: , p7_a1 NUMBER := 0-1962.0724
62: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
63: , p7_a3 NUMBER := 0-1962.0724
64: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
65: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
66: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
67: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
68: , p7_a8 NUMBER := 0-1962.0724
69: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

Line 66: , p7_a6 VARCHAR2 := fnd_api.g_miss_char

62: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
63: , p7_a3 NUMBER := 0-1962.0724
64: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
65: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
66: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
67: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
68: , p7_a8 NUMBER := 0-1962.0724
69: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
70: , p7_a10 NUMBER := 0-1962.0724

Line 67: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

63: , p7_a3 NUMBER := 0-1962.0724
64: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
65: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
66: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
67: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
68: , p7_a8 NUMBER := 0-1962.0724
69: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
70: , p7_a10 NUMBER := 0-1962.0724
71: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 69: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

65: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
66: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
67: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
68: , p7_a8 NUMBER := 0-1962.0724
69: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
70: , p7_a10 NUMBER := 0-1962.0724
71: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
72: , p7_a12 NUMBER := 0-1962.0724
73: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

Line 71: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

67: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
68: , p7_a8 NUMBER := 0-1962.0724
69: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
70: , p7_a10 NUMBER := 0-1962.0724
71: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
72: , p7_a12 NUMBER := 0-1962.0724
73: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a14 NUMBER := 0-1962.0724
75: , p7_a15 NUMBER := 0-1962.0724

Line 73: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

69: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
70: , p7_a10 NUMBER := 0-1962.0724
71: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
72: , p7_a12 NUMBER := 0-1962.0724
73: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a14 NUMBER := 0-1962.0724
75: , p7_a15 NUMBER := 0-1962.0724
76: , p7_a16 DATE := fnd_api.g_miss_date
77: , p7_a17 NUMBER := 0-1962.0724

Line 76: , p7_a16 DATE := fnd_api.g_miss_date

72: , p7_a12 NUMBER := 0-1962.0724
73: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a14 NUMBER := 0-1962.0724
75: , p7_a15 NUMBER := 0-1962.0724
76: , p7_a16 DATE := fnd_api.g_miss_date
77: , p7_a17 NUMBER := 0-1962.0724
78: , p7_a18 DATE := fnd_api.g_miss_date
79: , p7_a19 NUMBER := 0-1962.0724
80: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

Line 78: , p7_a18 DATE := fnd_api.g_miss_date

74: , p7_a14 NUMBER := 0-1962.0724
75: , p7_a15 NUMBER := 0-1962.0724
76: , p7_a16 DATE := fnd_api.g_miss_date
77: , p7_a17 NUMBER := 0-1962.0724
78: , p7_a18 DATE := fnd_api.g_miss_date
79: , p7_a19 NUMBER := 0-1962.0724
80: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
81: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
82: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

Line 80: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

76: , p7_a16 DATE := fnd_api.g_miss_date
77: , p7_a17 NUMBER := 0-1962.0724
78: , p7_a18 DATE := fnd_api.g_miss_date
79: , p7_a19 NUMBER := 0-1962.0724
80: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
81: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
82: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
83: );
84: procedure update_ge_notif_rules(p_api_version_number NUMBER

Line 81: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

77: , p7_a17 NUMBER := 0-1962.0724
78: , p7_a18 DATE := fnd_api.g_miss_date
79: , p7_a19 NUMBER := 0-1962.0724
80: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
81: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
82: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
83: );
84: procedure update_ge_notif_rules(p_api_version_number NUMBER
85: , p_init_msg_list VARCHAR2

Line 82: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

78: , p7_a18 DATE := fnd_api.g_miss_date
79: , p7_a19 NUMBER := 0-1962.0724
80: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
81: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
82: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
83: );
84: procedure update_ge_notif_rules(p_api_version_number NUMBER
85: , p_init_msg_list VARCHAR2
86: , p_commit VARCHAR2

Line 93: , p7_a2 VARCHAR2 := fnd_api.g_miss_char

89: , x_msg_count out nocopy NUMBER
90: , x_msg_data out nocopy VARCHAR2
91: , p7_a0 NUMBER := 0-1962.0724
92: , p7_a1 NUMBER := 0-1962.0724
93: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a3 NUMBER := 0-1962.0724
95: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a6 VARCHAR2 := fnd_api.g_miss_char

Line 95: , p7_a4 VARCHAR2 := fnd_api.g_miss_char

91: , p7_a0 NUMBER := 0-1962.0724
92: , p7_a1 NUMBER := 0-1962.0724
93: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a3 NUMBER := 0-1962.0724
95: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a8 NUMBER := 0-1962.0724

Line 96: , p7_a5 VARCHAR2 := fnd_api.g_miss_char

92: , p7_a1 NUMBER := 0-1962.0724
93: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a3 NUMBER := 0-1962.0724
95: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a8 NUMBER := 0-1962.0724
100: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

Line 97: , p7_a6 VARCHAR2 := fnd_api.g_miss_char

93: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a3 NUMBER := 0-1962.0724
95: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a8 NUMBER := 0-1962.0724
100: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a10 NUMBER := 0-1962.0724

Line 98: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

94: , p7_a3 NUMBER := 0-1962.0724
95: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a8 NUMBER := 0-1962.0724
100: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a10 NUMBER := 0-1962.0724
102: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 100: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

96: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a8 NUMBER := 0-1962.0724
100: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a10 NUMBER := 0-1962.0724
102: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a12 NUMBER := 0-1962.0724
104: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

Line 102: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

98: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a8 NUMBER := 0-1962.0724
100: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a10 NUMBER := 0-1962.0724
102: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a12 NUMBER := 0-1962.0724
104: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a14 NUMBER := 0-1962.0724
106: , p7_a15 NUMBER := 0-1962.0724

Line 104: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

100: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a10 NUMBER := 0-1962.0724
102: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a12 NUMBER := 0-1962.0724
104: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a14 NUMBER := 0-1962.0724
106: , p7_a15 NUMBER := 0-1962.0724
107: , p7_a16 DATE := fnd_api.g_miss_date
108: , p7_a17 NUMBER := 0-1962.0724

Line 107: , p7_a16 DATE := fnd_api.g_miss_date

103: , p7_a12 NUMBER := 0-1962.0724
104: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a14 NUMBER := 0-1962.0724
106: , p7_a15 NUMBER := 0-1962.0724
107: , p7_a16 DATE := fnd_api.g_miss_date
108: , p7_a17 NUMBER := 0-1962.0724
109: , p7_a18 DATE := fnd_api.g_miss_date
110: , p7_a19 NUMBER := 0-1962.0724
111: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

Line 109: , p7_a18 DATE := fnd_api.g_miss_date

105: , p7_a14 NUMBER := 0-1962.0724
106: , p7_a15 NUMBER := 0-1962.0724
107: , p7_a16 DATE := fnd_api.g_miss_date
108: , p7_a17 NUMBER := 0-1962.0724
109: , p7_a18 DATE := fnd_api.g_miss_date
110: , p7_a19 NUMBER := 0-1962.0724
111: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
113: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

Line 111: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

107: , p7_a16 DATE := fnd_api.g_miss_date
108: , p7_a17 NUMBER := 0-1962.0724
109: , p7_a18 DATE := fnd_api.g_miss_date
110: , p7_a19 NUMBER := 0-1962.0724
111: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
113: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
114: );
115: procedure validate_ge_notif_rules(p_api_version_number NUMBER

Line 112: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

108: , p7_a17 NUMBER := 0-1962.0724
109: , p7_a18 DATE := fnd_api.g_miss_date
110: , p7_a19 NUMBER := 0-1962.0724
111: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
113: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
114: );
115: procedure validate_ge_notif_rules(p_api_version_number NUMBER
116: , p_init_msg_list VARCHAR2

Line 113: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

109: , p7_a18 DATE := fnd_api.g_miss_date
110: , p7_a19 NUMBER := 0-1962.0724
111: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
112: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
113: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
114: );
115: procedure validate_ge_notif_rules(p_api_version_number NUMBER
116: , p_init_msg_list VARCHAR2
117: , p_validation_level NUMBER

Line 124: , p3_a2 VARCHAR2 := fnd_api.g_miss_char

120: , x_msg_count out nocopy NUMBER
121: , x_msg_data out nocopy VARCHAR2
122: , p3_a0 NUMBER := 0-1962.0724
123: , p3_a1 NUMBER := 0-1962.0724
124: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
125: , p3_a3 NUMBER := 0-1962.0724
126: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
127: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
128: , p3_a6 VARCHAR2 := fnd_api.g_miss_char

Line 126: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

122: , p3_a0 NUMBER := 0-1962.0724
123: , p3_a1 NUMBER := 0-1962.0724
124: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
125: , p3_a3 NUMBER := 0-1962.0724
126: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
127: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
128: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
129: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
130: , p3_a8 NUMBER := 0-1962.0724

Line 127: , p3_a5 VARCHAR2 := fnd_api.g_miss_char

123: , p3_a1 NUMBER := 0-1962.0724
124: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
125: , p3_a3 NUMBER := 0-1962.0724
126: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
127: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
128: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
129: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
130: , p3_a8 NUMBER := 0-1962.0724
131: , p3_a9 VARCHAR2 := fnd_api.g_miss_char

Line 128: , p3_a6 VARCHAR2 := fnd_api.g_miss_char

124: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
125: , p3_a3 NUMBER := 0-1962.0724
126: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
127: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
128: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
129: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
130: , p3_a8 NUMBER := 0-1962.0724
131: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
132: , p3_a10 NUMBER := 0-1962.0724

Line 129: , p3_a7 VARCHAR2 := fnd_api.g_miss_char

125: , p3_a3 NUMBER := 0-1962.0724
126: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
127: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
128: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
129: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
130: , p3_a8 NUMBER := 0-1962.0724
131: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
132: , p3_a10 NUMBER := 0-1962.0724
133: , p3_a11 VARCHAR2 := fnd_api.g_miss_char

Line 131: , p3_a9 VARCHAR2 := fnd_api.g_miss_char

127: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
128: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
129: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
130: , p3_a8 NUMBER := 0-1962.0724
131: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
132: , p3_a10 NUMBER := 0-1962.0724
133: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
134: , p3_a12 NUMBER := 0-1962.0724
135: , p3_a13 VARCHAR2 := fnd_api.g_miss_char

Line 133: , p3_a11 VARCHAR2 := fnd_api.g_miss_char

129: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
130: , p3_a8 NUMBER := 0-1962.0724
131: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
132: , p3_a10 NUMBER := 0-1962.0724
133: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
134: , p3_a12 NUMBER := 0-1962.0724
135: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
136: , p3_a14 NUMBER := 0-1962.0724
137: , p3_a15 NUMBER := 0-1962.0724

Line 135: , p3_a13 VARCHAR2 := fnd_api.g_miss_char

131: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
132: , p3_a10 NUMBER := 0-1962.0724
133: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
134: , p3_a12 NUMBER := 0-1962.0724
135: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
136: , p3_a14 NUMBER := 0-1962.0724
137: , p3_a15 NUMBER := 0-1962.0724
138: , p3_a16 DATE := fnd_api.g_miss_date
139: , p3_a17 NUMBER := 0-1962.0724

Line 138: , p3_a16 DATE := fnd_api.g_miss_date

134: , p3_a12 NUMBER := 0-1962.0724
135: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
136: , p3_a14 NUMBER := 0-1962.0724
137: , p3_a15 NUMBER := 0-1962.0724
138: , p3_a16 DATE := fnd_api.g_miss_date
139: , p3_a17 NUMBER := 0-1962.0724
140: , p3_a18 DATE := fnd_api.g_miss_date
141: , p3_a19 NUMBER := 0-1962.0724
142: , p3_a20 VARCHAR2 := fnd_api.g_miss_char

Line 140: , p3_a18 DATE := fnd_api.g_miss_date

136: , p3_a14 NUMBER := 0-1962.0724
137: , p3_a15 NUMBER := 0-1962.0724
138: , p3_a16 DATE := fnd_api.g_miss_date
139: , p3_a17 NUMBER := 0-1962.0724
140: , p3_a18 DATE := fnd_api.g_miss_date
141: , p3_a19 NUMBER := 0-1962.0724
142: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
143: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
144: , p3_a22 VARCHAR2 := fnd_api.g_miss_char

Line 142: , p3_a20 VARCHAR2 := fnd_api.g_miss_char

138: , p3_a16 DATE := fnd_api.g_miss_date
139: , p3_a17 NUMBER := 0-1962.0724
140: , p3_a18 DATE := fnd_api.g_miss_date
141: , p3_a19 NUMBER := 0-1962.0724
142: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
143: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
144: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
145: );
146: procedure check_ge_notif_rules_items(p_validation_mode VARCHAR2

Line 143: , p3_a21 VARCHAR2 := fnd_api.g_miss_char

139: , p3_a17 NUMBER := 0-1962.0724
140: , p3_a18 DATE := fnd_api.g_miss_date
141: , p3_a19 NUMBER := 0-1962.0724
142: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
143: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
144: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
145: );
146: procedure check_ge_notif_rules_items(p_validation_mode VARCHAR2
147: , x_return_status out nocopy VARCHAR2

Line 144: , p3_a22 VARCHAR2 := fnd_api.g_miss_char

140: , p3_a18 DATE := fnd_api.g_miss_date
141: , p3_a19 NUMBER := 0-1962.0724
142: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
143: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
144: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
145: );
146: procedure check_ge_notif_rules_items(p_validation_mode VARCHAR2
147: , x_return_status out nocopy VARCHAR2
148: , p0_a0 NUMBER := 0-1962.0724

Line 150: , p0_a2 VARCHAR2 := fnd_api.g_miss_char

146: procedure check_ge_notif_rules_items(p_validation_mode VARCHAR2
147: , x_return_status out nocopy VARCHAR2
148: , p0_a0 NUMBER := 0-1962.0724
149: , p0_a1 NUMBER := 0-1962.0724
150: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
151: , p0_a3 NUMBER := 0-1962.0724
152: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
153: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
154: , p0_a6 VARCHAR2 := fnd_api.g_miss_char

Line 152: , p0_a4 VARCHAR2 := fnd_api.g_miss_char

148: , p0_a0 NUMBER := 0-1962.0724
149: , p0_a1 NUMBER := 0-1962.0724
150: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
151: , p0_a3 NUMBER := 0-1962.0724
152: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
153: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
154: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
155: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
156: , p0_a8 NUMBER := 0-1962.0724

Line 153: , p0_a5 VARCHAR2 := fnd_api.g_miss_char

149: , p0_a1 NUMBER := 0-1962.0724
150: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
151: , p0_a3 NUMBER := 0-1962.0724
152: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
153: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
154: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
155: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
156: , p0_a8 NUMBER := 0-1962.0724
157: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

Line 154: , p0_a6 VARCHAR2 := fnd_api.g_miss_char

150: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
151: , p0_a3 NUMBER := 0-1962.0724
152: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
153: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
154: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
155: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
156: , p0_a8 NUMBER := 0-1962.0724
157: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
158: , p0_a10 NUMBER := 0-1962.0724

Line 155: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

151: , p0_a3 NUMBER := 0-1962.0724
152: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
153: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
154: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
155: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
156: , p0_a8 NUMBER := 0-1962.0724
157: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
158: , p0_a10 NUMBER := 0-1962.0724
159: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 157: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

153: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
154: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
155: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
156: , p0_a8 NUMBER := 0-1962.0724
157: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
158: , p0_a10 NUMBER := 0-1962.0724
159: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
160: , p0_a12 NUMBER := 0-1962.0724
161: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

Line 159: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

155: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
156: , p0_a8 NUMBER := 0-1962.0724
157: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
158: , p0_a10 NUMBER := 0-1962.0724
159: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
160: , p0_a12 NUMBER := 0-1962.0724
161: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
162: , p0_a14 NUMBER := 0-1962.0724
163: , p0_a15 NUMBER := 0-1962.0724

Line 161: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

157: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
158: , p0_a10 NUMBER := 0-1962.0724
159: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
160: , p0_a12 NUMBER := 0-1962.0724
161: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
162: , p0_a14 NUMBER := 0-1962.0724
163: , p0_a15 NUMBER := 0-1962.0724
164: , p0_a16 DATE := fnd_api.g_miss_date
165: , p0_a17 NUMBER := 0-1962.0724

Line 164: , p0_a16 DATE := fnd_api.g_miss_date

160: , p0_a12 NUMBER := 0-1962.0724
161: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
162: , p0_a14 NUMBER := 0-1962.0724
163: , p0_a15 NUMBER := 0-1962.0724
164: , p0_a16 DATE := fnd_api.g_miss_date
165: , p0_a17 NUMBER := 0-1962.0724
166: , p0_a18 DATE := fnd_api.g_miss_date
167: , p0_a19 NUMBER := 0-1962.0724
168: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

Line 166: , p0_a18 DATE := fnd_api.g_miss_date

162: , p0_a14 NUMBER := 0-1962.0724
163: , p0_a15 NUMBER := 0-1962.0724
164: , p0_a16 DATE := fnd_api.g_miss_date
165: , p0_a17 NUMBER := 0-1962.0724
166: , p0_a18 DATE := fnd_api.g_miss_date
167: , p0_a19 NUMBER := 0-1962.0724
168: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a22 VARCHAR2 := fnd_api.g_miss_char

Line 168: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

164: , p0_a16 DATE := fnd_api.g_miss_date
165: , p0_a17 NUMBER := 0-1962.0724
166: , p0_a18 DATE := fnd_api.g_miss_date
167: , p0_a19 NUMBER := 0-1962.0724
168: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
171: );
172: procedure validate_ge_notif_rules_rec(p_api_version_number NUMBER

Line 169: , p0_a21 VARCHAR2 := fnd_api.g_miss_char

165: , p0_a17 NUMBER := 0-1962.0724
166: , p0_a18 DATE := fnd_api.g_miss_date
167: , p0_a19 NUMBER := 0-1962.0724
168: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
171: );
172: procedure validate_ge_notif_rules_rec(p_api_version_number NUMBER
173: , p_init_msg_list VARCHAR2

Line 170: , p0_a22 VARCHAR2 := fnd_api.g_miss_char

166: , p0_a18 DATE := fnd_api.g_miss_date
167: , p0_a19 NUMBER := 0-1962.0724
168: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
169: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
171: );
172: procedure validate_ge_notif_rules_rec(p_api_version_number NUMBER
173: , p_init_msg_list VARCHAR2
174: , x_return_status out nocopy VARCHAR2

Line 179: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

175: , x_msg_count out nocopy NUMBER
176: , x_msg_data out nocopy VARCHAR2
177: , p5_a0 NUMBER := 0-1962.0724
178: , p5_a1 NUMBER := 0-1962.0724
179: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
180: , p5_a3 NUMBER := 0-1962.0724
181: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
182: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 181: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

177: , p5_a0 NUMBER := 0-1962.0724
178: , p5_a1 NUMBER := 0-1962.0724
179: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
180: , p5_a3 NUMBER := 0-1962.0724
181: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
182: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
184: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
185: , p5_a8 NUMBER := 0-1962.0724

Line 182: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

178: , p5_a1 NUMBER := 0-1962.0724
179: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
180: , p5_a3 NUMBER := 0-1962.0724
181: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
182: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
184: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
185: , p5_a8 NUMBER := 0-1962.0724
186: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 183: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

179: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
180: , p5_a3 NUMBER := 0-1962.0724
181: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
182: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
184: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
185: , p5_a8 NUMBER := 0-1962.0724
186: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
187: , p5_a10 NUMBER := 0-1962.0724

Line 184: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

180: , p5_a3 NUMBER := 0-1962.0724
181: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
182: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
184: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
185: , p5_a8 NUMBER := 0-1962.0724
186: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
187: , p5_a10 NUMBER := 0-1962.0724
188: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 186: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

182: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
183: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
184: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
185: , p5_a8 NUMBER := 0-1962.0724
186: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
187: , p5_a10 NUMBER := 0-1962.0724
188: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
189: , p5_a12 NUMBER := 0-1962.0724
190: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 188: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

184: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
185: , p5_a8 NUMBER := 0-1962.0724
186: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
187: , p5_a10 NUMBER := 0-1962.0724
188: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
189: , p5_a12 NUMBER := 0-1962.0724
190: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
191: , p5_a14 NUMBER := 0-1962.0724
192: , p5_a15 NUMBER := 0-1962.0724

Line 190: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

186: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
187: , p5_a10 NUMBER := 0-1962.0724
188: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
189: , p5_a12 NUMBER := 0-1962.0724
190: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
191: , p5_a14 NUMBER := 0-1962.0724
192: , p5_a15 NUMBER := 0-1962.0724
193: , p5_a16 DATE := fnd_api.g_miss_date
194: , p5_a17 NUMBER := 0-1962.0724

Line 193: , p5_a16 DATE := fnd_api.g_miss_date

189: , p5_a12 NUMBER := 0-1962.0724
190: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
191: , p5_a14 NUMBER := 0-1962.0724
192: , p5_a15 NUMBER := 0-1962.0724
193: , p5_a16 DATE := fnd_api.g_miss_date
194: , p5_a17 NUMBER := 0-1962.0724
195: , p5_a18 DATE := fnd_api.g_miss_date
196: , p5_a19 NUMBER := 0-1962.0724
197: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 195: , p5_a18 DATE := fnd_api.g_miss_date

191: , p5_a14 NUMBER := 0-1962.0724
192: , p5_a15 NUMBER := 0-1962.0724
193: , p5_a16 DATE := fnd_api.g_miss_date
194: , p5_a17 NUMBER := 0-1962.0724
195: , p5_a18 DATE := fnd_api.g_miss_date
196: , p5_a19 NUMBER := 0-1962.0724
197: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
198: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
199: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

Line 197: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

193: , p5_a16 DATE := fnd_api.g_miss_date
194: , p5_a17 NUMBER := 0-1962.0724
195: , p5_a18 DATE := fnd_api.g_miss_date
196: , p5_a19 NUMBER := 0-1962.0724
197: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
198: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
199: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
200: );
201: end pv_ge_notif_rules_pvt_w;

Line 198: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

194: , p5_a17 NUMBER := 0-1962.0724
195: , p5_a18 DATE := fnd_api.g_miss_date
196: , p5_a19 NUMBER := 0-1962.0724
197: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
198: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
199: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
200: );
201: end pv_ge_notif_rules_pvt_w;

Line 199: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

195: , p5_a18 DATE := fnd_api.g_miss_date
196: , p5_a19 NUMBER := 0-1962.0724
197: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
198: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
199: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
200: );
201: end pv_ge_notif_rules_pvt_w;