APPS.AHL_MC_PATH_POSITION_PUB dependencies on AHL_MC_PATH_POSITION_PVT

Line 10: p_x_path_position_tbl IN OUT NOCOPY AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type

6: ------------------------------------------------------------------------------------
7: -- Local API Declaration
8: ------------------------------------------------------------------------------------
9: PROCEDURE Convert_Path_Pos_Values_to_Id (
10: p_x_path_position_tbl IN OUT NOCOPY AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type
11: );
12:
13: -------------------------------------------------------------------------------------------
14: -- Start of Comments

Line 22: -- p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type Required

18: -- Pre-reqs :
19: -- Parameters :
20: --
21: -- Create_Position_ID Parameters:
22: -- p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type Required
23: --
24: -- End of Comments
25: -------------------------------------------------------------------------------------------
26: PROCEDURE Create_Position_ID (

Line 31: p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type,

27: p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29: p_commit IN VARCHAR2 := FND_API.G_FALSE,
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: p_path_position_tbl IN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type,
32: p_position_ref_meaning IN VARCHAR2,
33: p_position_ref_code IN VARCHAR2,
34: x_position_id OUT NOCOPY NUMBER,
35: x_return_status OUT NOCOPY VARCHAR2,

Line 45: l_path_position_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type DEFAULT p_path_position_tbl;

41: l_api_version CONSTANT NUMBER := 1.0;
42: l_api_name CONSTANT VARCHAR2(30) := 'Create_Position_ID';
43: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
44:
45: l_path_position_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type DEFAULT p_path_position_tbl;
46: --
47:
48: BEGIN
49: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 87: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'Calling private API AHL_MC_PATH_POSITION_PVT.Create_Position_ID.');

83: -- call Convert_Path_Pos_Values_to_Id
84: Convert_Path_Pos_Values_to_Id(l_path_position_tbl);
85:
86: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
87: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'Calling private API AHL_MC_PATH_POSITION_PVT.Create_Position_ID.');
88: END IF;
89:
90: -- call the private API
91: AHL_MC_PATH_POSITION_PVT.Create_Position_ID(

Line 91: AHL_MC_PATH_POSITION_PVT.Create_Position_ID(

87: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'Calling private API AHL_MC_PATH_POSITION_PVT.Create_Position_ID.');
88: END IF;
89:
90: -- call the private API
91: AHL_MC_PATH_POSITION_PVT.Create_Position_ID(
92: p_api_version => p_api_version,
93: p_init_msg_list => p_init_msg_list,
94: p_commit => FND_API.G_FALSE, -- Pass false and commit at the end if needed
95: p_validation_level => p_validation_level,

Line 115: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'AHL_MC_PATH_POSITION_PVT.Create_Position_ID returned x_return_status as ' || x_return_status);

111: RAISE FND_API.G_EXC_ERROR;
112: END IF;
113:
114: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
115: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'AHL_MC_PATH_POSITION_PVT.Create_Position_ID returned x_return_status as ' || x_return_status);
116: END IF;
117:
118: -- Standard check of p_commit
119: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 170: -- p_x_path_position_tbl IN OUT AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type

166: -- Pre-reqs :
167: -- Parameters :
168: --
169: -- Convert_Path_Pos_Values_to_Id Parameters:
170: -- p_x_path_position_tbl IN OUT AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type
171: --
172: -- End of Comments
173: -----------------------------------------------------------------------------------------------
174: PROCEDURE Convert_Path_Pos_Values_to_Id (

Line 175: p_x_path_position_tbl IN OUT NOCOPY AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type

171: --
172: -- End of Comments
173: -----------------------------------------------------------------------------------------------
174: PROCEDURE Convert_Path_Pos_Values_to_Id (
175: p_x_path_position_tbl IN OUT NOCOPY AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type
176: ) IS
177:
178: CURSOR chk_mc_id_csr (p_mc_id NUMBER) IS
179: SELECT 'X'

Line 205: l_path_position_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type DEFAULT p_x_path_position_tbl;

201: l_full_name CONSTANT VARCHAR2(90) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
202:
203: l_mc_id NUMBER;
204: l_ver_no NUMBER;
205: l_path_position_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type DEFAULT p_x_path_position_tbl;
206: l_dummy VARCHAR2(1);
207: l_validation_failed_flag VARCHAR2(1) := 'N';
208: --
209: