DBA Data[Home] [Help]

APPS.AP_WEB_DB_EXPRPT_PKG dependencies on AP_WEB_POLICY_UTILS

Line 1480: SELECT AP_WEB_POLICY_UTILS.get_lookup_meaning('OIE_AUD_RETURN_REASONS',aerh.return_reason_code),

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,
1483: p_return_instruction
1484: FROM ap_expense_report_headers aerh

Line 1481: AP_WEB_POLICY_UTILS.get_lookup_description('OIE_AUD_RETURN_REASONS',aerh.return_reason_code)||' '||aerh.return_instruction

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,
1483: p_return_instruction
1484: FROM ap_expense_report_headers aerh
1485: WHERE aerh.report_header_id = p_report_header_id;