DBA Data[Home] [Help]

APPS.GMD_API_GRP dependencies on GMD_OPERATION_ACTIVITIES

Line 1378: FROM gmd_operation_activities

1374: then all others will follow */
1375:
1376: CURSOR Cur_get_activities (V_oprn_id IN NUMBER) IS
1377: SELECT oprn_line_id, NVL(sequence_dependent_ind,-1) sequence_dependent_ind
1378: FROM gmd_operation_activities
1379: WHERE oprn_id = v_oprn_id
1380: AND NVL(sequence_dependent_ind, 0) <> 1
1381: ORDER BY
1382: offset_interval,

Line 1402: UPDATE gmd_operation_activities

1398:
1399: /* If the activity has been previously numbered and is in the right order
1400: no need to update it */
1401: IF X_seq_dep_ind <> X_seq_num THEN
1402: UPDATE gmd_operation_activities
1403: SET sequence_dependent_ind = X_seq_num,
1404: last_update_date = SYSDATE,
1405: last_updated_by = P_user_id,
1406: last_update_login = P_login_id