APPS.AP_WEB_DB_EXPRPT_PKG dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 174: FROM ap_expense_report_headers_all

170: --------------------------------------------------------------------------------
171: BEGIN
172: SELECT org_id
173: INTO p_org_id
174: FROM ap_expense_report_headers_all
175: WHERE report_header_id = p_header_id;
176:
177: return TRUE;
178: EXCEPTION

Line 1677: l_invoice_num AP_EXPENSE_REPORT_HEADERS_ALL.INVOICE_NUM%TYPE;

1673: ------------------------------------------------------------------------
1674: FUNCTION GetERInvoiceNumber(p_report_header_id IN NUMBER)
1675: RETURN VARCHAR2 IS
1676:
1677: l_invoice_num AP_EXPENSE_REPORT_HEADERS_ALL.INVOICE_NUM%TYPE;
1678:
1679: BEGIN
1680: SELECT invoice_num
1681: INTO l_invoice_num

Line 1682: FROM ap_expense_report_headers_all

1678:
1679: BEGIN
1680: SELECT invoice_num
1681: INTO l_invoice_num
1682: FROM ap_expense_report_headers_all
1683: WHERE report_header_id = p_report_header_id;
1684:
1685: return l_invoice_num;
1686: EXCEPTION

Line 1699: l_workflow_approved_flag AP_EXPENSE_REPORT_HEADERS_ALL.WORKFLOW_APPROVED_FLAG%TYPE;

1695: -- 03/22/2005 - Kristian Widjaja
1696: ------------------------------------------------------------------------
1697: FUNCTION GetERWorkflowApprovedFlag(p_report_header_id IN NUMBER)
1698: RETURN VARCHAR2 IS
1699: l_workflow_approved_flag AP_EXPENSE_REPORT_HEADERS_ALL.WORKFLOW_APPROVED_FLAG%TYPE;
1700:
1701: BEGIN
1702: SELECT workflow_approved_flag
1703: INTO l_workflow_approved_flag

Line 1704: FROM ap_expense_report_headers_all

1700:
1701: BEGIN
1702: SELECT workflow_approved_flag
1703: INTO l_workflow_approved_flag
1704: FROM ap_expense_report_headers_all
1705: WHERE report_header_id = p_report_header_id;
1706:
1707: return l_workflow_approved_flag;
1708: EXCEPTION

Line 1721: FROM ap_expense_report_headers_all

1717:
1718: BEGIN
1719: SELECT to_char(last_update_date, 'DD-MON-RRRR HH:MI:SS', 'NLS_DATE_LANGUAGE = ENGLISH')
1720: INTO l_last_update_date
1721: FROM ap_expense_report_headers_all
1722: WHERE report_header_id = p_report_header_id;
1723:
1724: return l_last_update_date;
1725: EXCEPTION