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

Line 100: ctd_id NUMBER := FND_API.G_MISS_NUM,

96:
97: --===================================================================
98: TYPE ctd_rec_type IS RECORD
99: (
100: ctd_id NUMBER := FND_API.G_MISS_NUM,
101: action_id NUMBER := FND_API.G_MISS_NUM,
102: forward_url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
103: track_url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
104: activity_product_id NUMBER := FND_API.G_MISS_NUM,

Line 101: action_id NUMBER := FND_API.G_MISS_NUM,

97: --===================================================================
98: TYPE ctd_rec_type IS RECORD
99: (
100: ctd_id NUMBER := FND_API.G_MISS_NUM,
101: action_id NUMBER := FND_API.G_MISS_NUM,
102: forward_url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
103: track_url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
104: activity_product_id NUMBER := FND_API.G_MISS_NUM,
105: activity_offer_id NUMBER := FND_API.G_MISS_NUM,

Line 102: forward_url VARCHAR2(2000) := FND_API.G_MISS_CHAR,

98: TYPE ctd_rec_type IS RECORD
99: (
100: ctd_id NUMBER := FND_API.G_MISS_NUM,
101: action_id NUMBER := FND_API.G_MISS_NUM,
102: forward_url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
103: track_url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
104: activity_product_id NUMBER := FND_API.G_MISS_NUM,
105: activity_offer_id NUMBER := FND_API.G_MISS_NUM,
106: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 103: track_url VARCHAR2(2000) := FND_API.G_MISS_CHAR,

99: (
100: ctd_id NUMBER := FND_API.G_MISS_NUM,
101: action_id NUMBER := FND_API.G_MISS_NUM,
102: forward_url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
103: track_url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
104: activity_product_id NUMBER := FND_API.G_MISS_NUM,
105: activity_offer_id NUMBER := FND_API.G_MISS_NUM,
106: object_version_number NUMBER := FND_API.G_MISS_NUM,
107: last_update_date DATE := FND_API.G_MISS_DATE,

Line 104: activity_product_id NUMBER := FND_API.G_MISS_NUM,

100: ctd_id NUMBER := FND_API.G_MISS_NUM,
101: action_id NUMBER := FND_API.G_MISS_NUM,
102: forward_url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
103: track_url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
104: activity_product_id NUMBER := FND_API.G_MISS_NUM,
105: activity_offer_id NUMBER := FND_API.G_MISS_NUM,
106: object_version_number NUMBER := FND_API.G_MISS_NUM,
107: last_update_date DATE := FND_API.G_MISS_DATE,
108: last_updated_by NUMBER := FND_API.G_MISS_NUM,

Line 105: activity_offer_id NUMBER := FND_API.G_MISS_NUM,

101: action_id NUMBER := FND_API.G_MISS_NUM,
102: forward_url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
103: track_url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
104: activity_product_id NUMBER := FND_API.G_MISS_NUM,
105: activity_offer_id NUMBER := FND_API.G_MISS_NUM,
106: object_version_number NUMBER := FND_API.G_MISS_NUM,
107: last_update_date DATE := FND_API.G_MISS_DATE,
108: last_updated_by NUMBER := FND_API.G_MISS_NUM,
109: creation_date DATE := FND_API.G_MISS_DATE,

Line 106: object_version_number NUMBER := FND_API.G_MISS_NUM,

102: forward_url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
103: track_url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
104: activity_product_id NUMBER := FND_API.G_MISS_NUM,
105: activity_offer_id NUMBER := FND_API.G_MISS_NUM,
106: object_version_number NUMBER := FND_API.G_MISS_NUM,
107: last_update_date DATE := FND_API.G_MISS_DATE,
108: last_updated_by NUMBER := FND_API.G_MISS_NUM,
109: creation_date DATE := FND_API.G_MISS_DATE,
110: created_by NUMBER := FND_API.G_MISS_NUM,

Line 107: last_update_date DATE := FND_API.G_MISS_DATE,

103: track_url VARCHAR2(2000) := FND_API.G_MISS_CHAR,
104: activity_product_id NUMBER := FND_API.G_MISS_NUM,
105: activity_offer_id NUMBER := FND_API.G_MISS_NUM,
106: object_version_number NUMBER := FND_API.G_MISS_NUM,
107: last_update_date DATE := FND_API.G_MISS_DATE,
108: last_updated_by NUMBER := FND_API.G_MISS_NUM,
109: creation_date DATE := FND_API.G_MISS_DATE,
110: created_by NUMBER := FND_API.G_MISS_NUM,
111: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 108: last_updated_by NUMBER := FND_API.G_MISS_NUM,

104: activity_product_id NUMBER := FND_API.G_MISS_NUM,
105: activity_offer_id NUMBER := FND_API.G_MISS_NUM,
106: object_version_number NUMBER := FND_API.G_MISS_NUM,
107: last_update_date DATE := FND_API.G_MISS_DATE,
108: last_updated_by NUMBER := FND_API.G_MISS_NUM,
109: creation_date DATE := FND_API.G_MISS_DATE,
110: created_by NUMBER := FND_API.G_MISS_NUM,
111: last_update_login NUMBER := FND_API.G_MISS_NUM,
112: security_group_id NUMBER := FND_API.G_MISS_NUM

Line 109: creation_date DATE := FND_API.G_MISS_DATE,

105: activity_offer_id NUMBER := FND_API.G_MISS_NUM,
106: object_version_number NUMBER := FND_API.G_MISS_NUM,
107: last_update_date DATE := FND_API.G_MISS_DATE,
108: last_updated_by NUMBER := FND_API.G_MISS_NUM,
109: creation_date DATE := FND_API.G_MISS_DATE,
110: created_by NUMBER := FND_API.G_MISS_NUM,
111: last_update_login NUMBER := FND_API.G_MISS_NUM,
112: security_group_id NUMBER := FND_API.G_MISS_NUM
113: );

Line 110: created_by NUMBER := FND_API.G_MISS_NUM,

106: object_version_number NUMBER := FND_API.G_MISS_NUM,
107: last_update_date DATE := FND_API.G_MISS_DATE,
108: last_updated_by NUMBER := FND_API.G_MISS_NUM,
109: creation_date DATE := FND_API.G_MISS_DATE,
110: created_by NUMBER := FND_API.G_MISS_NUM,
111: last_update_login NUMBER := FND_API.G_MISS_NUM,
112: security_group_id NUMBER := FND_API.G_MISS_NUM
113: );
114:

Line 111: last_update_login NUMBER := FND_API.G_MISS_NUM,

107: last_update_date DATE := FND_API.G_MISS_DATE,
108: last_updated_by NUMBER := FND_API.G_MISS_NUM,
109: creation_date DATE := FND_API.G_MISS_DATE,
110: created_by NUMBER := FND_API.G_MISS_NUM,
111: last_update_login NUMBER := FND_API.G_MISS_NUM,
112: security_group_id NUMBER := FND_API.G_MISS_NUM
113: );
114:
115: g_miss_ctd_rec ctd_rec_type;

Line 112: security_group_id NUMBER := FND_API.G_MISS_NUM

108: last_updated_by NUMBER := FND_API.G_MISS_NUM,
109: creation_date DATE := FND_API.G_MISS_DATE,
110: created_by NUMBER := FND_API.G_MISS_NUM,
111: last_update_login NUMBER := FND_API.G_MISS_NUM,
112: security_group_id NUMBER := FND_API.G_MISS_NUM
113: );
114:
115: g_miss_ctd_rec ctd_rec_type;
116: TYPE ctd_tbl_type IS TABLE OF ctd_rec_type INDEX BY BINARY_INTEGER;

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

