APPS.IEX_CHECKLIST_UTILITY dependencies on FND_RESP_FUNCTIONS

Line 395: FROM fnd_resp_functions rf, fnd_form_functions ff

391: -- End fix bug #4930424-remove TABLE ACCESS FULL
392:
393: CURSOR c_funct(p_responsibility_id NUMBER, p_function_name VARCHAR2) IS
394: SELECT rf.action_id, ff.function_id
395: FROM fnd_resp_functions rf, fnd_form_functions ff
396: WHERE rf.responsibility_id(+) = p_responsibility_id
397: AND ff.function_name = p_function_name
398: AND rf.action_id(+) = ff.function_id
399: AND rf.rule_type(+) = 'F';

Line 431: fnd_resp_functions_pkg.insert_row(x_rowid => l_rowid,

427: OPEN c_funct(r_resp.responsibility_id, l_function_name);
428: FETCH c_funct INTO r_funct;
429: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
430: IF r_funct.action_id IS NULL THEN
431: fnd_resp_functions_pkg.insert_row(x_rowid => l_rowid,
432: x_application_id => r_resp.application_id,
433: x_responsibility_id => r_resp.responsibility_id,
434: x_action_id => r_funct.function_id,
435: x_rule_type => 'F',

Line 456: fnd_resp_functions_pkg.insert_row(x_rowid => l_rowid,

452: OPEN c_funct(r_resp.responsibility_id, l_function_name);
453: FETCH c_funct INTO r_funct;
454: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
455: IF r_funct.action_id IS NULL THEN
456: fnd_resp_functions_pkg.insert_row(x_rowid => l_rowid,
457: x_application_id => r_resp.application_id,
458: x_responsibility_id => r_resp.responsibility_id,
459: x_action_id => r_funct.function_id,
460: x_rule_type => 'F',

Line 480: fnd_resp_functions_pkg.delete_row(x_application_id => r_resp.application_id,

476: OPEN c_funct(r_resp.responsibility_id, l_function_name);
477: FETCH c_funct INTO r_funct;
478: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
479: IF r_funct.action_id IS NOT NULL THEN
480: fnd_resp_functions_pkg.delete_row(x_application_id => r_resp.application_id,
481: x_responsibility_id => r_resp.responsibility_id,
482: x_action_id => r_funct.action_id,
483: x_rule_type => 'F');
484: END IF;

Line 496: fnd_resp_functions_pkg.delete_row(x_application_id => r_resp.application_id,

492: OPEN c_funct(r_resp.responsibility_id, l_function_name);
493: FETCH c_funct INTO r_funct;
494: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
495: IF r_funct.action_id IS NOT NULL THEN
496: fnd_resp_functions_pkg.delete_row(x_application_id => r_resp.application_id,
497: x_responsibility_id => r_resp.responsibility_id,
498: x_action_id => r_funct.action_id,
499: x_rule_type => 'F');
500:

Line 564: FROM fnd_resp_functions rf, fnd_form_functions ff

560: -- End fix bug #4930424-remove TABLE ACCESS FULL
561:
562: CURSOR c_funct(p_responsibility_id NUMBER, p_function_name VARCHAR2) IS
563: SELECT rf.action_id, ff.function_id
564: FROM fnd_resp_functions rf, fnd_form_functions ff
565: WHERE rf.responsibility_id(+) = p_responsibility_id
566: AND ff.function_name = p_function_name
567: AND rf.action_id(+) = ff.function_id
568: AND rf.rule_type(+) = 'F';

Line 607: fnd_resp_functions_pkg.insert_row(x_rowid => l_rowid,

603: OPEN c_funct(r_resp.responsibility_id, l_function_name);
604: FETCH c_funct INTO r_funct;
605: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
606: IF r_funct.action_id IS NULL THEN
607: fnd_resp_functions_pkg.insert_row(x_rowid => l_rowid,
608: x_application_id => r_resp.application_id,
609: x_responsibility_id => r_resp.responsibility_id,
610: x_action_id => r_funct.function_id,
611: x_rule_type => 'F',

Line 632: fnd_resp_functions_pkg.delete_row(x_application_id => r_resp.application_id,

628: OPEN c_funct(r_resp.responsibility_id, l_function_name);
629: FETCH c_funct INTO r_funct;
630: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
631: IF r_funct.action_id IS NOT NULL THEN
632: fnd_resp_functions_pkg.delete_row(x_application_id => r_resp.application_id,
633: x_responsibility_id => r_resp.responsibility_id,
634: x_action_id => r_funct.action_id,
635: x_rule_type => 'F');
636: END IF;