DBA Data[Home] [Help]

APPS.INV_RCV_INTEGRATION_PVT dependencies on MTL_INTERORG_PARAMETERS

Line 7783: --mtl_interorg_parameters is set to 'Direct' then exit from this api.

7779: RETURN;
7780: END IF;
7781:
7782: --If the source document is 'REQ' then of the intransit_type in
7783: --mtl_interorg_parameters is set to 'Direct' then exit from this api.
7784: IF (l_rti_rec.source_document_code = 'REQ'
7785: AND l_rti_rec.mobile_txn = 'N'
7786: AND l_rti_rec.transaction_type = 'RECEIVE'
7787: AND l_rti_rec.inv_transaction_id IS NOT NULL

Line 7792: FROM mtl_interorg_parameters

7788: AND l_rti_rec.processing_mode_code = 'ONLINE') THEN
7789: BEGIN
7790: SELECT intransit_type
7791: INTO l_intransit_type
7792: FROM mtl_interorg_parameters
7793: WHERE from_organization_id = l_rti_rec.from_organization_id
7794: AND to_organization_id = l_rti_rec.to_organization_id;
7795:
7796: EXCEPTION

Line 13402: --mtl_interorg_parameters is set to 'Direct' then exit from this api.

13398: print_debug('VALIDATE_LPN_INFO - Transaction type :'||l_lpn_rec.transaction_type||':'||l_progress, 1);
13399: END If;
13400:
13401: --If the source document is 'REQ' then of the intransit_type in
13402: --mtl_interorg_parameters is set to 'Direct' then exit from this api.
13403: IF (l_lpn_rec.source_document_code = 'REQ'
13404: AND l_lpn_rec.mobile_txn = 'N'
13405: AND l_lpn_rec.transaction_type = 'RECEIVE'
13406: AND l_lpn_rec.inv_transaction_id IS NOT NULL

Line 13411: FROM mtl_interorg_parameters

13407: AND l_lpn_rec.processing_mode_code = 'ONLINE') THEN
13408: BEGIN
13409: SELECT intransit_type
13410: INTO l_intransit_type
13411: FROM mtl_interorg_parameters
13412: WHERE from_organization_id = l_lpn_rec.from_organization_id
13413: AND to_organization_id = l_lpn_rec.to_organization_id;
13414:
13415: IF (l_intransit_type = 1) THEN

Line 18257: --mtl_interorg_parameters is set to 'Direct' then exit from this api.

18253: RETURN;
18254: END IF;
18255:
18256: --If the source document is 'REQ' then of the intransit_type in
18257: --mtl_interorg_parameters is set to 'Direct' then exit from this api.
18258: IF (l_source_document_code = 'REQ'
18259: AND l_mobile_txn = 'N'
18260: AND l_transaction_type = 'RECEIVE'
18261: AND l_inv_txn_id IS NOT NULL

Line 18266: FROM mtl_interorg_parameters

18262: AND l_proc_mode_code = 'ONLINE') THEN
18263: BEGIN
18264: SELECT intransit_type
18265: INTO l_intransit_type
18266: FROM mtl_interorg_parameters
18267: WHERE from_organization_id = l_from_org_id
18268: AND to_organization_id = l_org_id;
18269:
18270: IF (l_intransit_type = 1) THEN