APPS.AP_WEB_DB_EXPRPT_PKG dependencies on AP_WEB_UTILITIES_PKG

Line 620: AP_WEB_UTILITIES_PKG.RtrimMultiByteSpaces(p_ExpReportHeaderInfo.purpose),

616: p_xpense_rec.document_number,
617: to_number(p_ExpReportHeaderInfo.template_id),
618: p_xpense_rec.set_of_books_id,
619: p_xpense_rec.source,
620: AP_WEB_UTILITIES_PKG.RtrimMultiByteSpaces(p_ExpReportHeaderInfo.purpose),
621: p_ExpReportHeaderInfo.cost_center,
622: p_ExpReportHeaderInfo.reimbursement_currency_code,
623: p_ExpReportHeaderInfo.reimbursement_currency_code,
624: sysdate,

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 1458: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DB_CCARD_PKG', 'start getPaymentDueFromReport');

1454: p_payment_due_from_code VARCHAR2(30);
1455: -----------------------------------------------------------------------------
1456: BEGIN
1457: p_paymentDueFromCode := NULL;
1458: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DB_CCARD_PKG', 'start getPaymentDueFromReport');
1459:
1460: SELECT payment_due_from_code
1461: INTO p_paymentDueFromCode
1462: FROM ap_credit_card_trxns_all trx

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 = ''