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_MET_TPL_ASSOC_PVT dependencies on FND_API

Line 51: metric_tpl_assoc_id NUMBER := FND_API.G_MISS_NUM,

47:
48: --===================================================================
49: TYPE met_tpl_assoc_rec_type IS RECORD
50: (
51: metric_tpl_assoc_id NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,

Line 52: last_update_date DATE := FND_API.G_MISS_DATE,

48: --===================================================================
49: TYPE met_tpl_assoc_rec_type IS RECORD
50: (
51: metric_tpl_assoc_id NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 53: last_updated_by NUMBER := FND_API.G_MISS_NUM,

49: TYPE met_tpl_assoc_rec_type IS RECORD
50: (
51: metric_tpl_assoc_id NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 54: creation_date DATE := FND_API.G_MISS_DATE,

50: (
51: metric_tpl_assoc_id NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,

Line 55: created_by NUMBER := FND_API.G_MISS_NUM,

51: metric_tpl_assoc_id NUMBER := FND_API.G_MISS_NUM,
52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,
59: association_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 56: last_update_login NUMBER := FND_API.G_MISS_NUM,

52: last_update_date DATE := FND_API.G_MISS_DATE,
53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,
59: association_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: used_by_id NUMBER := FND_API.G_MISS_NUM,

Line 57: object_version_number NUMBER := FND_API.G_MISS_NUM,

53: last_updated_by NUMBER := FND_API.G_MISS_NUM,
54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,
59: association_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: used_by_id NUMBER := FND_API.G_MISS_NUM,
61: used_by_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 58: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,

54: creation_date DATE := FND_API.G_MISS_DATE,
55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,
59: association_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: used_by_id NUMBER := FND_API.G_MISS_NUM,
61: used_by_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 59: association_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

55: created_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,
59: association_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: used_by_id NUMBER := FND_API.G_MISS_NUM,
61: used_by_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
63: );

Line 60: used_by_id NUMBER := FND_API.G_MISS_NUM,

56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,
59: association_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: used_by_id NUMBER := FND_API.G_MISS_NUM,
61: used_by_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
63: );
64:

Line 61: used_by_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,
59: association_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: used_by_id NUMBER := FND_API.G_MISS_NUM,
61: used_by_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
63: );
64:
65: g_miss_met_tpl_assoc_rec met_tpl_assoc_rec_type;

Line 62: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

58: metric_tpl_header_id NUMBER := FND_API.G_MISS_NUM,
59: association_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: used_by_id NUMBER := FND_API.G_MISS_NUM,
61: used_by_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
63: );
64:
65: g_miss_met_tpl_assoc_rec met_tpl_assoc_rec_type;
66: TYPE met_tpl_assoc_tbl_type IS TABLE OF met_tpl_assoc_rec_type INDEX BY BINARY_INTEGER;

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

78: -- Parameters
79: --
80: -- IN
81: -- p_api_version_number IN NUMBER Required
82: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
83: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85: -- p_met_tpl_assoc_rec IN met_tpl_assoc_rec_type Required
86: --

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

79: --
80: -- IN
81: -- p_api_version_number IN NUMBER Required
82: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
83: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85: -- p_met_tpl_assoc_rec IN met_tpl_assoc_rec_type Required
86: --
87: -- OUT

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

80: -- IN
81: -- p_api_version_number IN NUMBER Required
82: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
83: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85: -- p_met_tpl_assoc_rec IN met_tpl_assoc_rec_type Required
86: --
87: -- OUT
88: -- x_return_status OUT VARCHAR2

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

