APPS.AP_WEB_POLICY_UTILS dependencies on AP_POL_VIOLATIONS_ALL

Line 7122: SELECT Count(*) INTO l_count FROM ap_pol_violations_all

7118: END IF;
7119:
7120: IF l_dup_detect_action = 'PREVENT_SUBMISSION' THEN
7121: BEGIN
7122: SELECT Count(*) INTO l_count FROM ap_pol_violations_all
7123: WHERE report_header_id = p_report_header_id AND distribution_line_number = p_dist_line_number
7124: AND violation_type = 'DUPLICATE_DETECTION';
7125: EXCEPTION
7126: WHEN No_Data_Found THEN

Line 7229: FUNCTION getMaxDistLineNumber(p_report_header_id IN ap_pol_violations_all.REPORT_HEADER_ID%TYPE,

7225: | Date Author Description of Changes
7226: | 23-Feb-2010 Dharma Theja Reddy S Created
7227: |
7228: *=======================================================================*/
7229: FUNCTION getMaxDistLineNumber(p_report_header_id IN ap_pol_violations_all.REPORT_HEADER_ID%TYPE,
7230: p_dist_line_number IN ap_pol_violations_all.DISTRIBUTION_LINE_NUMBER%TYPE) RETURN NUMBER IS
7231:
7232: l_max_violation_number ap_pol_violations_all.VIOLATION_NUMBER%TYPE;
7233:

Line 7230: p_dist_line_number IN ap_pol_violations_all.DISTRIBUTION_LINE_NUMBER%TYPE) RETURN NUMBER IS

7226: | 23-Feb-2010 Dharma Theja Reddy S Created
7227: |
7228: *=======================================================================*/
7229: FUNCTION getMaxDistLineNumber(p_report_header_id IN ap_pol_violations_all.REPORT_HEADER_ID%TYPE,
7230: p_dist_line_number IN ap_pol_violations_all.DISTRIBUTION_LINE_NUMBER%TYPE) RETURN NUMBER IS
7231:
7232: l_max_violation_number ap_pol_violations_all.VIOLATION_NUMBER%TYPE;
7233:
7234: BEGIN

Line 7232: l_max_violation_number ap_pol_violations_all.VIOLATION_NUMBER%TYPE;

7228: *=======================================================================*/
7229: FUNCTION getMaxDistLineNumber(p_report_header_id IN ap_pol_violations_all.REPORT_HEADER_ID%TYPE,
7230: p_dist_line_number IN ap_pol_violations_all.DISTRIBUTION_LINE_NUMBER%TYPE) RETURN NUMBER IS
7231:
7232: l_max_violation_number ap_pol_violations_all.VIOLATION_NUMBER%TYPE;
7233:
7234: BEGIN
7235:
7236: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_POLICY_UTILS', 'start getMaxDistLineNumber');

Line 7239: FROM ap_pol_violations_all

7235:
7236: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_POLICY_UTILS', 'start getMaxDistLineNumber');
7237:
7238: SELECT Max(violation_number) INTO l_max_violation_number
7239: FROM ap_pol_violations_all
7240: WHERE report_header_id = p_report_header_id
7241: AND distribution_line_number = p_dist_line_number
7242: AND violation_type = 'DUPLICATE_DETECTION';
7243:

Line 7259: | inserts the violations on to the table ap_pol_violations_all.

7255: | PUBLIC PROCEDURE performDuplicateDetection
7256: |
7257: | DESCRIPTION
7258: | This procedure performs the duplicate detection for the expense line and
7259: | inserts the violations on to the table ap_pol_violations_all.
7260: |
7261: | MODIFICATION HISTORY
7262: | Date Author Description of Changes
7263: | 23-Feb-2010 Dharma Theja Reddy S Created

Line 7335: FROM ap_pol_violations_all WHERE report_header_id = p_report_header_id;

7331: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_POLICY_UTILS', 'start performDuplicateDetection');
7332:
7333: IF l_violation_number = -1 THEN
7334: SELECT Decode(Max(violation_number), NULL, 0, Max(violation_number)) INTO l_violation_number
7335: FROM ap_pol_violations_all WHERE report_header_id = p_report_header_id;
7336: END IF;
7337:
7338: DELETE FROM ap_pol_violations_all
7339: WHERE report_header_id = p_report_header_id

Line 7338: DELETE FROM ap_pol_violations_all

7334: SELECT Decode(Max(violation_number), NULL, 0, Max(violation_number)) INTO l_violation_number
7335: FROM ap_pol_violations_all WHERE report_header_id = p_report_header_id;
7336: END IF;
7337:
7338: DELETE FROM ap_pol_violations_all
7339: WHERE report_header_id = p_report_header_id
7340: AND distribution_line_number = p_distribution_line_number
7341: AND violation_type = 'DUPLICATE_DETECTION';
7342:

Line 7513: INSERT INTO ap_pol_violations_all (

7509:
7510: l_violation_number := l_violation_number + 1;
7511: l_dist_line_number := getDistLineNumber(expense_lines_rec.report_header_id, expense_lines_rec.distribution_line_number);
7512:
7513: INSERT INTO ap_pol_violations_all (
7514: REPORT_HEADER_ID,
7515: DISTRIBUTION_LINE_NUMBER,
7516: VIOLATION_NUMBER,
7517: VIOLATION_TYPE,

Line 7595: DELETE FROM ap_pol_violations_all WHERE report_header_id = p_report_header_id

7591: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_POLICY_UTILS', 'start removeDupViolations');
7592:
7593: IF ((p_report_header_id IS NOT NULL) AND (p_dist_line_number IS NOT NULL)) THEN
7594:
7595: DELETE FROM ap_pol_violations_all WHERE report_header_id = p_report_header_id
7596: AND distribution_line_number = p_dist_line_number AND violation_type = 'DUPLICATE_DETECTION';
7597:
7598: END IF;
7599:

Line 7620: PROCEDURE getDistNumber(p_report_line_id IN ap_pol_violations_all.DUP_REPORT_LINE_ID%TYPE,

7616: | Date Author Description of Changes
7617: | 23-Feb-2010 Dharma Theja Reddy S Created
7618: |
7619: *=======================================================================*/
7620: PROCEDURE getDistNumber(p_report_line_id IN ap_pol_violations_all.DUP_REPORT_LINE_ID%TYPE,
7621: p_category OUT NOCOPY VARCHAR2,
7622: p_dist_num OUT NOCOPY VARCHAR2) IS
7623:
7624: TYPE dist_lines IS REF CURSOR;