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

Line 53: target_value_id NUMBER := FND_API.G_MISS_NUM,

49:
50: --===================================================================
51: TYPE dm_target_value_rec_type IS RECORD
52: (
53: target_value_id NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: creation_date DATE := FND_API.G_MISS_DATE,
57: created_by NUMBER := FND_API.G_MISS_NUM,

Line 54: last_update_date DATE := FND_API.G_MISS_DATE,

50: --===================================================================
51: TYPE dm_target_value_rec_type IS RECORD
52: (
53: target_value_id NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: creation_date DATE := FND_API.G_MISS_DATE,
57: created_by NUMBER := FND_API.G_MISS_NUM,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 55: last_updated_by NUMBER := FND_API.G_MISS_NUM,

51: TYPE dm_target_value_rec_type IS RECORD
52: (
53: target_value_id NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: creation_date DATE := FND_API.G_MISS_DATE,
57: created_by NUMBER := FND_API.G_MISS_NUM,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 56: creation_date DATE := FND_API.G_MISS_DATE,

52: (
53: target_value_id NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: creation_date DATE := FND_API.G_MISS_DATE,
57: created_by NUMBER := FND_API.G_MISS_NUM,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: security_group_id NUMBER := FND_API.G_MISS_NUM,

Line 57: created_by NUMBER := FND_API.G_MISS_NUM,

53: target_value_id NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: creation_date DATE := FND_API.G_MISS_DATE,
57: created_by NUMBER := FND_API.G_MISS_NUM,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: security_group_id NUMBER := FND_API.G_MISS_NUM,
61: target_id NUMBER := FND_API.G_MISS_NUM,

Line 58: last_update_login NUMBER := FND_API.G_MISS_NUM,

54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: creation_date DATE := FND_API.G_MISS_DATE,
57: created_by NUMBER := FND_API.G_MISS_NUM,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: security_group_id NUMBER := FND_API.G_MISS_NUM,
61: target_id NUMBER := FND_API.G_MISS_NUM,
62: target_value VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 59: object_version_number NUMBER := FND_API.G_MISS_NUM,

55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: creation_date DATE := FND_API.G_MISS_DATE,
57: created_by NUMBER := FND_API.G_MISS_NUM,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: security_group_id NUMBER := FND_API.G_MISS_NUM,
61: target_id NUMBER := FND_API.G_MISS_NUM,
62: target_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: target_operator VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 60: security_group_id NUMBER := FND_API.G_MISS_NUM,

56: creation_date DATE := FND_API.G_MISS_DATE,
57: created_by NUMBER := FND_API.G_MISS_NUM,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: security_group_id NUMBER := FND_API.G_MISS_NUM,
61: target_id NUMBER := FND_API.G_MISS_NUM,
62: target_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: target_operator VARCHAR2(10) := FND_API.G_MISS_CHAR,
64: range_value VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 61: target_id NUMBER := FND_API.G_MISS_NUM,

57: created_by NUMBER := FND_API.G_MISS_NUM,
58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: security_group_id NUMBER := FND_API.G_MISS_NUM,
61: target_id NUMBER := FND_API.G_MISS_NUM,
62: target_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: target_operator VARCHAR2(10) := FND_API.G_MISS_CHAR,
64: range_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: description VARCHAR2(4000) := FND_API.G_MISS_CHAR

Line 62: target_value VARCHAR2(30) := FND_API.G_MISS_CHAR,

58: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: security_group_id NUMBER := FND_API.G_MISS_NUM,
61: target_id NUMBER := FND_API.G_MISS_NUM,
62: target_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: target_operator VARCHAR2(10) := FND_API.G_MISS_CHAR,
64: range_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
66: );

Line 63: target_operator VARCHAR2(10) := FND_API.G_MISS_CHAR,

59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: security_group_id NUMBER := FND_API.G_MISS_NUM,
61: target_id NUMBER := FND_API.G_MISS_NUM,
62: target_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: target_operator VARCHAR2(10) := FND_API.G_MISS_CHAR,
64: range_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
66: );
67:

Line 64: range_value VARCHAR2(30) := FND_API.G_MISS_CHAR,

60: security_group_id NUMBER := FND_API.G_MISS_NUM,
61: target_id NUMBER := FND_API.G_MISS_NUM,
62: target_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: target_operator VARCHAR2(10) := FND_API.G_MISS_CHAR,
64: range_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
66: );
67:
68: g_miss_dm_target_value_rec dm_target_value_rec_type;

Line 65: description VARCHAR2(4000) := FND_API.G_MISS_CHAR

61: target_id NUMBER := FND_API.G_MISS_NUM,
62: target_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: target_operator VARCHAR2(10) := FND_API.G_MISS_CHAR,
64: range_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
66: );
67:
68: g_miss_dm_target_value_rec dm_target_value_rec_type;
69: TYPE dm_target_value_tbl_type IS TABLE OF dm_target_value_rec_type INDEX BY BINARY_INTEGER;

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

