DBA Data[Home] [Help]

APPS.BIS_WEIGHTED_MEASURE_PUB dependencies on BIS_WEIGHTED_MEASURE_WEIGHTS_S

Line 1350: SELECT BIS_WEIGHTED_MEASURE_WEIGHTS_S.NEXTVAL

1346:
1347:
1348: -- Set the weighted_definition_id
1349: IF p_Bis_WM_Rec.weight_id IS NULL THEN
1350: SELECT BIS_WEIGHTED_MEASURE_WEIGHTS_S.NEXTVAL
1351: INTO l_Bis_WM_Rec.weight_id
1352: FROM DUAL;
1353: END IF;
1354:

Line 3251: UPDATE bis_weighted_measure_weights SET

3247:
3248: IF l_Update_Param_Ids.COUNT > 0 THEN
3249: IF p_Weight IS NOT NULL THEN
3250: FORALL i in 1..l_Update_Param_Ids.COUNT
3251: UPDATE bis_weighted_measure_weights SET
3252: weight = p_weight
3253: ,last_update_date = SYSDATE
3254: ,last_updated_by = l_User_Id
3255: ,last_update_login = l_Login_Id

Line 3287: bis_weighted_measure_weights_s.nextval

3283: ,last_update_date
3284: ,last_updated_by
3285: ,last_update_login
3286: ) VALUES (
3287: bis_weighted_measure_weights_s.nextval
3288: ,l_Insert_Param_Ids(i)
3289: ,p_dependent_measure_id
3290: ,p_weight
3291: ,SYSDATE

Line 3735: bis_weighted_measure_weights_s.nextval

3731: , last_update_date
3732: , last_updated_by
3733: , last_update_login
3734: ) VALUES (
3735: bis_weighted_measure_weights_s.nextval
3736: , l_Param_Ids(i)
3737: , p_dependent_measure_id
3738: , l_Default_Weight
3739: , SYSDATE