523: h_top_menu NUMBER;
524: h_count NUMBER;
525: cursor c_RESPO is
526: SELECT MENU_ID
527: FROM FND_RESPONSIBILITY_VL
528: WHERE RESPONSIBILITY_ID=X_RESPO;
529:
530: BEGIN
531: -- Name
1004: h_cursor INTEGER;
1005:
1006: CURSOR c_top_menu_id IS
1007: SELECT menu_id
1008: FROM fnd_responsibility_vl
1009: WHERE responsibility_id = x_trg_resp;
1010:
1011: h_top_menu_id NUMBER;
1012: h_top_menu_id_src NUMBER;
1027: h_user_id := BSC_APPS.fnd_global_user_id;
1028:
1029: -- Get the top menu id of the source responsibility
1030: h_sql := 'SELECT MENU_ID'||
1031: ' FROM FND_RESPONSIBILITY_VL@'||x_src_db_link||
1032: /*' WHERE RESPONSIBILITY_ID = '||x_src_resp;*/
1033: ' WHERE RESPONSIBILITY_ID = :1';
1034:
1035: h_cursor := DBMS_SQL.OPEN_CURSOR;