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

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

1: PACKAGE AHL_MEL_CDL_HEADERS_PVT AUTHID CURRENT_USER AS
2: /* $Header: AHLVMEHS.pls 120.0 2005/07/04 02:58 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_HEADERS_PVT'; -- Use for all debug messages, FND_API.COMPATIBLE_API_CALL, etc
6:
7: -------------------------------
8: -- Define records and tables --
9: -------------------------------

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

49: -- Pre-reqs :
50: --
51: -- Standard IN Parameters :
52: -- p_api_version NUMBER Required
53: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
54: -- p_commit VARCHAR2 := FND_API.G_FALSE
55: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
56: -- p_default VARCHAR2 := FND_API.G_FALSE
57: -- p_module_type VARCHAR2 := NULL

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

50: --
51: -- Standard IN Parameters :
52: -- p_api_version NUMBER Required
53: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
54: -- p_commit VARCHAR2 := FND_API.G_FALSE
55: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
56: -- p_default VARCHAR2 := FND_API.G_FALSE
57: -- p_module_type VARCHAR2 := NULL
58: --

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

51: -- Standard IN Parameters :
52: -- p_api_version NUMBER Required
53: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
54: -- p_commit VARCHAR2 := FND_API.G_FALSE
55: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
56: -- p_default VARCHAR2 := FND_API.G_FALSE
57: -- p_module_type VARCHAR2 := NULL
58: --
59: -- Standard OUT Parameters :

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

52: -- p_api_version NUMBER Required
53: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
54: -- p_commit VARCHAR2 := FND_API.G_FALSE
55: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
56: -- p_default VARCHAR2 := FND_API.G_FALSE
57: -- p_module_type VARCHAR2 := NULL
58: --
59: -- Standard OUT Parameters :
60: -- x_return_status VARCHAR2 Required

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

71: PROCEDURE Create_Mel_Cdl
72: (
73: -- Standard IN params
74: p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76: p_commit IN VARCHAR2 := FND_API.G_FALSE,
77: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78: p_default IN VARCHAR2 := FND_API.G_FALSE,
79: p_module_type IN VARCHAR2 := NULL,

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

72: (
73: -- Standard IN params
74: p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76: p_commit IN VARCHAR2 := FND_API.G_FALSE,
77: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78: p_default IN VARCHAR2 := FND_API.G_FALSE,
79: p_module_type IN VARCHAR2 := NULL,
80: -- Standard OUT params

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

73: -- Standard IN params
74: p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76: p_commit IN VARCHAR2 := FND_API.G_FALSE,
77: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78: p_default IN VARCHAR2 := FND_API.G_FALSE,
79: p_module_type IN VARCHAR2 := NULL,
80: -- Standard OUT params
81: x_return_status OUT NOCOPY VARCHAR2,

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

74: p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76: p_commit IN VARCHAR2 := FND_API.G_FALSE,
77: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78: p_default IN VARCHAR2 := FND_API.G_FALSE,
79: p_module_type IN VARCHAR2 := NULL,
80: -- Standard OUT params
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,

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

93: -- Pre-reqs :
94: --
95: -- Standard IN Parameters :
96: -- p_api_version NUMBER Required
97: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
98: -- p_commit VARCHAR2 := FND_API.G_FALSE
99: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
100: -- p_default VARCHAR2 := FND_API.G_FALSE
101: -- p_module_type VARCHAR2 := NULL

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

94: --
95: -- Standard IN Parameters :
96: -- p_api_version NUMBER Required
97: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
98: -- p_commit VARCHAR2 := FND_API.G_FALSE
99: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
100: -- p_default VARCHAR2 := FND_API.G_FALSE
101: -- p_module_type VARCHAR2 := NULL
102: --

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

95: -- Standard IN Parameters :
96: -- p_api_version NUMBER Required
97: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
98: -- p_commit VARCHAR2 := FND_API.G_FALSE
99: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
100: -- p_default VARCHAR2 := FND_API.G_FALSE
101: -- p_module_type VARCHAR2 := NULL
102: --
103: -- Standard OUT Parameters :

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

96: -- p_api_version NUMBER Required
97: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
98: -- p_commit VARCHAR2 := FND_API.G_FALSE
99: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
100: -- p_default VARCHAR2 := FND_API.G_FALSE
101: -- p_module_type VARCHAR2 := NULL
102: --
103: -- Standard OUT Parameters :
104: -- x_return_status VARCHAR2 Required

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

115: PROCEDURE Update_Mel_Cdl
116: (
117: -- Standard IN params
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: p_default IN VARCHAR2 := FND_API.G_FALSE,
123: p_module_type IN VARCHAR2 := NULL,

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

116: (
117: -- Standard IN params
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: p_default IN VARCHAR2 := FND_API.G_FALSE,
123: p_module_type IN VARCHAR2 := NULL,
124: -- Standard OUT params

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

117: -- Standard IN params
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: p_default IN VARCHAR2 := FND_API.G_FALSE,
123: p_module_type IN VARCHAR2 := NULL,
124: -- Standard OUT params
125: x_return_status OUT NOCOPY VARCHAR2,

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

118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120: p_commit IN VARCHAR2 := FND_API.G_FALSE,
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: p_default IN VARCHAR2 := FND_API.G_FALSE,
123: p_module_type IN VARCHAR2 := NULL,
124: -- Standard OUT params
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,

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

137: -- Pre-reqs :
138: --
139: -- Standard IN Parameters :
140: -- p_api_version NUMBER Required
141: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
142: -- p_commit VARCHAR2 := FND_API.G_FALSE
143: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
144: -- p_default VARCHAR2 := FND_API.G_FALSE
145: -- p_module_type VARCHAR2 := NULL

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

138: --
139: -- Standard IN Parameters :
140: -- p_api_version NUMBER Required
141: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
142: -- p_commit VARCHAR2 := FND_API.G_FALSE
143: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
144: -- p_default VARCHAR2 := FND_API.G_FALSE
145: -- p_module_type VARCHAR2 := NULL
146: --

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

139: -- Standard IN Parameters :
140: -- p_api_version NUMBER Required
141: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
142: -- p_commit VARCHAR2 := FND_API.G_FALSE
143: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
144: -- p_default VARCHAR2 := FND_API.G_FALSE
145: -- p_module_type VARCHAR2 := NULL
146: --
147: -- Standard OUT Parameters :

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

140: -- p_api_version NUMBER Required
141: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
142: -- p_commit VARCHAR2 := FND_API.G_FALSE
143: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
144: -- p_default VARCHAR2 := FND_API.G_FALSE
145: -- p_module_type VARCHAR2 := NULL
146: --
147: -- Standard OUT Parameters :
148: -- x_return_status VARCHAR2 Required

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

160: PROCEDURE Delete_Mel_Cdl
161: (
162: -- Standard IN params
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: p_default IN VARCHAR2 := FND_API.G_FALSE,
168: p_module_type IN VARCHAR2 := NULL,

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

161: (
162: -- Standard IN params
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: p_default IN VARCHAR2 := FND_API.G_FALSE,
168: p_module_type IN VARCHAR2 := NULL,
169: -- Standard OUT params

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

162: -- Standard IN params
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: p_default IN VARCHAR2 := FND_API.G_FALSE,
168: p_module_type IN VARCHAR2 := NULL,
169: -- Standard OUT params
170: x_return_status OUT NOCOPY VARCHAR2,

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

163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: p_default IN VARCHAR2 := FND_API.G_FALSE,
168: p_module_type IN VARCHAR2 := NULL,
169: -- Standard OUT params
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,

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

183: -- Pre-reqs :
184: --
185: -- Standard IN Parameters :
186: -- p_api_version NUMBER Required
187: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
188: -- p_commit VARCHAR2 := FND_API.G_FALSE
189: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
190: -- p_default VARCHAR2 := FND_API.G_FALSE
191: -- p_module_type VARCHAR2 := NULL

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

184: --
185: -- Standard IN Parameters :
186: -- p_api_version NUMBER Required
187: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
188: -- p_commit VARCHAR2 := FND_API.G_FALSE
189: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
190: -- p_default VARCHAR2 := FND_API.G_FALSE
191: -- p_module_type VARCHAR2 := NULL
192: --

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

185: -- Standard IN Parameters :
186: -- p_api_version NUMBER Required
187: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
188: -- p_commit VARCHAR2 := FND_API.G_FALSE
189: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
190: -- p_default VARCHAR2 := FND_API.G_FALSE
191: -- p_module_type VARCHAR2 := NULL
192: --
193: -- Standard OUT Parameters :

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

186: -- p_api_version NUMBER Required
187: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
188: -- p_commit VARCHAR2 := FND_API.G_FALSE
189: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
190: -- p_default VARCHAR2 := FND_API.G_FALSE
191: -- p_module_type VARCHAR2 := NULL
192: --
193: -- Standard OUT Parameters :
194: -- x_return_status VARCHAR2 Required

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

207: PROCEDURE Create_Mel_Cdl_Revision
208: (
209: -- Standard IN params
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE,
213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214: p_default IN VARCHAR2 := FND_API.G_FALSE,
215: p_module_type IN VARCHAR2 := NULL,

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

208: (
209: -- Standard IN params
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE,
213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214: p_default IN VARCHAR2 := FND_API.G_FALSE,
215: p_module_type IN VARCHAR2 := NULL,
216: -- Standard OUT params

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

209: -- Standard IN params
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE,
213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214: p_default IN VARCHAR2 := FND_API.G_FALSE,
215: p_module_type IN VARCHAR2 := NULL,
216: -- Standard OUT params
217: x_return_status OUT NOCOPY VARCHAR2,

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

210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE,
213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214: p_default IN VARCHAR2 := FND_API.G_FALSE,
215: p_module_type IN VARCHAR2 := NULL,
216: -- Standard OUT params
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,

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

231: -- Pre-reqs :
232: --
233: -- Standard IN Parameters :
234: -- p_api_version NUMBER Required
235: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
236: -- p_commit VARCHAR2 := FND_API.G_FALSE
237: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
238: -- p_default VARCHAR2 := FND_API.G_FALSE
239: -- p_module_type VARCHAR2 := NULL

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

232: --
233: -- Standard IN Parameters :
234: -- p_api_version NUMBER Required
235: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
236: -- p_commit VARCHAR2 := FND_API.G_FALSE
237: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
238: -- p_default VARCHAR2 := FND_API.G_FALSE
239: -- p_module_type VARCHAR2 := NULL
240: --

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

233: -- Standard IN Parameters :
234: -- p_api_version NUMBER Required
235: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
236: -- p_commit VARCHAR2 := FND_API.G_FALSE
237: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
238: -- p_default VARCHAR2 := FND_API.G_FALSE
239: -- p_module_type VARCHAR2 := NULL
240: --
241: -- Standard OUT Parameters :

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

234: -- p_api_version NUMBER Required
235: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
236: -- p_commit VARCHAR2 := FND_API.G_FALSE
237: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
238: -- p_default VARCHAR2 := FND_API.G_FALSE
239: -- p_module_type VARCHAR2 := NULL
240: --
241: -- Standard OUT Parameters :
242: -- x_return_status VARCHAR2 Required

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

254: PROCEDURE Initiate_Mel_Cdl_Approval
255: (
256: -- Standard IN params
257: p_api_version IN NUMBER,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259: p_commit IN VARCHAR2 := FND_API.G_FALSE,
260: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261: p_default IN VARCHAR2 := FND_API.G_FALSE,
262: p_module_type IN VARCHAR2 := NULL,

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

255: (
256: -- Standard IN params
257: p_api_version IN NUMBER,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259: p_commit IN VARCHAR2 := FND_API.G_FALSE,
260: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261: p_default IN VARCHAR2 := FND_API.G_FALSE,
262: p_module_type IN VARCHAR2 := NULL,
263: -- Standard OUT params

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

256: -- Standard IN params
257: p_api_version IN NUMBER,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259: p_commit IN VARCHAR2 := FND_API.G_FALSE,
260: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261: p_default IN VARCHAR2 := FND_API.G_FALSE,
262: p_module_type IN VARCHAR2 := NULL,
263: -- Standard OUT params
264: x_return_status OUT NOCOPY VARCHAR2,

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

257: p_api_version IN NUMBER,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259: p_commit IN VARCHAR2 := FND_API.G_FALSE,
260: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261: p_default IN VARCHAR2 := FND_API.G_FALSE,
262: p_module_type IN VARCHAR2 := NULL,
263: -- Standard OUT params
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,