128: -- Parameters
129: --
130: -- IN
131: -- p_api_version_number IN NUMBER Required
132: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
133: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
134: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
135: -- p_ctd_rec IN ctd_rec_type Required
136: --

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

129: --
130: -- IN
131: -- p_api_version_number IN NUMBER Required
132: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
133: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
134: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
135: -- p_ctd_rec IN ctd_rec_type Required
136: --
137: -- OUT NOCOPY

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

130: -- IN
131: -- p_api_version_number IN NUMBER Required
132: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
133: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
134: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
135: -- p_ctd_rec IN ctd_rec_type Required
136: --
137: -- OUT NOCOPY
138: -- x_return_status OUT NOCOPY VARCHAR2

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

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

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

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

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

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

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

172: -- Parameters
173: --
174: -- IN
175: -- p_api_version_number IN NUMBER Required
176: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
177: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
179: -- p_ctd_rec IN ctd_rec_type Required
180: --

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

173: --
174: -- IN
175: -- p_api_version_number IN NUMBER Required
176: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
177: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
179: -- p_ctd_rec IN ctd_rec_type Required
180: --
181: -- OUT NOCOPY

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

174: -- IN
175: -- p_api_version_number IN NUMBER Required
176: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
177: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
179: -- p_ctd_rec IN ctd_rec_type Required
180: --
181: -- OUT NOCOPY
182: -- x_return_status OUT NOCOPY VARCHAR2

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

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

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

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

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

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

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

