APPS.AP_WEB_DB_EXPRPT_PKG dependencies on AP_WEB_DB_EXPRPT_PKG

Line 1: PACKAGE BODY AP_WEB_DB_EXPRPT_PKG AS

1: PACKAGE BODY AP_WEB_DB_EXPRPT_PKG AS
2: /* $Header: apwdberb.pls 120.52.12000000.3 2007/10/11 09:50:24 stalasil ship $ */
3:
4: ----------------------------------------------------------------------------------------
5: -- Name: GetEmployeeIdFromBothPayParent

Line 1205: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPRPT_PKG',

1201: l_employee_id number;
1202:
1203: BEGIN
1204:
1205: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPRPT_PKG',
1206: 'start DuplicateHeader');
1207:
1208: select EMPLOYEE_ID into l_employee_id
1209: from AP_EXPENSE_REPORT_HEADERS

Line 1344: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPRPT_PKG',

1340: l_invoice_num as INVOICE_NUM
1341: from AP_EXPENSE_REPORT_HEADERS
1342: where REPORT_HEADER_ID = p_source_report_header_id;
1343:
1344: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPRPT_PKG',
1345: 'end DuplicateHeader');
1346:
1347: END DuplicateHeader;
1348: --------------------------------------------------------------------------------

Line 1478: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DB_EXPRPT_PKG', 'start getAuditReturnReasonInstr');

1474: p_return_instruction OUT NOCOPY VARCHAR2)
1475: RETURN BOOLEAN IS
1476:
1477: BEGIN
1478: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DB_EXPRPT_PKG', 'start getAuditReturnReasonInstr');
1479:
1480: SELECT AP_WEB_POLICY_UTILS.get_lookup_meaning('OIE_AUD_RETURN_REASONS',aerh.return_reason_code),
1481: AP_WEB_POLICY_UTILS.get_lookup_description('OIE_AUD_RETURN_REASONS',aerh.return_reason_code)||' '||aerh.return_instruction
1482: INTO p_return_reason,

Line 1508: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DB_EXPRPT_PKG', 'start clearAuditReturnReasonInstr');

1504: p_report_header_id IN expHdr_headerID)
1505: IS
1506:
1507: BEGIN
1508: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DB_EXPRPT_PKG', 'start clearAuditReturnReasonInstr');
1509:
1510: UPDATE ap_expense_report_headers aerh
1511: SET aerh.return_reason_code = '',
1512: aerh.return_instruction = ''

Line 1717: END AP_WEB_DB_EXPRPT_PKG;

1713: AP_WEB_DB_UTIL_PKG.RaiseException('GetERLastUpdateDate');
1714: APP_EXCEPTION.RAISE_EXCEPTION;
1715: END GetERLastUpdateDate;
1716:
1717: END AP_WEB_DB_EXPRPT_PKG;