APPS.PQP_RIW_WEBADI_UTILS dependencies on FND_MENU_ENTRIES

Line 1613: FROM fnd_menu_entries

1609: WHERE function_name = p_function_name;
1610:
1611: SELECT max(ENTRY_SEQUENCE)
1612: INTO l_ENTRY_SEQUENCE
1613: FROM fnd_menu_entries
1614: WHERE MENU_ID= p_menu_id ;
1615:
1616: fnd_menu_entries_pkg.insert_row
1617: (X_ROWID => l_rowid

Line 1616: fnd_menu_entries_pkg.insert_row

1612: INTO l_ENTRY_SEQUENCE
1613: FROM fnd_menu_entries
1614: WHERE MENU_ID= p_menu_id ;
1615:
1616: fnd_menu_entries_pkg.insert_row
1617: (X_ROWID => l_rowid
1618: ,X_MENU_ID => p_menu_id
1619: ,X_ENTRY_SEQUENCE => l_ENTRY_SEQUENCE+1
1620: ,X_SUB_MENU_ID => null

Line 2932: -- get the count of function_id from fnd_menu_entries

2928: l_intf_code VARCHAR2(30);
2929:
2930: BEGIN
2931: -- hr_utility.trace_on(null,'TTT');
2932: -- get the count of function_id from fnd_menu_entries
2933: SELECT count(function_id)
2934: INTO l_count
2935: FROM fnd_menu_entries
2936: WHERE function_id = p_function_id;

Line 2935: FROM fnd_menu_entries

2931: -- hr_utility.trace_on(null,'TTT');
2932: -- get the count of function_id from fnd_menu_entries
2933: SELECT count(function_id)
2934: INTO l_count
2935: FROM fnd_menu_entries
2936: WHERE function_id = p_function_id;
2937:
2938:
2939: --$ Call Delete_riw_integrator to delete entire integrator setup

Line 2946: -- get menu id and entry seq from fnd_menu_entries

2942: CLOSE csr_get_interface_code;
2943:
2944: IF l_count = 1 THEN
2945:
2946: -- get menu id and entry seq from fnd_menu_entries
2947: SELECT ENTRY_SEQUENCE
2948: ,MENU_ID
2949: INTO l_ENTRY_SEQUENCE
2950: ,l_menu_id

Line 2951: FROM fnd_menu_entries

2947: SELECT ENTRY_SEQUENCE
2948: ,MENU_ID
2949: INTO l_ENTRY_SEQUENCE
2950: ,l_menu_id
2951: FROM fnd_menu_entries
2952: WHERE function_id = p_function_id;
2953:
2954: -- delete row for menu id , entry seq
2955: FND_MENU_ENTRIES_PKG.DELETE_ROW(

Line 2955: FND_MENU_ENTRIES_PKG.DELETE_ROW(

2951: FROM fnd_menu_entries
2952: WHERE function_id = p_function_id;
2953:
2954: -- delete row for menu id , entry seq
2955: FND_MENU_ENTRIES_PKG.DELETE_ROW(
2956: X_MENU_ID => l_menu_id
2957: ,X_ENTRY_SEQUENCE => l_ENTRY_SEQUENCE);
2958:
2959: OPEN csr_get_fun_name;

Line 2988: FROM fnd_menu_entries

2984:
2985: /*ELSE
2986:
2987: SELECT ENTRY_SEQUENCE INTO l_ENTRY_SEQUENCE
2988: FROM fnd_menu_entries
2989: WHERE MENU_ID = l_menu_id
2990: AND function_id = p_function_id;
2991:
2992: FND_MENU_ENTRIES_PKG.DELETE_ROW(

Line 2992: FND_MENU_ENTRIES_PKG.DELETE_ROW(

2988: FROM fnd_menu_entries
2989: WHERE MENU_ID = l_menu_id
2990: AND function_id = p_function_id;
2991:
2992: FND_MENU_ENTRIES_PKG.DELETE_ROW(
2993: X_MENU_ID => p_menu_id
2994: ,X_ENTRY_SEQUENCE => l_ENTRY_SEQUENCE);
2995: */
2996: END IF;