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

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_MEL_CDL_ATA_SEQS_PVT'; -- Use for all debug messages, FND_API.COMPATIBLE_API_CALL, etc

1: PACKAGE AHL_MEL_CDL_ATA_SEQS_PVT AUTHID CURRENT_USER AS
2: /* $Header: AHLVATAS.pls 120.2 2005/09/12 04:07 tamdas noship $ */
3:
4: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL'; -- Use for all FND_MESSAGE.SET_NAME calls
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_MEL_CDL_ATA_SEQS_PVT'; -- Use for all debug messages, FND_API.COMPATIBLE_API_CALL, etc
6:
7: -------------------------------
8: -- Define records and tables --
9: -------------------------------

Line 110: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE

106: -- Pre-reqs :
107: --
108: -- Standard IN Parameters :
109: -- p_api_version NUMBER Required
110: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
111: -- p_commit VARCHAR2 := FND_API.G_FALSE
112: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
113: -- p_default VARCHAR2 := FND_API.G_FALSE
114: -- p_module_type VARCHAR2 := NULL

Line 111: -- p_commit VARCHAR2 := FND_API.G_FALSE

107: --
108: -- Standard IN Parameters :
109: -- p_api_version NUMBER Required
110: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
111: -- p_commit VARCHAR2 := FND_API.G_FALSE
112: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
113: -- p_default VARCHAR2 := FND_API.G_FALSE
114: -- p_module_type VARCHAR2 := NULL
115: --

Line 112: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL

108: -- Standard IN Parameters :
109: -- p_api_version NUMBER Required
110: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
111: -- p_commit VARCHAR2 := FND_API.G_FALSE
112: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
113: -- p_default VARCHAR2 := FND_API.G_FALSE
114: -- p_module_type VARCHAR2 := NULL
115: --
116: -- Standard OUT Parameters :

Line 113: -- p_default VARCHAR2 := FND_API.G_FALSE

109: -- p_api_version NUMBER Required
110: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
111: -- p_commit VARCHAR2 := FND_API.G_FALSE
112: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
113: -- p_default VARCHAR2 := FND_API.G_FALSE
114: -- p_module_type VARCHAR2 := NULL
115: --
116: -- Standard OUT Parameters :
117: -- x_return_status VARCHAR2 Required

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

