APPS.PQP_RIW_WEBADI_UTILS dependencies on FND_MENU_ENTRIES

Line 1896: FROM fnd_menu_entries

1892: WHERE function_name = p_function_name;
1893:
1894: SELECT max(ENTRY_SEQUENCE)
1895: INTO l_ENTRY_SEQUENCE
1896: FROM fnd_menu_entries
1897: WHERE MENU_ID= p_menu_id ;
1898:
1899: fnd_menu_entries_pkg.insert_row
1900: (X_ROWID => l_rowid

Line 1899: fnd_menu_entries_pkg.insert_row

1895: INTO l_ENTRY_SEQUENCE
1896: FROM fnd_menu_entries
1897: WHERE MENU_ID= p_menu_id ;
1898:
1899: fnd_menu_entries_pkg.insert_row
1900: (X_ROWID => l_rowid
1901: ,X_MENU_ID => p_menu_id
1902: ,X_ENTRY_SEQUENCE => l_ENTRY_SEQUENCE+1
1903: ,X_SUB_MENU_ID => null

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

3337: l_intf_code VARCHAR2(30);
3338:
3339: BEGIN
3340: -- hr_utility.trace_on(null,'TTT');
3341: -- get the count of function_id from fnd_menu_entries
3342: SELECT count(function_id)
3343: INTO l_count
3344: FROM fnd_menu_entries
3345: WHERE function_id = p_function_id;

Line 3344: FROM fnd_menu_entries

3340: -- hr_utility.trace_on(null,'TTT');
3341: -- get the count of function_id from fnd_menu_entries
3342: SELECT count(function_id)
3343: INTO l_count
3344: FROM fnd_menu_entries
3345: WHERE function_id = p_function_id;
3346:
3347:
3348: --$ Call Delete_riw_integrator to delete entire integrator setup

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

3351: CLOSE csr_get_interface_code;
3352:
3353: IF l_count = 1 THEN
3354:
3355: -- get menu id and entry seq from fnd_menu_entries
3356: SELECT ENTRY_SEQUENCE
3357: ,MENU_ID
3358: INTO l_ENTRY_SEQUENCE
3359: ,l_menu_id

Line 3360: FROM fnd_menu_entries

3356: SELECT ENTRY_SEQUENCE
3357: ,MENU_ID
3358: INTO l_ENTRY_SEQUENCE
3359: ,l_menu_id
3360: FROM fnd_menu_entries
3361: WHERE function_id = p_function_id;
3362:
3363: -- delete row for menu id , entry seq
3364: FND_MENU_ENTRIES_PKG.DELETE_ROW(

Line 3364: FND_MENU_ENTRIES_PKG.DELETE_ROW(

3360: FROM fnd_menu_entries
3361: WHERE function_id = p_function_id;
3362:
3363: -- delete row for menu id , entry seq
3364: FND_MENU_ENTRIES_PKG.DELETE_ROW(
3365: X_MENU_ID => l_menu_id
3366: ,X_ENTRY_SEQUENCE => l_ENTRY_SEQUENCE);
3367:
3368: OPEN csr_get_fun_name;

Line 3397: FROM fnd_menu_entries

3393:
3394: /*ELSE
3395:
3396: SELECT ENTRY_SEQUENCE INTO l_ENTRY_SEQUENCE
3397: FROM fnd_menu_entries
3398: WHERE MENU_ID = l_menu_id
3399: AND function_id = p_function_id;
3400:
3401: FND_MENU_ENTRIES_PKG.DELETE_ROW(

Line 3401: FND_MENU_ENTRIES_PKG.DELETE_ROW(

3397: FROM fnd_menu_entries
3398: WHERE MENU_ID = l_menu_id
3399: AND function_id = p_function_id;
3400:
3401: FND_MENU_ENTRIES_PKG.DELETE_ROW(
3402: X_MENU_ID => p_menu_id
3403: ,X_ENTRY_SEQUENCE => l_ENTRY_SEQUENCE);
3404: */
3405: END IF;