APPS.BIS_TARGET_PVT dependencies on BIS_TARGET_VALUES

Line 205: INSERT INTO bis_target_values

201: --
202: l_user_id := fnd_global.USER_ID;
203: l_login_id := fnd_global.LOGIN_ID;
204: --
205: INSERT INTO bis_target_values
206: ( TARGET_ID
207: , TARGET_LEVEL_ID
208: , PLAN_ID
209: , ORG_LEVEL_VALUE

Line 238: ( bis_target_values_s.NEXTVAL

234: , LAST_UPDATED_BY
235: , LAST_UPDATE_LOGIN
236: )
237: VALUES
238: ( bis_target_values_s.NEXTVAL
239: , l_Target_Rec.Target_Level_ID
240: , l_Target_Rec.Plan_ID
241: , l_Target_Rec.Org_Level_Value_ID
242: , l_Target_Rec.Time_Level_Value_ID

Line 1303: UPDATE BIS_TARGET_VALUES SET

1299: l_user_id := fnd_global.USER_ID;
1300: l_login_id := fnd_global.LOGIN_ID;
1301: --
1302:
1303: UPDATE BIS_TARGET_VALUES SET
1304: TARGET = l_Target_Rec.TARGET
1305: , TARGET_LEVEL_ID = l_Target_Rec.TARGET_LEVEL_ID
1306: , PLAN_ID = l_Target_Rec.PLAN_ID
1307: , ORG_LEVEL_VALUE = l_Target_Rec.ORG_LEVEL_VALUE_ID

Line 1527: DELETE FROM BIS_TARGET_VALUES

1523: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1524: RAISE FND_API.G_EXC_ERROR;
1525: END IF;
1526: --
1527: DELETE FROM BIS_TARGET_VALUES
1528: WHERE TARGET_ID = l_Target_Rec.TARGET_ID;
1529:
1530: if SQL%NOTFOUND then
1531: RAISE NO_DATA_FOUND;

Line 2353: FROM BIS_TARGET_VALUES bis_target_values

2349: AND p_Target_Rec.Target_ID IS NOT NULL
2350: ) THEN
2351: SELECT NVL(LAST_UPDATE_DATE, CREATION_DATE)
2352: INTO x_last_update_date
2353: FROM BIS_TARGET_VALUES bis_target_values
2354: WHERE bis_target_values.TARGET_ID = p_Target_Rec.Target_ID;
2355: ELSE
2356: RAISE FND_API.G_EXC_ERROR;
2357: END IF;

Line 2354: WHERE bis_target_values.TARGET_ID = p_Target_Rec.Target_ID;

2350: ) THEN
2351: SELECT NVL(LAST_UPDATE_DATE, CREATION_DATE)
2352: INTO x_last_update_date
2353: FROM BIS_TARGET_VALUES bis_target_values
2354: WHERE bis_target_values.TARGET_ID = p_Target_Rec.Target_ID;
2355: ELSE
2356: RAISE FND_API.G_EXC_ERROR;
2357: END IF;
2358: --