APPS.RCV_NORMALIZE_DATA_PKG dependencies on MO_GLOBAL

Line 217: IF (NVL(mo_global.check_access(p_rti_row.org_id),'N') = 'N') THEN

213: IF (p_rti_row.transaction_type <> 'UNORDERED' AND p_rti_row.source_document_code <> 'INVENTORY'
214: AND p_rti_row.validation_flag='Y' and p_rti_row.mobile_txn<>'Y') THEN -- bug 5147243
215: IF (l_true = TRUE) -- BugFix 5078706
216: THEN
217: IF (NVL(mo_global.check_access(p_rti_row.org_id),'N') = 'N') THEN
218: rcv_error_pkg.set_error_message('RCV_NOT_IN_ORG');
219: rcv_error_pkg.set_token('ORG_ID', p_rti_row.org_id);
220: rcv_error_pkg.set_token('OU', mo_global.get_current_org_id);
221: rcv_error_pkg.log_interface_error('ORG_ID');

Line 220: rcv_error_pkg.set_token('OU', mo_global.get_current_org_id);

216: THEN
217: IF (NVL(mo_global.check_access(p_rti_row.org_id),'N') = 'N') THEN
218: rcv_error_pkg.set_error_message('RCV_NOT_IN_ORG');
219: rcv_error_pkg.set_token('ORG_ID', p_rti_row.org_id);
220: rcv_error_pkg.set_token('OU', mo_global.get_current_org_id);
221: rcv_error_pkg.log_interface_error('ORG_ID');
222: END IF;
223: END IF; -- BugFix 5078706
224: END IF;

Line 374: AND ( mo_global.check_access(org_id) = 'Y'

370: processing_request_id = g_request_id
371: WHERE processing_status_code = 'PENDING'
372: AND ( processing_request_id = g_request_id
373: OR processing_request_id IS NULL)
374: AND ( mo_global.check_access(org_id) = 'Y'
375: OR org_id IS NULL)
376: AND ( lpn_group_id IS NOT NULL
377: OR lpn_id IS NOT NULL
378: OR license_plate_number IS NOT NULL

Line 512: AND ( mo_global.check_access(org_id) = 'Y'

508: CURSOR c_get_all_pending_rhi_row IS
509: SELECT *
510: FROM rcv_headers_interface
511: WHERE processing_status_code = 'PENDING'
512: AND ( mo_global.check_access(org_id) = 'Y'
513: OR org_id IS NULL)
514: ORDER BY group_id, header_interface_id; -- added by bug 16393104 to avoid deadlock
515: -- FOR UPDATE NOWAIT; --Added by bug 13587955
516:

Line 536: AND ( mo_global.check_access(org_id) = 'Y'

532: SELECT *
533: FROM rcv_transactions_interface
534: WHERE processing_status_code = 'PENDING'
535: AND processing_mode_code = g_processing_mode -- Bug 6311798
536: AND ( mo_global.check_access(org_id) = 'Y'
537: OR org_id IS NULL)
538: ) rcv
539: CONNECT BY PRIOR rcv.interface_transaction_id = rcv.parent_interface_txn_id
540: START WITH rcv.parent_interface_txn_id IS NULL --Reverted the initial fix of 12718851 and keeping the original code

Line 579: AND ( mo_global.check_access(rti.org_id) = 'Y'

575: SELECT *
576: FROM rcv_transactions_interface rti
577: WHERE rti.processing_status_code = 'PENDING'
578: AND rti.processing_mode_code = g_processing_mode -- Bug 6311798
579: AND ( mo_global.check_access(rti.org_id) = 'Y'
580: OR rti.org_id IS NULL)
581: CONNECT BY PRIOR rti.interface_transaction_id = parent_interface_txn_id
582: START WITH rti.interface_transaction_id IN (SELECT rti1.interface_transaction_id --Bug:5473673
583: FROM rcv_transactions_interface rti1

Line 717: IF (NVL(mo_global.check_access(g_org_id),'N') = 'N') THEN

713: -- Bug 14370850
714: g_org_id := p_org_id;
715:
716: IF (g_org_id <> -1) THEN
717: IF (NVL(mo_global.check_access(g_org_id),'N') = 'N') THEN
718: asn_debug.put_line ('No access allowed. Returning');
719: RETURN;
720: END IF;
721: