APPS.RCV_NORMALIZE_DATA_PKG dependencies on MO_GLOBAL

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

200:
201: IF (p_rti_row.transaction_type <> 'UNORDERED' AND p_rti_row.source_document_code <> 'INVENTORY') THEN -- bug 5147243
202: IF (l_true = TRUE) -- BugFix 5078706
203: THEN
204: IF (NVL(mo_global.check_access(p_rti_row.org_id),'N') = 'N') THEN
205: rcv_error_pkg.set_error_message('RCV_NOT_IN_ORG');
206: rcv_error_pkg.set_token('ORG_ID', p_rti_row.org_id);
207: rcv_error_pkg.set_token('OU', mo_global.get_current_org_id);
208: rcv_error_pkg.log_interface_error('ORG_ID');

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

203: THEN
204: IF (NVL(mo_global.check_access(p_rti_row.org_id),'N') = 'N') THEN
205: rcv_error_pkg.set_error_message('RCV_NOT_IN_ORG');
206: rcv_error_pkg.set_token('ORG_ID', p_rti_row.org_id);
207: rcv_error_pkg.set_token('OU', mo_global.get_current_org_id);
208: rcv_error_pkg.log_interface_error('ORG_ID');
209: END IF;
210: END IF; -- BugFix 5078706
211: END IF;

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

333: processing_request_id = g_request_id
334: WHERE processing_status_code = 'PENDING'
335: AND ( processing_request_id = g_request_id
336: OR processing_request_id IS NULL)
337: AND ( mo_global.check_access(org_id) = 'Y'
338: OR org_id IS NULL)
339: AND ( lpn_group_id IS NOT NULL
340: OR lpn_id IS NOT NULL
341: OR license_plate_number IS NOT NULL

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

417: CURSOR c_get_all_pending_rhi_row IS
418: SELECT *
419: FROM rcv_headers_interface
420: WHERE processing_status_code = 'PENDING'
421: AND ( mo_global.check_access(org_id) = 'Y'
422: OR org_id IS NULL);
423:
424: CURSOR c_get_pending_rhi_row IS
425: SELECT *

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

436: SELECT *
437: FROM rcv_transactions_interface
438: WHERE processing_status_code = 'PENDING'
439: AND processing_mode_code = g_processing_mode -- Bug 6311798
440: AND ( mo_global.check_access(org_id) = 'Y'
441: OR org_id IS NULL)
442: CONNECT BY PRIOR interface_transaction_id = parent_interface_txn_id
443: START WITH parent_interface_txn_id IS NULL
444: ORDER BY GROUP_ID;

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

467: SELECT *
468: FROM rcv_transactions_interface
469: WHERE processing_status_code = 'PENDING'
470: AND processing_mode_code = g_processing_mode -- Bug 6311798
471: AND ( mo_global.check_access(org_id) = 'Y'
472: OR org_id IS NULL)
473: CONNECT BY PRIOR interface_transaction_id = parent_interface_txn_id
474: START WITH interface_transaction_id IN (SELECT interface_transaction_id --Bug:5473673
475: FROM rcv_transactions_interface