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.AMS_ADV_FILTER_PVT dependencies on FND_API

Line 44: query_param_id NUMBER := FND_API.G_MISS_NUM,

40:
41: --===================================================================
42: TYPE filter_rec_type IS RECORD
43: (
44: query_param_id NUMBER := FND_API.G_MISS_NUM,
45: query_id NUMBER := FND_API.G_MISS_NUM,
46: parameter_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: parameter_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: parameter_value VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 45: query_id NUMBER := FND_API.G_MISS_NUM,

41: --===================================================================
42: TYPE filter_rec_type IS RECORD
43: (
44: query_param_id NUMBER := FND_API.G_MISS_NUM,
45: query_id NUMBER := FND_API.G_MISS_NUM,
46: parameter_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: parameter_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: parameter_value VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: parameter_condition VARCHAR2(5) := FND_API.G_MISS_CHAR,

Line 46: parameter_name VARCHAR2(60) := FND_API.G_MISS_CHAR,

42: TYPE filter_rec_type IS RECORD
43: (
44: query_param_id NUMBER := FND_API.G_MISS_NUM,
45: query_id NUMBER := FND_API.G_MISS_NUM,
46: parameter_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: parameter_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: parameter_value VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: parameter_condition VARCHAR2(5) := FND_API.G_MISS_CHAR,
50: parameter_sequence NUMBER := FND_API.G_MISS_NUM,

Line 47: parameter_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

43: (
44: query_param_id NUMBER := FND_API.G_MISS_NUM,
45: query_id NUMBER := FND_API.G_MISS_NUM,
46: parameter_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: parameter_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: parameter_value VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: parameter_condition VARCHAR2(5) := FND_API.G_MISS_CHAR,
50: parameter_sequence NUMBER := FND_API.G_MISS_NUM,
51: created_by NUMBER := FND_API.G_MISS_NUM,

Line 48: parameter_value VARCHAR2(60) := FND_API.G_MISS_CHAR,

44: query_param_id NUMBER := FND_API.G_MISS_NUM,
45: query_id NUMBER := FND_API.G_MISS_NUM,
46: parameter_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: parameter_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: parameter_value VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: parameter_condition VARCHAR2(5) := FND_API.G_MISS_CHAR,
50: parameter_sequence NUMBER := FND_API.G_MISS_NUM,
51: created_by NUMBER := FND_API.G_MISS_NUM,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,

Line 49: parameter_condition VARCHAR2(5) := FND_API.G_MISS_CHAR,

45: query_id NUMBER := FND_API.G_MISS_NUM,
46: parameter_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: parameter_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: parameter_value VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: parameter_condition VARCHAR2(5) := FND_API.G_MISS_CHAR,
50: parameter_sequence NUMBER := FND_API.G_MISS_NUM,
51: created_by NUMBER := FND_API.G_MISS_NUM,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: last_update_date DATE := FND_API.G_MISS_DATE,

Line 50: parameter_sequence NUMBER := FND_API.G_MISS_NUM,

46: parameter_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
47: parameter_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: parameter_value VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: parameter_condition VARCHAR2(5) := FND_API.G_MISS_CHAR,
50: parameter_sequence NUMBER := FND_API.G_MISS_NUM,
51: created_by NUMBER := FND_API.G_MISS_NUM,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: last_update_date DATE := FND_API.G_MISS_DATE,
54: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 51: created_by NUMBER := FND_API.G_MISS_NUM,

47: parameter_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: parameter_value VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: parameter_condition VARCHAR2(5) := FND_API.G_MISS_CHAR,
50: parameter_sequence NUMBER := FND_API.G_MISS_NUM,
51: created_by NUMBER := FND_API.G_MISS_NUM,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: last_update_date DATE := FND_API.G_MISS_DATE,
54: last_update_login NUMBER := FND_API.G_MISS_NUM,
55: security_group_id NUMBER := FND_API.G_MISS_NUM

Line 52: last_updated_by NUMBER := FND_API.G_MISS_NUM,

48: parameter_value VARCHAR2(60) := FND_API.G_MISS_CHAR,
49: parameter_condition VARCHAR2(5) := FND_API.G_MISS_CHAR,
50: parameter_sequence NUMBER := FND_API.G_MISS_NUM,
51: created_by NUMBER := FND_API.G_MISS_NUM,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: last_update_date DATE := FND_API.G_MISS_DATE,
54: last_update_login NUMBER := FND_API.G_MISS_NUM,
55: security_group_id NUMBER := FND_API.G_MISS_NUM
56: );

Line 53: last_update_date DATE := FND_API.G_MISS_DATE,

49: parameter_condition VARCHAR2(5) := FND_API.G_MISS_CHAR,
50: parameter_sequence NUMBER := FND_API.G_MISS_NUM,
51: created_by NUMBER := FND_API.G_MISS_NUM,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: last_update_date DATE := FND_API.G_MISS_DATE,
54: last_update_login NUMBER := FND_API.G_MISS_NUM,
55: security_group_id NUMBER := FND_API.G_MISS_NUM
56: );
57:

Line 54: last_update_login NUMBER := FND_API.G_MISS_NUM,

50: parameter_sequence NUMBER := FND_API.G_MISS_NUM,
51: created_by NUMBER := FND_API.G_MISS_NUM,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: last_update_date DATE := FND_API.G_MISS_DATE,
54: last_update_login NUMBER := FND_API.G_MISS_NUM,
55: security_group_id NUMBER := FND_API.G_MISS_NUM
56: );
57:
58: g_miss_filter_rec filter_rec_type;

Line 55: security_group_id NUMBER := FND_API.G_MISS_NUM

51: created_by NUMBER := FND_API.G_MISS_NUM,
52: last_updated_by NUMBER := FND_API.G_MISS_NUM,
53: last_update_date DATE := FND_API.G_MISS_DATE,
54: last_update_login NUMBER := FND_API.G_MISS_NUM,
55: security_group_id NUMBER := FND_API.G_MISS_NUM
56: );
57:
58: g_miss_filter_rec filter_rec_type;
59:

