DBA Data[Home] [Help]

APPS.AHL_LTP_REQST_MATRL_PUB dependencies on STANDARD

Line 28: -- Standard IN Parameters :

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

Line 36: -- Standard out Parameters :

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

Line 59: --Standard local variables

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

Line 78: -- Standard start of API savepoint

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

Line 136: -- Standard check of p_commit

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