DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_PROCESS dependencies on AP_WEB_UTILITIES_PKG

Line 404: OR (NVL(process_rec.paperless_audit_cc_only_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasOnlyCCLines(p_report_header_id) = TRUE)

400: IF(audit_code IS NULL OR audit_code = 'AUDIT') THEN
401: process_random_audit(p_report_header_id, audit_code);
402: IF (audit_code = 'PAPERLESS_AUDIT' AND
403: (NVL(process_rec.audit_all, 'N') = 'Y'
404: OR (NVL(process_rec.paperless_audit_cc_only_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasOnlyCCLines(p_report_header_id) = TRUE)
405: OR (NVL(process_rec.paperless_audit_violation_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasViolations(p_report_header_id) = TRUE)
406: OR (NVL(process_rec.paperless_audit_pdm_only_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasNonRecLines(p_report_header_id) = TRUE)))
407: THEN
408: IF (NVL(process_rec.assign_auditor_stage_code,'MANAGER_APPROVAL') = 'SUBMISSION') THEN

Line 405: OR (NVL(process_rec.paperless_audit_violation_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasViolations(p_report_header_id) = TRUE)

401: process_random_audit(p_report_header_id, audit_code);
402: IF (audit_code = 'PAPERLESS_AUDIT' AND
403: (NVL(process_rec.audit_all, 'N') = 'Y'
404: OR (NVL(process_rec.paperless_audit_cc_only_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasOnlyCCLines(p_report_header_id) = TRUE)
405: OR (NVL(process_rec.paperless_audit_violation_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasViolations(p_report_header_id) = TRUE)
406: OR (NVL(process_rec.paperless_audit_pdm_only_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasNonRecLines(p_report_header_id) = TRUE)))
407: THEN
408: IF (NVL(process_rec.assign_auditor_stage_code,'MANAGER_APPROVAL') = 'SUBMISSION') THEN
409: AP_WEB_AUDIT_QUEUE_UTILS.enqueue_for_audit(p_report_header_id);

Line 406: OR (NVL(process_rec.paperless_audit_pdm_only_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasNonRecLines(p_report_header_id) = TRUE)))

402: IF (audit_code = 'PAPERLESS_AUDIT' AND
403: (NVL(process_rec.audit_all, 'N') = 'Y'
404: OR (NVL(process_rec.paperless_audit_cc_only_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasOnlyCCLines(p_report_header_id) = TRUE)
405: OR (NVL(process_rec.paperless_audit_violation_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasViolations(p_report_header_id) = TRUE)
406: OR (NVL(process_rec.paperless_audit_pdm_only_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasNonRecLines(p_report_header_id) = TRUE)))
407: THEN
408: IF (NVL(process_rec.assign_auditor_stage_code,'MANAGER_APPROVAL') = 'SUBMISSION') THEN
409: AP_WEB_AUDIT_QUEUE_UTILS.enqueue_for_audit(p_report_header_id);
410: END IF;

Line 427: OR (NVL(process_rec.paperless_audit_cc_only_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasOnlyCCLines(p_report_header_id) = TRUE)

423: audit_code := process_rec.audit_code;
424:
425: IF (audit_code = 'PAPERLESS_AUDIT' AND
426: (NVL(process_rec.audit_all, 'N') = 'Y'
427: OR (NVL(process_rec.paperless_audit_cc_only_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasOnlyCCLines(p_report_header_id) = TRUE)
428: OR (NVL(process_rec.paperless_audit_violation_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasViolations(p_report_header_id) = TRUE)
429: OR (NVL(process_rec.paperless_audit_pdm_only_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasNonRecLines(p_report_header_id) = TRUE)))
430: THEN
431: IF (NVL(process_rec.assign_auditor_stage_code,'MANAGER_APPROVAL') = 'SUBMISSION') THEN

Line 428: OR (NVL(process_rec.paperless_audit_violation_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasViolations(p_report_header_id) = TRUE)

424:
425: IF (audit_code = 'PAPERLESS_AUDIT' AND
426: (NVL(process_rec.audit_all, 'N') = 'Y'
427: OR (NVL(process_rec.paperless_audit_cc_only_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasOnlyCCLines(p_report_header_id) = TRUE)
428: OR (NVL(process_rec.paperless_audit_violation_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasViolations(p_report_header_id) = TRUE)
429: OR (NVL(process_rec.paperless_audit_pdm_only_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasNonRecLines(p_report_header_id) = TRUE)))
430: THEN
431: IF (NVL(process_rec.assign_auditor_stage_code,'MANAGER_APPROVAL') = 'SUBMISSION') THEN
432: AP_WEB_AUDIT_QUEUE_UTILS.enqueue_for_audit(p_report_header_id);

Line 429: OR (NVL(process_rec.paperless_audit_pdm_only_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasNonRecLines(p_report_header_id) = TRUE)))

425: IF (audit_code = 'PAPERLESS_AUDIT' AND
426: (NVL(process_rec.audit_all, 'N') = 'Y'
427: OR (NVL(process_rec.paperless_audit_cc_only_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasOnlyCCLines(p_report_header_id) = TRUE)
428: OR (NVL(process_rec.paperless_audit_violation_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasViolations(p_report_header_id) = TRUE)
429: OR (NVL(process_rec.paperless_audit_pdm_only_flag, 'N') = 'Y' AND AP_WEB_UTILITIES_PKG.ReportHasNonRecLines(p_report_header_id) = TRUE)))
430: THEN
431: IF (NVL(process_rec.assign_auditor_stage_code,'MANAGER_APPROVAL') = 'SUBMISSION') THEN
432: AP_WEB_AUDIT_QUEUE_UTILS.enqueue_for_audit(p_report_header_id);
433: COMMIT;