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 AS
2: /* $Header: AHLVNRTS.pls 120.2 2008/02/29 07:45:09 sracha 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 78: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE

74: -- Pre-reqs :
75: --
76: -- Standard IN Parameters :
77: -- p_api_version NUMBER Required
78: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
79: -- p_commit VARCHAR2 := FND_API.G_FALSE
80: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
81: -- p_default VARCHAR2 := FND_API.G_FALSE
82: -- p_module_type VARCHAR2 := NULL

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

75: --
76: -- Standard IN Parameters :
77: -- p_api_version NUMBER Required
78: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
79: -- p_commit VARCHAR2 := FND_API.G_FALSE
80: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
81: -- p_default VARCHAR2 := FND_API.G_FALSE
82: -- p_module_type VARCHAR2 := NULL
83: --

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

76: -- Standard IN Parameters :
77: -- p_api_version NUMBER Required
78: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
79: -- p_commit VARCHAR2 := FND_API.G_FALSE
80: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
81: -- p_default VARCHAR2 := FND_API.G_FALSE
82: -- p_module_type VARCHAR2 := NULL
83: --
84: -- Standard OUT Parameters :

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

77: -- p_api_version NUMBER Required
78: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
79: -- p_commit VARCHAR2 := FND_API.G_FALSE
80: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
81: -- p_default VARCHAR2 := FND_API.G_FALSE
82: -- p_module_type VARCHAR2 := NULL
83: --
84: -- Standard OUT Parameters :
85: -- x_return_status VARCHAR2 Required

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

96: PROCEDURE Create_SR
97: (
98: -- Standard IN params
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: p_default IN VARCHAR2 := FND_API.G_FALSE,
104: p_module_type IN VARCHAR2 := NULL,

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

97: (
98: -- Standard IN params
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: p_default IN VARCHAR2 := FND_API.G_FALSE,
104: p_module_type IN VARCHAR2 := NULL,
105: -- Standard OUT params

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

98: -- Standard IN params
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: p_default IN VARCHAR2 := FND_API.G_FALSE,
104: p_module_type IN VARCHAR2 := NULL,
105: -- Standard OUT params
106: x_return_status OUT NOCOPY VARCHAR2,

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

99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: p_default IN VARCHAR2 := FND_API.G_FALSE,
104: p_module_type IN VARCHAR2 := NULL,
105: -- Standard OUT params
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,

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

118: -- Pre-reqs :
119: --
120: -- Standard IN Parameters :
121: -- p_api_version NUMBER Required
122: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
123: -- p_commit VARCHAR2 := FND_API.G_FALSE
124: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
125: -- p_default VARCHAR2 := FND_API.G_FALSE
126: -- p_module_type VARCHAR2 := NULL

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

119: --
120: -- Standard IN Parameters :
121: -- p_api_version NUMBER Required
122: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
123: -- p_commit VARCHAR2 := FND_API.G_FALSE
124: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
125: -- p_default VARCHAR2 := FND_API.G_FALSE
126: -- p_module_type VARCHAR2 := NULL
127: --

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

120: -- Standard IN Parameters :
121: -- p_api_version NUMBER Required
122: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
123: -- p_commit VARCHAR2 := FND_API.G_FALSE
124: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
125: -- p_default VARCHAR2 := FND_API.G_FALSE
126: -- p_module_type VARCHAR2 := NULL
127: --
128: -- Standard OUT Parameters :

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

121: -- p_api_version NUMBER Required
122: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
123: -- p_commit VARCHAR2 := FND_API.G_FALSE
124: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
125: -- p_default VARCHAR2 := FND_API.G_FALSE
126: -- p_module_type VARCHAR2 := NULL
127: --
128: -- Standard OUT Parameters :
129: -- x_return_status VARCHAR2 Required

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

140: PROCEDURE Update_SR
141: (
142: -- Standard IN params
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_default IN VARCHAR2 := FND_API.G_FALSE,
148: p_module_type IN VARCHAR2 := NULL,

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

141: (
142: -- Standard IN params
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_default IN VARCHAR2 := FND_API.G_FALSE,
148: p_module_type IN VARCHAR2 := NULL,
149: -- Standard OUT params

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

142: -- Standard IN params
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_default IN VARCHAR2 := FND_API.G_FALSE,
148: p_module_type IN VARCHAR2 := NULL,
149: -- Standard OUT params
150: x_return_status OUT NOCOPY VARCHAR2,

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

143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_default IN VARCHAR2 := FND_API.G_FALSE,
148: p_module_type IN VARCHAR2 := NULL,
149: -- Standard OUT params
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,

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

162: -- Pre-reqs :
163: --
164: -- Standard IN Parameters :
165: -- p_api_version NUMBER Required
166: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
167: -- p_commit VARCHAR2 := FND_API.G_FALSE
168: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
169: -- p_default VARCHAR2 := FND_API.G_FALSE
170: -- p_module_type VARCHAR2 := NULL

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

163: --
164: -- Standard IN Parameters :
165: -- p_api_version NUMBER Required
166: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
167: -- p_commit VARCHAR2 := FND_API.G_FALSE
168: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
169: -- p_default VARCHAR2 := FND_API.G_FALSE
170: -- p_module_type VARCHAR2 := NULL
171: --

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

164: -- Standard IN Parameters :
165: -- p_api_version NUMBER Required
166: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
167: -- p_commit VARCHAR2 := FND_API.G_FALSE
168: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
169: -- p_default VARCHAR2 := FND_API.G_FALSE
170: -- p_module_type VARCHAR2 := NULL
171: --
172: -- Standard OUT Parameters :

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

165: -- p_api_version NUMBER Required
166: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
167: -- p_commit VARCHAR2 := FND_API.G_FALSE
168: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
169: -- p_default VARCHAR2 := FND_API.G_FALSE
170: -- p_module_type VARCHAR2 := NULL
171: --
172: -- Standard OUT Parameters :
173: -- x_return_status VARCHAR2 Required

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

185: PROCEDURE Initiate_Mel_Cdl_Approval
186: (
187: -- Standard IN params
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: p_default IN VARCHAR2 := FND_API.G_FALSE,
193: p_module_type IN VARCHAR2 := NULL,

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

186: (
187: -- Standard IN params
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: p_default IN VARCHAR2 := FND_API.G_FALSE,
193: p_module_type IN VARCHAR2 := NULL,
194: -- Standard OUT params

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

187: -- Standard IN params
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: p_default IN VARCHAR2 := FND_API.G_FALSE,
193: p_module_type IN VARCHAR2 := NULL,
194: -- Standard OUT params
195: x_return_status OUT NOCOPY VARCHAR2,

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

188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: p_default IN VARCHAR2 := FND_API.G_FALSE,
193: p_module_type IN VARCHAR2 := NULL,
194: -- Standard OUT params
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,

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

242: -- Pre-reqs :
243: --
244: -- Function params :
245: -- p_unit_effectivity_id NUMBER Required
246: -- p_get_code VARCHAR2 Required, Default FND_API.G_FALSE
247: --
248: -- Return type and typical values :
249: -- VARCHAR2 The relevant MEL/CDL status
250: --

Line 258: p_get_code VARCHAR2 := FND_API.G_FALSE

254: -- End of Comments --
255: FUNCTION Get_Mel_Cdl_Status
256: (
257: p_unit_effectivity_id NUMBER,
258: p_get_code VARCHAR2 := FND_API.G_FALSE
259: )
260: RETURN VARCHAR2;
261:
262: -----------------------