APPS.AHL_LTP_REQST_MATRL_PUB dependencies on STANDARD

Line 29: -- Standard IN Parameters :

25: -- visit, which are defined at Route Operation and Disposition level
26: -- Pre-reqs :
27: -- Parameters :
28: --
29: -- Standard IN Parameters :
30: -- p_api_version IN NUMBER Required
31: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
32: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
33: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 37: -- Standard out Parameters :

33: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
34: -- Based on this flag, the API will set the default attributes.
35: -- p_module_type In VARCHAR2 Default NULL
36: -- This will be null.
37: -- Standard out Parameters :
38: -- x_return_status OUT VARCHAR2 Required
39: -- x_msg_count OUT NUMBER Required
40: -- x_msg_data OUT VARCHAR2 Required
41: --

Line 60: --Standard local variables

56:
57: IS
58:
59:
60: --Standard local variables
61: l_api_name CONSTANT VARCHAR2(30) := 'Update_Planned_Materials';
62: l_api_version CONSTANT NUMBER := 1.0;
63: l_msg_data VARCHAR2(2000);
64: l_return_status VARCHAR2(1);

Line 79: -- Standard start of API savepoint

75: 'ahl.plsql.AHL_LTP_REQST_MATRL_PUB.Update_Planned_Materials',
76: 'At the start of PLSQL procedure'
77: );
78: END IF;
79: -- Standard start of API savepoint
80: SAVEPOINT Update_Planned_Materials;
81: -- Initialize message list if p_init_msg_list is set to TRUE
82: IF FND_API.To_Boolean( p_init_msg_list) THEN
83: FND_MSG_PUB.Initialize;

Line 137: -- Standard check of p_commit

133: RAISE FND_API.G_EXC_ERROR;
134: END IF;
135: END IF;
136:
137: -- Standard check of p_commit
138: IF FND_API.TO_BOOLEAN(p_commit) THEN
139: COMMIT WORK;
140: END IF;
141:

Line 189: -- Standard IN Parameters :

185: -- visit, which are defined at Route Operation and Disposition level
186: -- Pre-reqs :
187: -- Parameters :
188: --
189: -- Standard IN Parameters :
190: -- p_api_version IN NUMBER Required
191: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
192: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
193: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 197: -- Standard out Parameters :

193: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
194: -- Based on this flag, the API will set the default attributes.
195: -- p_module_type In VARCHAR2 Default NULL
196: -- This will be null.
197: -- Standard out Parameters :
198: -- x_return_status OUT VARCHAR2 Required
199: -- x_msg_count OUT NUMBER Required
200: -- x_msg_data OUT VARCHAR2 Required
201: --

Line 225: --Standard local variables

221:
222: IS
223:
224:
225: --Standard local variables
226: l_api_name CONSTANT VARCHAR2(30) := 'Process_Planned_Materials';
227: l_api_version CONSTANT NUMBER := 1.0;
228: l_msg_data VARCHAR2(2000);
229: l_return_status VARCHAR2(1);

Line 244: -- Standard start of API savepoint

240: 'ahl.plsql.AHL_LTP_REQST_MATRL_PUB.Process_Planned_Materials',
241: 'At the start of PLSQL procedure'
242: );
243: END IF;
244: -- Standard start of API savepoint
245: SAVEPOINT Process_Planned_Materials;
246: -- Initialize message list if p_init_msg_list is set to TRUE
247: IF FND_API.To_Boolean( p_init_msg_list) THEN
248: FND_MSG_PUB.Initialize;

Line 306: -- Standard check of p_commit

302: RAISE FND_API.G_EXC_ERROR;
303: END IF;
304: END IF;
305:
306: -- Standard check of p_commit
307: IF FND_API.TO_BOOLEAN(p_commit) THEN
308: COMMIT WORK;
309: END IF;
310: