DBA Data[Home] [Help]

APPS.AP_WEB_POLICY_UTILS dependencies on AP_EXPENSE_REPORT_LINES_ALL

Line 1559: FUNCTION getDuplicateDetectionRule(p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,

1555: | Date Author Description of Changes
1556: | 23-Feb-2010 Dharma Theja Reddy S Created
1557: |
1558: *=======================================================================*/
1559: FUNCTION getDuplicateDetectionRule(p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,
1560: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,
1561: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN NUMBER;
1562:
1563: /*========================================================================

Line 1560: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,

1556: | 23-Feb-2010 Dharma Theja Reddy S Created
1557: |
1558: *=======================================================================*/
1559: FUNCTION getDuplicateDetectionRule(p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,
1560: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,
1561: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN NUMBER;
1562:
1563: /*========================================================================
1564: | PUBLIC FUNCTION isDupDetectExists

Line 1561: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN NUMBER;

1557: |
1558: *=======================================================================*/
1559: FUNCTION getDuplicateDetectionRule(p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,
1560: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,
1561: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN NUMBER;
1562:
1563: /*========================================================================
1564: | PUBLIC FUNCTION isDupDetectExists
1565: |

Line 1585: FUNCTION isDupDetectExists(p_report_header_id ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,

1581: | Date Author Description of Changes
1582: | 23-Feb-2010 Dharma Theja Reddy S Created
1583: |
1584: *=======================================================================*/
1585: FUNCTION isDupDetectExists(p_report_header_id ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,
1586: p_dist_line_number ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE,
1587: p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,
1588: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,
1589: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN VARCHAR2;

Line 1586: p_dist_line_number ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE,

1582: | 23-Feb-2010 Dharma Theja Reddy S Created
1583: |
1584: *=======================================================================*/
1585: FUNCTION isDupDetectExists(p_report_header_id ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,
1586: p_dist_line_number ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE,
1587: p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,
1588: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,
1589: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN VARCHAR2;
1590:

Line 1587: p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,

1583: |
1584: *=======================================================================*/
1585: FUNCTION isDupDetectExists(p_report_header_id ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,
1586: p_dist_line_number ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE,
1587: p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,
1588: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,
1589: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN VARCHAR2;
1590:
1591: /*========================================================================

Line 1588: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,

1584: *=======================================================================*/
1585: FUNCTION isDupDetectExists(p_report_header_id ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,
1586: p_dist_line_number ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE,
1587: p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,
1588: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,
1589: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN VARCHAR2;
1590:
1591: /*========================================================================
1592: | PUBLIC FUNCTION getDistLineNumber

Line 1589: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN VARCHAR2;

1585: FUNCTION isDupDetectExists(p_report_header_id ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,
1586: p_dist_line_number ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE,
1587: p_org_id IN ap_expense_report_lines_all.ORG_ID%TYPE,
1588: p_category_code IN ap_expense_report_lines_all.CATEGORY_CODE%TYPE,
1589: p_start_date IN ap_expense_report_lines_all.START_EXPENSE_DATE%TYPE) RETURN VARCHAR2;
1590:
1591: /*========================================================================
1592: | PUBLIC FUNCTION getDistLineNumber
1593: |

Line 1609: FUNCTION getDistLineNumber(p_report_header_id IN ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,

1605: | Date Author Description of Changes
1606: | 23-Feb-2010 Dharma Theja Reddy S Created
1607: |
1608: *=======================================================================*/
1609: FUNCTION getDistLineNumber(p_report_header_id IN ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,
1610: p_dist_line_number IN ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE) RETURN VARCHAR2;
1611:
1612: /*========================================================================
1613: | PUBLIC PROCEDURE removeDupViolations

Line 1610: p_dist_line_number IN ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE) RETURN VARCHAR2;

1606: | 23-Feb-2010 Dharma Theja Reddy S Created
1607: |
1608: *=======================================================================*/
1609: FUNCTION getDistLineNumber(p_report_header_id IN ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,
1610: p_dist_line_number IN ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE) RETURN VARCHAR2;
1611:
1612: /*========================================================================
1613: | PUBLIC PROCEDURE removeDupViolations
1614: |

Line 1627: PROCEDURE removeDupViolations(p_report_header_id IN ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,

1623: | Date Author Description of Changes
1624: | 23-Feb-2010 Dharma Theja Reddy S Created
1625: |
1626: *=======================================================================*/
1627: PROCEDURE removeDupViolations(p_report_header_id IN ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,
1628: p_dist_line_number IN ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE);
1629:
1630: /*========================================================================
1631: | PUBLIC PROCEDURE getDistNumber

Line 1628: p_dist_line_number IN ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE);

1624: | 23-Feb-2010 Dharma Theja Reddy S Created
1625: |
1626: *=======================================================================*/
1627: PROCEDURE removeDupViolations(p_report_header_id IN ap_expense_report_lines_all.REPORT_HEADER_ID%TYPE,
1628: p_dist_line_number IN ap_expense_report_lines_all.DISTRIBUTION_LINE_NUMBER%TYPE);
1629:
1630: /*========================================================================
1631: | PUBLIC PROCEDURE getDistNumber
1632: |