APPS.AP_WEB_DB_EXPRPT_PKG dependencies on AP_WEB_UTILITIES_PKG

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

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

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

1440: p_payment_due_from_code VARCHAR2(30);
1441: -----------------------------------------------------------------------------
1442: BEGIN
1443: p_paymentDueFromCode := NULL;
1444: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_DB_CCARD_PKG', 'start getPaymentDueFromReport');
1445:
1446: SELECT payment_due_from_code
1447: INTO p_paymentDueFromCode
1448: FROM ap_credit_card_trxns_all trx

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