97: --
98:
99: PROCEDURE Create_Met_Tpl_Assoc(
100: p_api_version_number IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104:
105: x_return_status OUT NOCOPY VARCHAR2,

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

98:
99: PROCEDURE Create_Met_Tpl_Assoc(
100: p_api_version_number IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104:
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,

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

99: PROCEDURE Create_Met_Tpl_Assoc(
100: p_api_version_number IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104:
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,

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

122: -- Parameters
123: --
124: -- IN
125: -- p_api_version_number IN NUMBER Required
126: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
127: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
128: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
129: -- p_met_tpl_assoc_rec IN met_tpl_assoc_rec_type Required
130: --

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

123: --
124: -- IN
125: -- p_api_version_number IN NUMBER Required
126: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
127: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
128: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
129: -- p_met_tpl_assoc_rec IN met_tpl_assoc_rec_type Required
130: --
131: -- OUT

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

124: -- IN
125: -- p_api_version_number IN NUMBER Required
126: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
127: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
128: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
129: -- p_met_tpl_assoc_rec IN met_tpl_assoc_rec_type Required
130: --
131: -- OUT
132: -- x_return_status OUT VARCHAR2

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

141: --
142:
143: PROCEDURE Update_Met_Tpl_Assoc(
144: p_api_version_number IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148:
149: x_return_status OUT NOCOPY VARCHAR2,

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

142:
143: PROCEDURE Update_Met_Tpl_Assoc(
144: p_api_version_number IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148:
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,

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

143: PROCEDURE Update_Met_Tpl_Assoc(
144: p_api_version_number IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148:
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,

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

166: -- Parameters
167: --
168: -- IN
169: -- p_api_version_number IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
171: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
172: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
173: -- p_AMS_METRIC_TPL_ASSOC_ID IN NUMBER
174: -- p_object_version_number IN NUMBER Optional Default = NULL

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

167: --
168: -- IN
169: -- p_api_version_number IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
171: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
172: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
173: -- p_AMS_METRIC_TPL_ASSOC_ID IN NUMBER
174: -- p_object_version_number IN NUMBER Optional Default = NULL
175: --

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

168: -- IN
169: -- p_api_version_number IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
171: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
172: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
173: -- p_AMS_METRIC_TPL_ASSOC_ID IN NUMBER
174: -- p_object_version_number IN NUMBER Optional Default = NULL
175: --
176: -- OUT

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

186: --
187:
188: PROCEDURE Delete_Met_Tpl_Assoc(
189: p_api_version_number IN NUMBER,
190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
191: p_commit IN VARCHAR2 := FND_API.G_FALSE,
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,

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

187:
188: PROCEDURE Delete_Met_Tpl_Assoc(
189: p_api_version_number IN NUMBER,
190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
191: p_commit IN VARCHAR2 := FND_API.G_FALSE,
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,

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

188: PROCEDURE Delete_Met_Tpl_Assoc(
189: p_api_version_number IN NUMBER,
190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
191: p_commit IN VARCHAR2 := FND_API.G_FALSE,
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,
196: p_metric_tpl_assoc_id IN NUMBER,

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

209: -- Parameters
210: --
211: -- IN
212: -- p_api_version_number IN NUMBER Required
213: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
214: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
215: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
216: -- p_met_tpl_assoc_rec IN met_tpl_assoc_rec_type Required
217: --

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

210: --
211: -- IN
212: -- p_api_version_number IN NUMBER Required
213: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
214: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
215: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
216: -- p_met_tpl_assoc_rec IN met_tpl_assoc_rec_type Required
217: --
218: -- OUT

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

211: -- IN
212: -- p_api_version_number IN NUMBER Required
213: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
214: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
215: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
216: -- p_met_tpl_assoc_rec IN met_tpl_assoc_rec_type Required
217: --
218: -- OUT
219: -- x_return_status OUT VARCHAR2

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

228: --
229:
230: PROCEDURE Lock_Met_Tpl_Assoc(
231: p_api_version_number IN NUMBER,
232: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
233:
234: x_return_status OUT NOCOPY VARCHAR2,
235: x_msg_count OUT NOCOPY NUMBER,
236: x_msg_data OUT NOCOPY VARCHAR2,

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

252: -- End of Comments
253:
254: PROCEDURE Validate_met_tpl_assoc(
255: p_api_version_number IN NUMBER,
256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
257: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
258: p_met_tpl_assoc_rec IN met_tpl_assoc_rec_type,
259: p_validation_mode IN VARCHAR2,
260: x_return_status OUT NOCOPY VARCHAR2,

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

253:
254: PROCEDURE Validate_met_tpl_assoc(
255: p_api_version_number IN NUMBER,
256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
257: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
258: p_met_tpl_assoc_rec IN met_tpl_assoc_rec_type,
259: p_validation_mode IN VARCHAR2,
260: x_return_status OUT NOCOPY VARCHAR2,
261: x_msg_count OUT NOCOPY NUMBER,

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

291: -- End of Comments
292:
293: PROCEDURE Validate_met_tpl_assoc_rec(
294: p_api_version_number IN NUMBER,
295: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,
299: p_met_tpl_assoc_rec IN met_tpl_assoc_rec_type