APPS.AP_WEB_POLICY_UTILS dependencies on OIE_DUP_DETECT_RULES

Line 6686: FROM oie_dup_detect_rules rule

6682: CURSOR assignment_rule_cur IS
6683: --Bug 16468324: return's count > 0 only if 'rule' is added to 'rule set' (or)
6684: -- 'rule' assigned to any operating unit
6685: SELECT count(*) assignment_count
6686: FROM oie_dup_detect_rules rule
6687: WHERE rule.rule_id = p_rule_id
6688: AND (EXISTS(SELECT 1 FROM oie_dup_detect_rs_detail rs WHERE rs.rule_id = rule.rule_id)
6689: OR EXISTS(SELECT 1 FROM oie_dup_rule_assignments_all rsa WHERE rsa.rule_id = rule.rule_id));
6690:

Line 6778: l_rule_name oie_dup_detect_rules.rule_name%TYPE;

6774: |
6775: *=======================================================================*/
6776: FUNCTION get_dup_detect_rule_name(p_rule_id IN NUMBER) RETURN VARCHAR2 IS
6777:
6778: l_rule_name oie_dup_detect_rules.rule_name%TYPE;
6779:
6780: BEGIN
6781:
6782: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_POLICY_UTILS', 'start get_dup_detect_rule_name');

Line 6792: SELECT rule_name INTO l_rule_name FROM oie_dup_detect_rules

6788: IF p_rule_id = -1 THEN
6789: SELECT displayed_field INTO l_rule_name FROM ap_lookup_codes
6790: WHERE lookup_type = 'OIE_DISABLE_DUP_DETECTION' AND lookup_code = 'DISABLE_DUPLICATE_DETECTION';
6791: ELSE
6792: SELECT rule_name INTO l_rule_name FROM oie_dup_detect_rules
6793: WHERE rule_id = p_rule_id;
6794: END IF;
6795:
6796: RETURN l_rule_name;

Line 6870: FROM oie_dup_detect_rules

6866: FUNCTION validate_dup_detect_rule_name(p_rule_name IN VARCHAR2, p_rule_id IN VARCHAR2) RETURN VARCHAR2 IS
6867:
6868: CURSOR rule_names_cur IS
6869: SELECT rule_name
6870: FROM oie_dup_detect_rules
6871: WHERE rule_id <> p_rule_id;
6872:
6873: rule_names_rec rule_names_cur%ROWTYPE;
6874:

Line 6961: l_rule_id oie_dup_detect_rules.RULE_ID%TYPE := NULL;

6957: FUNCTION getDuplicateDetectionRule(p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,
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

Line 7101: l_rule_id oie_dup_detect_rules.rule_id%TYPE := NULL;

7097: p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,
7098: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,
7099: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN VARCHAR2 IS
7100:
7101: l_rule_id oie_dup_detect_rules.rule_id%TYPE := NULL;
7102: l_dup_detect_action oie_dup_detect_rules.duplicate_detection_action%TYPE := NULL;
7103: l_count NUMBER := 0;
7104:
7105: BEGIN

Line 7102: l_dup_detect_action oie_dup_detect_rules.duplicate_detection_action%TYPE := NULL;

7098: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,
7099: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN VARCHAR2 IS
7100:
7101: l_rule_id oie_dup_detect_rules.rule_id%TYPE := NULL;
7102: l_dup_detect_action oie_dup_detect_rules.duplicate_detection_action%TYPE := NULL;
7103: l_count NUMBER := 0;
7104:
7105: BEGIN
7106:

Line 7117: FROM oie_dup_detect_rules WHERE rule_id = l_rule_id;

7113: l_rule_id := getDuplicateDetectionRule(p_org_id, p_category_code, p_start_date);
7114:
7115: IF l_rule_id IS NOT NULL AND l_rule_id <> -1 THEN
7116: SELECT duplicate_detection_action INTO l_dup_detect_action
7117: FROM oie_dup_detect_rules WHERE rule_id = l_rule_id;
7118: END IF;
7119:
7120: IF l_dup_detect_action = 'PREVENT_SUBMISSION' THEN
7121: BEGIN

Line 7310: l_rule_id oie_dup_detect_rules.rule_id%TYPE := NULL;

7306: current_calling_sequence varchar2(100) := 'performDuplicateDetection';
7307: l_stmt VARCHAR2(2000);
7308: l_att_stmt VARCHAR2(2000);
7309: l_where_clause VARCHAR2(2000) := NULL;
7310: l_rule_id oie_dup_detect_rules.rule_id%TYPE := NULL;
7311: l_exp_duplicates_allowed NUMBER := 0;
7312: l_duplicates_allowed NUMBER := 0;
7313: l_count NUMBER := 0;
7314: l_row_count NUMBER := 0;

Line 7324: SELECT * FROM oie_dup_detect_rules

7320: l_receipt_amount VARCHAR2(50);
7321: l_receipt_amt NUMBER;
7322:
7323: CURSOR dup_detect_rule_cur(p_rule_id IN NUMBER) IS
7324: SELECT * FROM oie_dup_detect_rules
7325: WHERE rule_id = p_rule_id;
7326:
7327: dup_detect_rule_rec dup_detect_rule_cur%ROWTYPE;
7328: