DBA Data[Home] [Help]

APPS.AHL_LTP_ASCP_ORDERS_PVT dependencies on STANDARD

Line 14: -- Standard IN Parameters :

10: -- from APS
11: -- Pre-reqs :
12: -- Parameters :
13: --
14: -- Standard IN Parameters :
15: -- p_api_version IN NUMBER Required
16: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
17: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
18: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 19: -- Standard out Parameters :

15: -- p_api_version IN NUMBER Required
16: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
17: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
18: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
19: -- Standard out Parameters :
20: -- x_return_status OUT VARCHAR2 Required
21: --
22: -- Update_Scheduling_Results :
23: --

Line 40: --Standard local variables

36: IS
37: SELECT 1 FROM ahl_schedule_materials
38: WHERE scheduled_material_id = c_sch_mat_id;
39:
40: --Standard local variables
41: l_api_name CONSTANT VARCHAR2(30) := 'Update_Scheduling_Results';
42: l_api_version CONSTANT NUMBER := 1.0;
43: l_return_status VARCHAR2(1);
44: l_msg_data VARCHAR2(2000);

Line 57: -- Standard Start of API savepoint

53: 'ahl.plsql.AHL_LTP_ASCP_ORDERS_PVT.Update_Scheduling_Results.begin',
54: 'At the start of PLSQL procedure'
55: );
56: END IF;
57: -- Standard Start of API savepoint
58: SAVEPOINT Update_Scheduling_Results;
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: IF FND_API.to_boolean(p_init_msg_list)
61: THEN

Line 66: -- Standard call to check for call compatibility.

62: FND_MSG_PUB.initialize;
63: END IF;
64: -- Initialize API return status to success
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66: -- Standard call to check for call compatibility.
67: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
68: l_api_version,
69: l_api_name,G_PKG_NAME)
70: THEN

Line 104: --Standard check to count messages

100: END IF;
101: END LOOP;
102: END IF;
103:
104: --Standard check to count messages
105: l_msg_count := FND_MSG_PUB.count_msg;
106: IF l_msg_count > 0 THEN
107: RAISE FND_API.G_EXC_ERROR;
108: END IF;

Line 110: -- Standard check of p_commit

106: IF l_msg_count > 0 THEN
107: RAISE FND_API.G_EXC_ERROR;
108: END IF;
109:
110: -- Standard check of p_commit
111: IF FND_API.TO_BOOLEAN(p_commit) THEN
112: COMMIT WORK;
113: END IF;
114: