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.

[Home] [Help]

APPS.AMS_DM_TARGET_PVT dependencies on FND_API

Line 53: target_id NUMBER := FND_API.G_MISS_NUM,

49:
50: --===================================================================
51: TYPE dm_target_rec_type IS RECORD
52: (
53: target_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_rec_type IS RECORD
52: (
53: target_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_rec_type IS RECORD
52: (
53: target_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_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: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 57: created_by NUMBER := FND_API.G_MISS_NUM,

53: target_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: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: model_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

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: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: model_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: data_source_id NUMBER := FND_API.G_MISS_NUM,

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: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: model_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: data_source_id NUMBER := FND_API.G_MISS_NUM,
63: source_field_id NUMBER := FND_API.G_MISS_NUM,

Line 60: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

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: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: model_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: data_source_id NUMBER := FND_API.G_MISS_NUM,
63: source_field_id NUMBER := FND_API.G_MISS_NUM,
64: target_name VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

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: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: model_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: data_source_id NUMBER := FND_API.G_MISS_NUM,
63: source_field_id NUMBER := FND_API.G_MISS_NUM,
64: target_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,

Line 62: data_source_id 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: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: model_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: data_source_id NUMBER := FND_API.G_MISS_NUM,
63: source_field_id NUMBER := FND_API.G_MISS_NUM,
64: target_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
66: target_source_id NUMBER := FND_API.G_MISS_NUM

Line 63: source_field_id NUMBER := FND_API.G_MISS_NUM,

59: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: model_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: data_source_id NUMBER := FND_API.G_MISS_NUM,
63: source_field_id NUMBER := FND_API.G_MISS_NUM,
64: target_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
66: target_source_id NUMBER := FND_API.G_MISS_NUM
67: );

Line 64: target_name VARCHAR2(240) := FND_API.G_MISS_CHAR,

60: active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: model_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: data_source_id NUMBER := FND_API.G_MISS_NUM,
63: source_field_id NUMBER := FND_API.G_MISS_NUM,
64: target_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
66: target_source_id NUMBER := FND_API.G_MISS_NUM
67: );
68:

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

61: model_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: data_source_id NUMBER := FND_API.G_MISS_NUM,
63: source_field_id NUMBER := FND_API.G_MISS_NUM,
64: target_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
66: target_source_id NUMBER := FND_API.G_MISS_NUM
67: );
68:
69: g_miss_dm_target_rec dm_target_rec_type;

Line 66: target_source_id NUMBER := FND_API.G_MISS_NUM

62: data_source_id NUMBER := FND_API.G_MISS_NUM,
63: source_field_id NUMBER := FND_API.G_MISS_NUM,
64: target_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
66: target_source_id NUMBER := FND_API.G_MISS_NUM
67: );
68:
69: g_miss_dm_target_rec dm_target_rec_type;
70: TYPE dm_target_tbl_type IS TABLE OF dm_target_rec_type INDEX BY BINARY_INTEGER;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

256: -- End of Comments
257:
258: PROCEDURE Validate_dmtarget(
259: p_api_version_number IN NUMBER,
260: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
262: p_dm_target_rec IN dm_target_rec_type,
263: p_validation_mode IN VARCHAR2,
264: x_return_status OUT NOCOPY VARCHAR2,

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

257:
258: PROCEDURE Validate_dmtarget(
259: p_api_version_number IN NUMBER,
260: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
262: p_dm_target_rec IN dm_target_rec_type,
263: p_validation_mode IN VARCHAR2,
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,

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

295: -- End of Comments
296:
297: PROCEDURE Validate_dm_target_rec(
298: p_api_version_number IN NUMBER,
299: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
300: x_return_status OUT NOCOPY VARCHAR2,
301: x_msg_count OUT NOCOPY NUMBER,
302: x_msg_data OUT NOCOPY VARCHAR2,
303: p_dm_target_rec IN dm_target_rec_type