216: -- Parameters
217: --
218: -- IN
219: -- p_api_version_number IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
222: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
223: -- p_CTD_ID IN NUMBER
224: -- p_object_version_number IN NUMBER Optional Default = NULL

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

217: --
218: -- IN
219: -- p_api_version_number IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
222: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
223: -- p_CTD_ID IN NUMBER
224: -- p_object_version_number IN NUMBER Optional Default = NULL
225: --

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

218: -- IN
219: -- p_api_version_number IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
222: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
223: -- p_CTD_ID IN NUMBER
224: -- p_object_version_number IN NUMBER Optional Default = NULL
225: --
226: -- OUT NOCOPY

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

236: --
237:
238: PROCEDURE Delete_Ctd(
239: p_api_version_number IN NUMBER,
240: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
241: p_commit IN VARCHAR2 := FND_API.G_FALSE,
242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243: x_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,

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

237:
238: PROCEDURE Delete_Ctd(
239: p_api_version_number IN NUMBER,
240: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
241: p_commit IN VARCHAR2 := FND_API.G_FALSE,
242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243: x_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,
245: x_msg_data OUT NOCOPY VARCHAR2,

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

238: PROCEDURE Delete_Ctd(
239: p_api_version_number IN NUMBER,
240: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
241: p_commit IN VARCHAR2 := FND_API.G_FALSE,
242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243: x_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,
245: x_msg_data OUT NOCOPY VARCHAR2,
246: p_ctd_id IN NUMBER,

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

259: -- Parameters
260: --
261: -- IN
262: -- p_api_version_number IN NUMBER Required
263: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
264: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
265: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
266: -- p_ctd_rec IN ctd_rec_type Required
267: --

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

260: --
261: -- IN
262: -- p_api_version_number IN NUMBER Required
263: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
264: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
265: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
266: -- p_ctd_rec IN ctd_rec_type Required
267: --
268: -- OUT NOCOPY

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

261: -- IN
262: -- p_api_version_number IN NUMBER Required
263: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
264: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
265: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
266: -- p_ctd_rec IN ctd_rec_type Required
267: --
268: -- OUT NOCOPY
269: -- x_return_status OUT NOCOPY VARCHAR2

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

278: --
279:
280: PROCEDURE Lock_Ctd(
281: p_api_version_number IN NUMBER,
282: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
283:
284: x_return_status OUT NOCOPY VARCHAR2,
285: x_msg_count OUT NOCOPY NUMBER,
286: x_msg_data OUT NOCOPY VARCHAR2,

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

302: -- End of Comments
303:
304: PROCEDURE Validate_ctd(
305: p_api_version_number IN NUMBER,
306: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: p_ctd_rec IN ctd_rec_type,
309: x_return_status OUT NOCOPY VARCHAR2,
310: x_msg_count OUT NOCOPY NUMBER,

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

303:
304: PROCEDURE Validate_ctd(
305: p_api_version_number IN NUMBER,
306: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: p_ctd_rec IN ctd_rec_type,
309: x_return_status OUT NOCOPY VARCHAR2,
310: x_msg_count OUT NOCOPY NUMBER,
311: x_msg_data OUT NOCOPY VARCHAR2

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

340: -- End of Comments
341:
342: PROCEDURE Validate_ctd_rec(
343: p_api_version_number IN NUMBER,
344: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
345: x_return_status OUT NOCOPY VARCHAR2,
346: x_msg_count OUT NOCOPY NUMBER,
347: x_msg_data OUT NOCOPY VARCHAR2,
348: p_ctd_rec IN ctd_rec_type