DBA Data[Home] [Help]

APPS.INV_RCV_INTEGRATION_PVT dependencies on MTL_INTERORG_PARAMETERS

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

8089: RETURN;
8090: END IF;
8091:
8092: --If the source document is 'REQ' then of the intransit_type in
8093: --mtl_interorg_parameters is set to 'Direct' then exit from this api.
8094: IF (l_rti_rec.source_document_code = 'REQ'
8095: AND l_rti_rec.mobile_txn = 'N'
8096: AND l_rti_rec.transaction_type = 'RECEIVE'
8097: AND l_rti_rec.inv_transaction_id IS NOT NULL

Line 8102: FROM mtl_interorg_parameters

8098: AND l_rti_rec.processing_mode_code = 'ONLINE') THEN
8099: BEGIN
8100: SELECT intransit_type
8101: INTO l_intransit_type
8102: FROM mtl_interorg_parameters
8103: WHERE from_organization_id = l_rti_rec.from_organization_id
8104: AND to_organization_id = l_rti_rec.to_organization_id;
8105:
8106: EXCEPTION

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

14089: --END Changes for the Bug:13613257
14090:
14091:
14092: --If the source document is 'REQ' then of the intransit_type in
14093: --mtl_interorg_parameters is set to 'Direct' then exit from this api.
14094: IF (l_lpn_rec.source_document_code = 'REQ'
14095: AND l_lpn_rec.mobile_txn = 'N'
14096: AND l_lpn_rec.transaction_type = 'RECEIVE'
14097: AND l_lpn_rec.inv_transaction_id IS NOT NULL

Line 14102: FROM mtl_interorg_parameters

14098: AND l_lpn_rec.processing_mode_code = 'ONLINE') THEN
14099: BEGIN
14100: SELECT intransit_type
14101: INTO l_intransit_type
14102: FROM mtl_interorg_parameters
14103: WHERE from_organization_id = l_lpn_rec.from_organization_id
14104: AND to_organization_id = l_lpn_rec.to_organization_id;
14105:
14106: IF (l_intransit_type = 1) THEN

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

19270: RETURN;
19271: END IF;
19272:
19273: --If the source document is 'REQ' then of the intransit_type in
19274: --mtl_interorg_parameters is set to 'Direct' then exit from this api.
19275: IF (l_source_document_code = 'REQ'
19276: AND l_mobile_txn = 'N'
19277: AND l_transaction_type = 'RECEIVE'
19278: AND l_inv_txn_id IS NOT NULL

Line 19283: FROM mtl_interorg_parameters

19279: AND l_proc_mode_code = 'ONLINE') THEN
19280: BEGIN
19281: SELECT intransit_type
19282: INTO l_intransit_type
19283: FROM mtl_interorg_parameters
19284: WHERE from_organization_id = l_from_org_id
19285: AND to_organization_id = l_org_id;
19286:
19287: IF (l_intransit_type = 1) THEN