DBA Data[Home] [Help]

APPS.AP_WEB_POLICY_UTILS dependencies on AP_POL_VIOLATIONS_ALL

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

1642: | Date Author Description of Changes
1643: | 23-Feb-2010 Dharma Theja Reddy S Created
1644: |
1645: *=======================================================================*/
1646: PROCEDURE getDistNumber(p_report_line_id IN ap_pol_violations_all.DUP_REPORT_LINE_ID%TYPE,
1647: p_category OUT NOCOPY VARCHAR2,
1648: p_dist_num OUT NOCOPY VARCHAR2);
1649:
1650: /*========================================================================

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

1664: | Date Author Description of Changes
1665: | 23-Feb-2010 Dharma Theja Reddy S Created
1666: |
1667: *=======================================================================*/
1668: FUNCTION getMaxDistLineNumber(p_report_header_id IN ap_pol_violations_all.REPORT_HEADER_ID%TYPE,
1669: p_dist_line_number IN ap_pol_violations_all.DISTRIBUTION_LINE_NUMBER%TYPE) RETURN NUMBER;
1670:
1671: /*========================================================================
1672: | PUBLIC PROCEDURE performDuplicateDetection

Line 1669: p_dist_line_number IN ap_pol_violations_all.DISTRIBUTION_LINE_NUMBER%TYPE) RETURN NUMBER;

1665: | 23-Feb-2010 Dharma Theja Reddy S Created
1666: |
1667: *=======================================================================*/
1668: FUNCTION getMaxDistLineNumber(p_report_header_id IN ap_pol_violations_all.REPORT_HEADER_ID%TYPE,
1669: p_dist_line_number IN ap_pol_violations_all.DISTRIBUTION_LINE_NUMBER%TYPE) RETURN NUMBER;
1670:
1671: /*========================================================================
1672: | PUBLIC PROCEDURE performDuplicateDetection
1673: |

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

1672: | PUBLIC PROCEDURE performDuplicateDetection
1673: |
1674: | DESCRIPTION
1675: | This procedure performs the duplicate detection for the expense line and
1676: | inserts the violations on to the table ap_pol_violations_all.
1677: |
1678: | MODIFICATION HISTORY
1679: | Date Author Description of Changes
1680: | 23-Feb-2010 Dharma Theja Reddy S Created