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

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

1: PACKAGE AHL_UMP_NONROUTINES_PVT AUTHID CURRENT_USER AS
2: /* $Header: AHLVNRTS.pls 120.4.12020000.2 2012/12/13 02:52:18 sareepar ship $ */
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_UMP_NONROUTINES_PVT'; -- Use for all debug messages, FND_API.COMPATIBLE_API_CALL, etc
6:
7: -------------------------------
8: -- Define records and tables --
9: -------------------------------

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

160: PROCEDURE Update_SR
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 186: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 266: -- p_get_code VARCHAR2 Required, Default FND_API.G_FALSE

262: -- Pre-reqs :
263: --
264: -- Function params :
265: -- p_unit_effectivity_id NUMBER Required
266: -- p_get_code VARCHAR2 Required, Default FND_API.G_FALSE
267: --
268: -- Return type and typical values :
269: -- VARCHAR2 The relevant MEL/CDL status
270: --

Line 278: p_get_code VARCHAR2 := FND_API.G_FALSE

274: -- End of Comments --
275: FUNCTION Get_Mel_Cdl_Status
276: (
277: p_unit_effectivity_id NUMBER,
278: p_get_code VARCHAR2 := FND_API.G_FALSE
279: )
280: RETURN VARCHAR2;
281:
282: -----------------------