81: -- Parameters
82: --
83: -- IN
84: -- p_api_version_number IN NUMBER Required
85: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
86: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
87: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
88: -- p_dm_target_value_rec IN dm_target_value_rec_type Required
89: --

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

82: --
83: -- IN
84: -- p_api_version_number IN NUMBER Required
85: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
86: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
87: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
88: -- p_dm_target_value_rec IN dm_target_value_rec_type Required
89: --
90: -- OUT

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

83: -- IN
84: -- p_api_version_number IN NUMBER Required
85: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
86: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
87: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
88: -- p_dm_target_value_rec IN dm_target_value_rec_type Required
89: --
90: -- OUT
91: -- x_return_status OUT VARCHAR2

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

100: --
101:
102: PROCEDURE Create_Dm_Target_Value(
103: p_api_version_number IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105: p_commit IN VARCHAR2 := FND_API.G_FALSE,
106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107:
108: x_return_status OUT NOCOPY VARCHAR2,

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

101:
102: PROCEDURE Create_Dm_Target_Value(
103: p_api_version_number IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105: p_commit IN VARCHAR2 := FND_API.G_FALSE,
106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107:
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,

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

102: PROCEDURE Create_Dm_Target_Value(
103: p_api_version_number IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105: p_commit IN VARCHAR2 := FND_API.G_FALSE,
106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107:
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,

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

125: -- Parameters
126: --
127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_dm_target_value_rec IN dm_target_value_rec_type Required
133: --

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

126: --
127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_dm_target_value_rec IN dm_target_value_rec_type Required
133: --
134: -- OUT

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

127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_dm_target_value_rec IN dm_target_value_rec_type Required
133: --
134: -- OUT
135: -- x_return_status OUT VARCHAR2

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

144: --
145:
146: PROCEDURE Update_Dm_Target_Value(
147: p_api_version_number IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151:
152: x_return_status OUT NOCOPY VARCHAR2,

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

145:
146: PROCEDURE Update_Dm_Target_Value(
147: p_api_version_number IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151:
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,

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

146: PROCEDURE Update_Dm_Target_Value(
147: p_api_version_number IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151:
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,

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

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

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

170: --
171: -- IN
172: -- p_api_version_number IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_TARGET_VALUE_ID IN NUMBER
177: -- p_object_version_number IN NUMBER Optional Default = NULL
178: --

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

171: -- IN
172: -- p_api_version_number IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_TARGET_VALUE_ID IN NUMBER
177: -- p_object_version_number IN NUMBER Optional Default = NULL
178: --
179: -- OUT

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

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

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

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

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

191: PROCEDURE Delete_Dm_Target_Value(
192: p_api_version_number IN NUMBER,
193: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
194: p_commit IN VARCHAR2 := FND_API.G_FALSE,
195: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,
199: p_target_value_id IN NUMBER,

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

212: -- Parameters
213: --
214: -- IN
215: -- p_api_version_number IN NUMBER Required
216: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
217: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
218: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
219: -- p_dm_target_value_rec IN dm_target_value_rec_type Required
220: --

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

213: --
214: -- IN
215: -- p_api_version_number IN NUMBER Required
216: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
217: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
218: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
219: -- p_dm_target_value_rec IN dm_target_value_rec_type Required
220: --
221: -- OUT

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

214: -- IN
215: -- p_api_version_number IN NUMBER Required
216: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
217: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
218: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
219: -- p_dm_target_value_rec IN dm_target_value_rec_type Required
220: --
221: -- OUT
222: -- x_return_status OUT VARCHAR2

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

231: --
232:
233: PROCEDURE Lock_Dm_Target_Value(
234: p_api_version_number IN NUMBER,
235: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
236:
237: x_return_status OUT NOCOPY VARCHAR2,
238: x_msg_count OUT NOCOPY NUMBER,
239: x_msg_data OUT NOCOPY VARCHAR2,

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

255: -- End of Comments
256:
257: PROCEDURE Validate_dm_target_value(
258: p_api_version_number IN NUMBER,
259: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
260: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261: p_dm_target_value_rec IN dm_target_value_rec_type,
262: p_validation_mode IN VARCHAR2,
263: x_return_status OUT NOCOPY VARCHAR2,

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

256:
257: PROCEDURE Validate_dm_target_value(
258: p_api_version_number IN NUMBER,
259: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
260: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261: p_dm_target_value_rec IN dm_target_value_rec_type,
262: p_validation_mode IN VARCHAR2,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,

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

294: -- End of Comments
295:
296: PROCEDURE Validate_dm_target_value_rec(
297: p_api_version_number IN NUMBER,
298: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
299: x_return_status OUT NOCOPY VARCHAR2,
300: x_msg_count OUT NOCOPY NUMBER,
301: x_msg_data OUT NOCOPY VARCHAR2,
302: p_dm_target_value_rec IN dm_target_value_rec_type