128: PROCEDURE Process_Ata_Sequences
129: (
130: -- Standard IN params
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133: p_commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: p_default IN VARCHAR2 := FND_API.G_FALSE,
136: p_module_type IN VARCHAR2 := NULL,

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

129: (
130: -- Standard IN params
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133: p_commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: p_default IN VARCHAR2 := FND_API.G_FALSE,
136: p_module_type IN VARCHAR2 := NULL,
137: -- Standard OUT params

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

130: -- Standard IN params
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133: p_commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: p_default IN VARCHAR2 := FND_API.G_FALSE,
136: p_module_type IN VARCHAR2 := NULL,
137: -- Standard OUT params
138: x_return_status OUT NOCOPY VARCHAR2,

Line 135: p_default IN VARCHAR2 := FND_API.G_FALSE,

131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133: p_commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: p_default IN VARCHAR2 := FND_API.G_FALSE,
136: p_module_type IN VARCHAR2 := NULL,
137: -- Standard OUT params
138: x_return_status OUT NOCOPY VARCHAR2,
139: x_msg_count OUT NOCOPY NUMBER,

Line 154: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE

150: -- Pre-reqs :
151: --
152: -- Standard IN Parameters :
153: -- p_api_version NUMBER Required
154: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
155: -- p_commit VARCHAR2 := FND_API.G_FALSE
156: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
157: -- p_default VARCHAR2 := FND_API.G_FALSE
158: -- p_module_type VARCHAR2 := NULL

Line 155: -- p_commit VARCHAR2 := FND_API.G_FALSE

151: --
152: -- Standard IN Parameters :
153: -- p_api_version NUMBER Required
154: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
155: -- p_commit VARCHAR2 := FND_API.G_FALSE
156: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
157: -- p_default VARCHAR2 := FND_API.G_FALSE
158: -- p_module_type VARCHAR2 := NULL
159: --

Line 156: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL

152: -- Standard IN Parameters :
153: -- p_api_version NUMBER Required
154: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
155: -- p_commit VARCHAR2 := FND_API.G_FALSE
156: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
157: -- p_default VARCHAR2 := FND_API.G_FALSE
158: -- p_module_type VARCHAR2 := NULL
159: --
160: -- Standard OUT Parameters :

Line 157: -- p_default VARCHAR2 := FND_API.G_FALSE

153: -- p_api_version NUMBER Required
154: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
155: -- p_commit VARCHAR2 := FND_API.G_FALSE
156: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
157: -- p_default VARCHAR2 := FND_API.G_FALSE
158: -- p_module_type VARCHAR2 := NULL
159: --
160: -- Standard OUT Parameters :
161: -- x_return_status VARCHAR2 Required

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

172: PROCEDURE Process_Mo_Procedures
173: (
174: -- Standard IN params
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
177: p_commit IN VARCHAR2 := FND_API.G_TRUE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179: p_default IN VARCHAR2 := FND_API.G_FALSE,
180: p_module_type IN VARCHAR2 := NULL,

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

173: (
174: -- Standard IN params
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
177: p_commit IN VARCHAR2 := FND_API.G_TRUE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179: p_default IN VARCHAR2 := FND_API.G_FALSE,
180: p_module_type IN VARCHAR2 := NULL,
181: -- Standard OUT params

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

174: -- Standard IN params
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
177: p_commit IN VARCHAR2 := FND_API.G_TRUE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179: p_default IN VARCHAR2 := FND_API.G_FALSE,
180: p_module_type IN VARCHAR2 := NULL,
181: -- Standard OUT params
182: x_return_status OUT NOCOPY VARCHAR2,

Line 179: p_default IN VARCHAR2 := FND_API.G_FALSE,

175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
177: p_commit IN VARCHAR2 := FND_API.G_TRUE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179: p_default IN VARCHAR2 := FND_API.G_FALSE,
180: p_module_type IN VARCHAR2 := NULL,
181: -- Standard OUT params
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,

Line 198: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE

194: -- Pre-reqs :
195: --
196: -- Standard IN Parameters :
197: -- p_api_version NUMBER Required
198: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
199: -- p_commit VARCHAR2 := FND_API.G_FALSE
200: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
201: -- p_default VARCHAR2 := FND_API.G_FALSE
202: -- p_module_type VARCHAR2 := NULL

Line 199: -- p_commit VARCHAR2 := FND_API.G_FALSE

195: --
196: -- Standard IN Parameters :
197: -- p_api_version NUMBER Required
198: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
199: -- p_commit VARCHAR2 := FND_API.G_FALSE
200: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
201: -- p_default VARCHAR2 := FND_API.G_FALSE
202: -- p_module_type VARCHAR2 := NULL
203: --

Line 200: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL

196: -- Standard IN Parameters :
197: -- p_api_version NUMBER Required
198: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
199: -- p_commit VARCHAR2 := FND_API.G_FALSE
200: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
201: -- p_default VARCHAR2 := FND_API.G_FALSE
202: -- p_module_type VARCHAR2 := NULL
203: --
204: -- Standard OUT Parameters :

Line 201: -- p_default VARCHAR2 := FND_API.G_FALSE

197: -- p_api_version NUMBER Required
198: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
199: -- p_commit VARCHAR2 := FND_API.G_FALSE
200: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
201: -- p_default VARCHAR2 := FND_API.G_FALSE
202: -- p_module_type VARCHAR2 := NULL
203: --
204: -- Standard OUT Parameters :
205: -- x_return_status VARCHAR2 Required

Line 220: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

216: PROCEDURE Process_Ata_Relations
217: (
218: -- Standard IN params
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
221: p_commit IN VARCHAR2 := FND_API.G_TRUE,
222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
223: p_default IN VARCHAR2 := FND_API.G_FALSE,
224: p_module_type IN VARCHAR2 := NULL,

Line 221: p_commit IN VARCHAR2 := FND_API.G_TRUE,

217: (
218: -- Standard IN params
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
221: p_commit IN VARCHAR2 := FND_API.G_TRUE,
222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
223: p_default IN VARCHAR2 := FND_API.G_FALSE,
224: p_module_type IN VARCHAR2 := NULL,
225: -- Standard OUT params

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

218: -- Standard IN params
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
221: p_commit IN VARCHAR2 := FND_API.G_TRUE,
222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
223: p_default IN VARCHAR2 := FND_API.G_FALSE,
224: p_module_type IN VARCHAR2 := NULL,
225: -- Standard OUT params
226: x_return_status OUT NOCOPY VARCHAR2,

Line 223: p_default IN VARCHAR2 := FND_API.G_FALSE,

219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
221: p_commit IN VARCHAR2 := FND_API.G_TRUE,
222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
223: p_default IN VARCHAR2 := FND_API.G_FALSE,
224: p_module_type IN VARCHAR2 := NULL,
225: -- Standard OUT params
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,

Line 241: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE

237: -- Pre-reqs :
238: --
239: -- Standard IN Parameters :
240: -- p_api_version NUMBER Required
241: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
242: -- p_commit VARCHAR2 := FND_API.G_FALSE
243: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
244: -- p_default VARCHAR2 := FND_API.G_FALSE
245: -- p_module_type VARCHAR2 := NULL

Line 242: -- p_commit VARCHAR2 := FND_API.G_FALSE

238: --
239: -- Standard IN Parameters :
240: -- p_api_version NUMBER Required
241: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
242: -- p_commit VARCHAR2 := FND_API.G_FALSE
243: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
244: -- p_default VARCHAR2 := FND_API.G_FALSE
245: -- p_module_type VARCHAR2 := NULL
246: --

Line 243: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL

239: -- Standard IN Parameters :
240: -- p_api_version NUMBER Required
241: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
242: -- p_commit VARCHAR2 := FND_API.G_FALSE
243: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
244: -- p_default VARCHAR2 := FND_API.G_FALSE
245: -- p_module_type VARCHAR2 := NULL
246: --
247: -- Standard OUT Parameters :

Line 244: -- p_default VARCHAR2 := FND_API.G_FALSE

240: -- p_api_version NUMBER Required
241: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
242: -- p_commit VARCHAR2 := FND_API.G_FALSE
243: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
244: -- p_default VARCHAR2 := FND_API.G_FALSE
245: -- p_module_type VARCHAR2 := NULL
246: --
247: -- Standard OUT Parameters :
248: -- x_return_status VARCHAR2 Required

Line 264: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

260: PROCEDURE Copy_MO_Proc_Revision
261: (
262: -- Standard IN params
263: p_api_version IN NUMBER,
264: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
265: p_commit IN VARCHAR2 := FND_API.G_TRUE,
266: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
267: p_default IN VARCHAR2 := FND_API.G_FALSE,
268: p_module_type IN VARCHAR2 := NULL,

Line 265: p_commit IN VARCHAR2 := FND_API.G_TRUE,

261: (
262: -- Standard IN params
263: p_api_version IN NUMBER,
264: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
265: p_commit IN VARCHAR2 := FND_API.G_TRUE,
266: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
267: p_default IN VARCHAR2 := FND_API.G_FALSE,
268: p_module_type IN VARCHAR2 := NULL,
269: -- Standard OUT params

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

262: -- Standard IN params
263: p_api_version IN NUMBER,
264: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
265: p_commit IN VARCHAR2 := FND_API.G_TRUE,
266: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
267: p_default IN VARCHAR2 := FND_API.G_FALSE,
268: p_module_type IN VARCHAR2 := NULL,
269: -- Standard OUT params
270: x_return_status OUT NOCOPY VARCHAR2,

Line 267: p_default IN VARCHAR2 := FND_API.G_FALSE,

263: p_api_version IN NUMBER,
264: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
265: p_commit IN VARCHAR2 := FND_API.G_TRUE,
266: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
267: p_default IN VARCHAR2 := FND_API.G_FALSE,
268: p_module_type IN VARCHAR2 := NULL,
269: -- Standard OUT params
270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,