APPS.AP_WEB_POLICY_UTILS dependencies on OIE_DUP_DETECT_RS_SUMMARY

Line 6825: l_rule_set_name oie_dup_detect_rs_summary.rule_set_name%TYPE;

6821: |
6822: *=======================================================================*/
6823: FUNCTION get_dup_detect_rs_name(p_rule_set_id IN NUMBER) RETURN VARCHAR2 IS
6824:
6825: l_rule_set_name oie_dup_detect_rs_summary.rule_set_name%TYPE;
6826:
6827: BEGIN
6828:
6829: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_POLICY_UTILS', 'start get_dup_detect_rs_name');

Line 6835: SELECT rule_set_name INTO l_rule_set_name FROM oie_dup_detect_rs_summary

6831: IF p_rule_set_id IS NULL THEN
6832: RETURN NULL;
6833: END IF;
6834:
6835: SELECT rule_set_name INTO l_rule_set_name FROM oie_dup_detect_rs_summary
6836: WHERE rule_set_id = p_rule_set_id;
6837:
6838: RETURN l_rule_set_name;
6839:

Line 6915: FROM oie_dup_detect_rs_summary

6911: FUNCTION validate_dup_detect_rs_name(p_rule_set_name IN VARCHAR2, p_rule_set_id IN VARCHAR2) RETURN VARCHAR2 IS
6912:
6913: CURSOR rs_names_cur IS
6914: SELECT rule_set_name
6915: FROM oie_dup_detect_rs_summary
6916: WHERE rule_set_id <> p_rule_set_id;
6917:
6918: rs_names_rec rs_names_cur%ROWTYPE;
6919:

Line 6962: l_rule_set_id oie_dup_detect_rs_summary.RULE_SET_ID%TYPE := NULL;

6958: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,
6959: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN NUMBER IS
6960:
6961: l_rule_id oie_dup_detect_rules.RULE_ID%TYPE := NULL;
6962: l_rule_set_id oie_dup_detect_rs_summary.RULE_SET_ID%TYPE := NULL;
6963: l_category_code VARCHAR2(30) := NULL;
6964:
6965: BEGIN
6966: