DBA Data[Home] [Help]

APPS.GMD_API_GRP dependencies on GMD_OPERATION_ACTIVITIES

Line 1384: FROM gmd_operation_activities

1380: then all others will follow */
1381:
1382: CURSOR Cur_get_activities (V_oprn_id IN NUMBER) IS
1383: SELECT oprn_line_id, NVL(sequence_dependent_ind,-1) sequence_dependent_ind
1384: FROM gmd_operation_activities
1385: WHERE oprn_id = v_oprn_id
1386: AND NVL(sequence_dependent_ind, 0) <> 1
1387: ORDER BY
1388: offset_interval,

Line 1408: UPDATE gmd_operation_activities

1404:
1405: /* If the activity has been previously numbered and is in the right order
1406: no need to update it */
1407: IF X_seq_dep_ind <> X_seq_num THEN
1408: UPDATE gmd_operation_activities
1409: SET sequence_dependent_ind = X_seq_num,
1410: last_update_date = SYSDATE,
1411: last_updated_by = P_user_id,
1412: last_update_login = P_login_id