DBA Data[Home] [Help]

APPS.AP_WEB_EXPENSE_WF dependencies on AP_WEB_AUDIT_QUEUE_UTILS

Line 5566: l_debug_info := 'Call AP_WEB_AUDIT_QUEUE_UTILS.remove_from_queue';

5562:
5563: END IF;
5564:
5565: -----------------------------------------------------------------
5566: l_debug_info := 'Call AP_WEB_AUDIT_QUEUE_UTILS.remove_from_queue';
5567: -----------------------------------------------------------------
5568: AP_WEB_AUDIT_QUEUE_UTILS.remove_from_queue(l_report_header_id);
5569:
5570: ----------------------------------------------------------

Line 5568: AP_WEB_AUDIT_QUEUE_UTILS.remove_from_queue(l_report_header_id);

5564:
5565: -----------------------------------------------------------------
5566: l_debug_info := 'Call AP_WEB_AUDIT_QUEUE_UTILS.remove_from_queue';
5567: -----------------------------------------------------------------
5568: AP_WEB_AUDIT_QUEUE_UTILS.remove_from_queue(l_report_header_id);
5569:
5570: ----------------------------------------------------------
5571: l_debug_info := 'Clearing out lines in AP_AUD_AUDIT_REASONS';
5572: ----------------------------------------------------------

Line 11105: AP_WEB_AUDIT_QUEUE_UTILS.remove_from_queue(l_report_header_id);

11101: NULL;
11102: END IF;*/
11103:
11104: --AP_WEB_DB_VIOLATIONS_PKG.deleteViolationEntry(l_report_header_id);
11105: AP_WEB_AUDIT_QUEUE_UTILS.remove_from_queue(l_report_header_id);
11106:
11107: ----------------------------------------------------------
11108: l_debug_info := 'Clearing out lines in AP_AUD_AUDIT_REASONS';
11109: ----------------------------------------------------------

Line 11801: AP_WEB_AUDIT_QUEUE_UTILS.remove_from_queue(p_rep_header_id);

11797:
11798: --AP_WEB_DB_VIOLATIONS_PKG.deleteViolationEntry(p_rep_header_id);
11799: --Delete the duplicate detection violations
11800: AP_WEB_DB_VIOLATIONS_PKG.deleteDupViolationEntry(p_rep_header_id);
11801: AP_WEB_AUDIT_QUEUE_UTILS.remove_from_queue(p_rep_header_id);
11802:
11803: ----------------------------------------------------------
11804: l_debug_info := 'Reset Report Submitted Date to null And Expense Status Code to WITHDRAWN';
11805: ----------------------------------------------------------

Line 14484: AP_WEB_AUDIT_QUEUE_UTILS.enqueue_for_audit(l_report_header_id);

14480: AND
14481: rule_rec.assign_auditor_stage_code = 'MANAGER_APPROVAL'
14482: AND nvl(rule_rec.workflow_approved_flag,'N') = 'M') THEN
14483: IF (l_auditor_id IS NULL) THEN
14484: AP_WEB_AUDIT_QUEUE_UTILS.enqueue_for_audit(l_report_header_id);
14485: END IF;
14486: END IF;
14487:
14488: CLOSE rule_cur;

Line 14506: AP_WEB_AUDIT_QUEUE_UTILS.enqueue_for_audit(l_report_header_id);

14502:
14503: IF ((NVL(recpt_rec.AUD_IMG_RECEIPT_REQUIRED, 'N') = 'Y' AND l_image_receipts_status = 'RECEIVED')
14504: OR (NVL(recpt_rec.AUD_PAPER_RECEIPT_REQUIRED, 'N') = 'Y' AND l_receipts_status = 'RECEIVED')) THEN
14505: IF (l_auditor_id IS NULL) THEN
14506: AP_WEB_AUDIT_QUEUE_UTILS.enqueue_for_audit(l_report_header_id);
14507: END IF;
14508: END IF;
14509:
14510: END IF;

Line 14531: AP_WEB_AUDIT_QUEUE_UTILS.enqueue_for_audit(l_report_header_id);

14527:
14528: IF ((NVL(recpt_rec.AUD_IMG_RECEIPT_REQUIRED, 'N') = 'Y' AND l_image_receipts_status = 'RECEIVED')
14529: OR (NVL(recpt_rec.AUD_PAPER_RECEIPT_REQUIRED, 'N') = 'Y' AND l_receipts_status = 'RECEIVED')) THEN
14530: IF (l_auditor_id IS NULL) THEN
14531: AP_WEB_AUDIT_QUEUE_UTILS.enqueue_for_audit(l_report_header_id);
14532: END IF;
14533: END IF;
14534:
14535: END IF;

Line 14553: AP_WEB_AUDIT_QUEUE_UTILS.enqueue_for_audit(l_report_header_id);

14549:
14550: IF ((NVL(recpt_rec.AUD_IMG_RECEIPT_REQUIRED, 'N') = 'Y' AND l_image_receipts_status = 'RECEIVED')
14551: OR (NVL(recpt_rec.AUD_PAPER_RECEIPT_REQUIRED, 'N') = 'Y' AND l_receipts_status = 'RECEIVED')) THEN
14552: IF (l_auditor_id IS NULL) THEN
14553: AP_WEB_AUDIT_QUEUE_UTILS.enqueue_for_audit(l_report_header_id);
14554: END IF;
14555: END IF;
14556:
14557: END IF;

Line 15106: AP_WEB_AUDIT_QUEUE_UTILS.enqueue_for_audit(l_report_header_id);

15102: IF audit_rec.audit_code = 'PAPERLESS_AUDIT' THEN
15103: ------------------------------------------------------------
15104: l_debug_info := 'Add to Audit queue';
15105: ------------------------------------------------------------
15106: AP_WEB_AUDIT_QUEUE_UTILS.enqueue_for_audit(l_report_header_id);
15107: ELSIF (audit_rec.audit_code = 'AUDIT' OR audit_rec.audit_code = 'RECEIPT_BASED') THEN
15108: ------------------------------------------------------------
15109: l_debug_info := 'Add to Audit queue';
15110: ------------------------------------------------------------

Line 15112: AP_WEB_AUDIT_QUEUE_UTILS.assign_to_last_auditor(l_report_header_id);

15108: ------------------------------------------------------------
15109: l_debug_info := 'Add to Audit queue';
15110: ------------------------------------------------------------
15111: --Bug#6618522
15112: AP_WEB_AUDIT_QUEUE_UTILS.assign_to_last_auditor(l_report_header_id);
15113: END IF;
15114:
15115: CLOSE audit_cur;
15116:

Line 15167: AP_WEB_AUDIT_QUEUE_UTILS.remove_from_queue(l_report_header_id);

15163:
15164: ------------------------------------------------------------
15165: l_debug_info := 'Remove from Audit queue';
15166: ------------------------------------------------------------
15167: AP_WEB_AUDIT_QUEUE_UTILS.remove_from_queue(l_report_header_id);
15168:
15169: p_result := 'COMPLETE:Y';
15170:
15171: ELSIF (p_funmode = 'CANCEL') THEN