Line 76: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

72: -- Parameters
73: --
74: -- IN
75: -- p_api_version_number IN NUMBER Required
76: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
77: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
78: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
79: -- p_filter_rec IN filter_rec_type Required
80: --

Line 77: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

73: --
74: -- IN
75: -- p_api_version_number IN NUMBER Required
76: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
77: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
78: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
79: -- p_filter_rec IN filter_rec_type Required
80: --
81: -- OUT

Line 78: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

74: -- IN
75: -- p_api_version_number IN NUMBER Required
76: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
77: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
78: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
79: -- p_filter_rec IN filter_rec_type Required
80: --
81: -- OUT
82: -- x_return_status OUT NOCOPY VARCHAR2

Line 96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

92:
93: PROCEDURE Create_Filter_Row
94: (
95: p_api_version_number IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,

Line 97: p_commit IN VARCHAR2 := FND_API.G_FALSE,

93: PROCEDURE Create_Filter_Row
94: (
95: p_api_version_number IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,

Line 98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

94: (
95: p_api_version_number IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_filter_rec IN filter_rec_type := g_miss_filter_rec,

Line 120: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

116: -- Parameters
117: --
118: -- IN
119: -- p_api_version_number IN NUMBER Required
120: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
121: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
122: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
123: -- p_filter_rec IN filter_rec_type Required
124: --

Line 121: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

117: --
118: -- IN
119: -- p_api_version_number IN NUMBER Required
120: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
121: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
122: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
123: -- p_filter_rec IN filter_rec_type Required
124: --
125: -- OUT NOCOPY

Line 122: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

118: -- IN
119: -- p_api_version_number IN NUMBER Required
120: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
121: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
122: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
123: -- p_filter_rec IN filter_rec_type Required
124: --
125: -- OUT NOCOPY
126: -- x_return_status OUT NOCOPY VARCHAR2

Line 139: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

135: --
136:
137: PROCEDURE Update_Filter_Row(
138: p_api_version_number IN NUMBER,
139: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
140: p_commit IN VARCHAR2 := FND_API.G_FALSE,
141: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,

Line 140: p_commit IN VARCHAR2 := FND_API.G_FALSE,

136:
137: PROCEDURE Update_Filter_Row(
138: p_api_version_number IN NUMBER,
139: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
140: p_commit IN VARCHAR2 := FND_API.G_FALSE,
141: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,

Line 141: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

137: PROCEDURE Update_Filter_Row(
138: p_api_version_number IN NUMBER,
139: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
140: p_commit IN VARCHAR2 := FND_API.G_FALSE,
141: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_filter_rec IN filter_rec_type

Line 161: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

157: -- Parameters
158: --
159: -- IN
160: -- p_api_version_number IN NUMBER Required
161: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
162: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
163: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
164: -- p_query_param_id IN NUMBER
165: --

Line 162: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

158: --
159: -- IN
160: -- p_api_version_number IN NUMBER Required
161: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
162: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
163: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
164: -- p_query_param_id IN NUMBER
165: --
166: -- OUT NOCOPY

Line 163: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

159: -- IN
160: -- p_api_version_number IN NUMBER Required
161: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
162: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
163: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
164: -- p_query_param_id IN NUMBER
165: --
166: -- OUT NOCOPY
167: -- x_return_status OUT NOCOPY VARCHAR2

Line 176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

172:
173: PROCEDURE Delete_Filter_Row
174: (
175: p_api_version_number IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
177: p_commit IN VARCHAR2 := FND_API.G_FALSE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,

Line 177: p_commit IN VARCHAR2 := FND_API.G_FALSE,

173: PROCEDURE Delete_Filter_Row
174: (
175: p_api_version_number IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
177: p_commit IN VARCHAR2 := FND_API.G_FALSE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,

Line 178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

174: (
175: p_api_version_number IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
177: p_commit IN VARCHAR2 := FND_API.G_FALSE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_query_param_id IN NUMBER

Line 199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

195:
196: PROCEDURE Validate_Filter_Row
197: (
198: p_api_version_number IN NUMBER,
199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
201: p_filter_rec IN filter_rec_type,
202: p_validation_mode IN VARCHAR2,
203: x_return_status OUT NOCOPY VARCHAR2,

Line 200: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

196: PROCEDURE Validate_Filter_Row
197: (
198: p_api_version_number IN NUMBER,
199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
201: p_filter_rec IN filter_rec_type,
202: p_validation_mode IN VARCHAR2,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,

Line 239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

235:
236: PROCEDURE Validate_Filter_Row_Rec
237: (
238: p_api_version_number IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_filter_rec IN filter_rec_type

Line 262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

258: );
259:
260: PROCEDURE copy_filter_data (
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: p_objType IN VARCHAR2,
266: p_old_objectId IN NUMBER,

Line 263: p_commit IN VARCHAR2 := FND_API.G_FALSE,

259:
260: PROCEDURE copy_filter_data (
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: p_objType IN VARCHAR2,
266: p_old_objectId IN NUMBER,
267: p_new_objectId IN NUMBER,

Line 264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

260: PROCEDURE copy_filter_data (
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: p_objType IN VARCHAR2,
266: p_old_objectId IN NUMBER,
267: p_new_objectId IN NUMBER,
268: p_dataSourceId IN NUMBER,