DBA Data[Home] [Help]

APPS.AP_WEB_DB_EXPRPT_PKG dependencies on AP_WEB_POLICY_UTILS

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

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,
1497: p_return_instruction
1498: FROM ap_expense_report_headers aerh

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

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,
1497: p_return_instruction
1498: FROM ap_expense_report_headers aerh
1499: WHERE aerh.report_header_id = p_report_header_id;