APPS.AS_OPP_OBSTACLE_PVT dependencies on AS_LEAD_OBSTACLES

Line 164: -- Invoke table handler(AS_LEAD_OBSTACLES_PKG.Insert_Row)

160: RAISE FND_API.G_EXC_ERROR;
161: END IF;
162:
163:
164: -- Invoke table handler(AS_LEAD_OBSTACLES_PKG.Insert_Row)
165: FOR I in 1 .. P_OBSTACLE_tbl.count LOOP
166:
167: X_LEAD_OBSTACLE_out_tbl(I).return_status := FND_API.G_RET_STS_SUCCESS;
168: l_LEAD_OBSTACLE_ID := P_OBSTACLE_Tbl(I).LEAD_OBSTACLE_ID;

Line 213: AS_LEAD_OBSTACLES_PKG.Insert_Row(

209: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
210: END IF;
211:
212:
213: AS_LEAD_OBSTACLES_PKG.Insert_Row(
214: px_LEAD_OBSTACLE_ID => l_LEAD_OBSTACLE_ID,
215: p_LAST_UPDATE_DATE => SYSDATE,
216: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
217: p_CREATION_DATE => SYSDATE,

Line 409: From AS_LEAD_OBSTACLES

405: ATTRIBUTE13,
406: ATTRIBUTE14,
407: ATTRIBUTE15
408: -- ? SECURITY_GROUP_ID
409: From AS_LEAD_OBSTACLES
410: WHERE LEAD_OBSTACLE_ID = c_LEAD_OBSTACLE_ID
411: -- Hint: Developer need to provide Where clause
412: For Update NOWAIT;
413:

Line 657: -- Invoke table handler(AS_LEAD_OBSTACLES_PKG.Update_Row)

653: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
654: END IF;
655:
656:
657: -- Invoke table handler(AS_LEAD_OBSTACLES_PKG.Update_Row)
658: AS_LEAD_OBSTACLES_PKG.Update_Row(
659: p_LEAD_OBSTACLE_ID => p_Obstacle_tbl(I).LEAD_OBSTACLE_ID,
660: p_LAST_UPDATE_DATE => SYSDATE,
661: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

Line 658: AS_LEAD_OBSTACLES_PKG.Update_Row(

654: END IF;
655:
656:
657: -- Invoke table handler(AS_LEAD_OBSTACLES_PKG.Update_Row)
658: AS_LEAD_OBSTACLES_PKG.Update_Row(
659: p_LEAD_OBSTACLE_ID => p_Obstacle_tbl(I).LEAD_OBSTACLE_ID,
660: p_LAST_UPDATE_DATE => SYSDATE,
661: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
662: p_CREATION_DATE => SYSDATE,

Line 928: -- Invoke table handler(AS_LEAD_OBSTACLES_PKG.Delete_Row)

924: RAISE FND_API.G_EXC_ERROR;
925: END IF;
926:
927:
928: -- Invoke table handler(AS_LEAD_OBSTACLES_PKG.Delete_Row)
929: FOR I in 1 .. P_Obstacle_tbl.count LOOP
930:
931: X_LEAD_OBSTACLE_out_tbl(I).return_status := FND_API.G_RET_STS_SUCCESS;
932:

Line 949: AS_LEAD_OBSTACLES_PKG.Delete_Row(

945: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
946: END IF;
947:
948:
949: AS_LEAD_OBSTACLES_PKG.Delete_Row(
950: p_LEAD_OBSTACLE_ID => p_Obstacle_tbl(I).LEAD_OBSTACLE_ID);
951:
952: X_LEAD_OBSTACLE_out_tbl(I).LEAD_OBSTACLE_ID := p_Obstacle_tbl(I).LEAD_OBSTACLE_ID;
953: X_LEAD_OBSTACLE_out_tbl(I).return_status := x_return_status;

Line 1053: FROM as_lead_obstacles

1049: )
1050: IS
1051: CURSOR C_Lead_Obstacle_Id_Exists (c_Lead_Obstacle_Id NUMBER) IS
1052: SELECT 'X'
1053: FROM as_lead_obstacles
1054: WHERE lead_Obstacle_id = c_Lead_Obstacle_Id;
1055:
1056: l_val VARCHAR2(1);
1057: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lobpv.Validate_LEAD_OBSTACLE_ID';