DBA Data[Home] [Help]

APPS.AS_OPP_OBSTACLE_PVT dependencies on AS_LEAD_OBSTACLES_PKG

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 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;