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.61 2012/02/09 14:56:58 dsadipir ship $ */
3:
4: ----------------------------------------------------------------------------------------
5: -- Name: GetEmployeeIdFromBothPayParent

Line 1217: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPRPT_PKG',

1213: l_employee_id number;
1214:
1215: BEGIN
1216:
1217: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPRPT_PKG',
1218: 'start DuplicateHeader');
1219:
1220: select EMPLOYEE_ID into l_employee_id
1221: from AP_EXPENSE_REPORT_HEADERS

Line 1356: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPRPT_PKG',

1352: l_invoice_num as INVOICE_NUM
1353: from AP_EXPENSE_REPORT_HEADERS
1354: where REPORT_HEADER_ID = p_source_report_header_id;
1355:
1356: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_DB_EXPRPT_PKG',
1357: 'end DuplicateHeader');
1358:
1359: END DuplicateHeader;
1360: --------------------------------------------------------------------------------

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

1488: p_return_instruction OUT NOCOPY VARCHAR2)
1489: RETURN BOOLEAN IS
1490:
1491: BEGIN
1492: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DB_EXPRPT_PKG', 'start getAuditReturnReasonInstr');
1493:
1494: SELECT AP_WEB_POLICY_UTILS.get_lookup_meaning('OIE_AUD_RETURN_REASONS',aerh.return_reason_code),
1495: AP_WEB_POLICY_UTILS.get_lookup_description('OIE_AUD_RETURN_REASONS',aerh.return_reason_code)||' '||aerh.return_instruction
1496: INTO p_return_reason,

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

1518: p_report_header_id IN expHdr_headerID)
1519: IS
1520:
1521: BEGIN
1522: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DB_EXPRPT_PKG', 'start clearAuditReturnReasonInstr');
1523:
1524: UPDATE ap_expense_report_headers aerh
1525: SET aerh.return_reason_code = '',
1526: aerh.return_instruction = ''

Line 1910: END AP_WEB_DB_EXPRPT_PKG;

1906: AP_WEB_DB_UTIL_PKG.RaiseException('CopyAttachments');
1907: APP_EXCEPTION.RAISE_EXCEPTION;
1908: END CopyAttachments;
1909:
1910: END AP_WEB_DB_EXPRPT_PKG;