APPS.PA_PERF_EXCP_UTILS dependencies on PA_PERF_OBJECT_RULES

Line 590: FROM pa_perf_object_rules

586: SELECT Object_rule_id,
587: Object_type,
588: Object_id,
589: rule_id
590: FROM pa_perf_object_rules
591: WHERE object_type = p_from_object_type
592: AND object_id = p_from_object_id;
593:
594: l_object_rule_id NUMBER;

Line 608: select PA_PERF_OBJECT_RULES_S1.nextval into l_object_rule_id from dual;

604: -- Insert the perf/score rules for the new object
605:
606: FOR c_rec in perf_score_rules LOOP
607:
608: select PA_PERF_OBJECT_RULES_S1.nextval into l_object_rule_id from dual;
609:
610: PA_PERF_OBJECT_RULES_PKG.insert_row(
611: X_ROWID => l_rowid,
612: X_OBJECT_RULE_ID => l_object_rule_id,

Line 610: PA_PERF_OBJECT_RULES_PKG.insert_row(

606: FOR c_rec in perf_score_rules LOOP
607:
608: select PA_PERF_OBJECT_RULES_S1.nextval into l_object_rule_id from dual;
609:
610: PA_PERF_OBJECT_RULES_PKG.insert_row(
611: X_ROWID => l_rowid,
612: X_OBJECT_RULE_ID => l_object_rule_id,
613: X_OBJECT_TYPE => P_TO_OBJECT_TYPE,
614: X_OBJECT_ID => P_TO_OBJECT_ID,

Line 654: delete pa_perf_object_rules

650: x_return_status:=fnd_api.g_ret_sts_success;
651:
652: savepoint delete_object_exceptions;
653:
654: delete pa_perf_object_rules
655: where object_type = p_object_type
656: and object_id = p_object_id;
657:
658: