APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on MTL_PARAMETERS

Line 254: FROM mtl_parameters

250: END IF;
251:
252: SELECT default_cost_group_id
253: INTO x_cost_group_id
254: FROM mtl_parameters
255: WHERE organization_id = p_organization_id;
256:
257: IF (l_debug = 1) THEN
258: print_debug('x_cost_group_id = ' || x_cost_group_id, 9);

Line 401: mtl_parameters parentorg, mtl_parameters logicalorg,

397: l_parentorg_process_org, l_logicalorg_process_org,
398: l_logicalorg_ou_id, l_parentorg_currency,
399: l_transfer_price
400: FROM mtl_material_transactions_temp mmtt,
401: mtl_parameters parentorg, mtl_parameters logicalorg,
402: cst_organization_definitions cod, cst_organization_definitions codx
403: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
404: AND parentorg.organization_id = mmtt.organization_id
405: AND logicalorg.organization_id = mmtt.transfer_organization

Line 425: FROM mtl_parameters

421: --changes for backport3990277
422: --check if Project ref enabled
423: SELECT NVL(project_reference_enabled,2)
424: INTO prj_ref_enabled
425: FROM mtl_parameters
426: WHERE organization_id = l_organization_id ;
427:
428: SELECT REQUISITION_HEADER_ID
429: INTO l_trx_src_id

Line 1350: | 3 - Use the flag set at the Org level. mtl_parameters|

1346: | 1 - YES. This would indicate that the creation of |
1347: | logical transactions would be deferred. |
1348: | 2 - No. This would indicate that the creation of |
1349: | logical transactions would not be deferred. |
1350: | 3 - Use the flag set at the Org level. mtl_parameters|
1351: | will hold the default value for a specific |
1352: | organization. |
1353: | Default would be set to 3 - use the flag set at |
1354: | the organization level. |

Line 1490: -- get the defer logical transactions flag from mtl_parameters

1486:
1487:
1488: l_progress := 10;
1489: -- If the defer accounting trx is 3 (at org level)
1490: -- get the defer logical transactions flag from mtl_parameters
1491: IF (l_defer_logical_trx = G_DEFER_LOGICAL_TRX_ORG_LEVEL) THEN
1492: BEGIN
1493: IF (l_debug = 1) THEN
1494: print_debug('l_defer_logical_trx = 3', 9);

Line 1501: FROM mtl_parameters

1497: END IF;
1498: l_progress := 20;
1499: SELECT defer_logical_transactions
1500: INTO l_defer_logical_trx
1501: FROM mtl_parameters
1502: WHERE organization_id = p_mtl_trx_tbl(1).organization_id;
1503:
1504: l_progress := 30;
1505: IF (l_debug = 1) THEN

Line 1511: print_debug('Cannot get defer logical trx flag from mtl_parameters', 9);

1507: END IF;
1508: EXCEPTION
1509: WHEN no_data_found THEN
1510: IF (l_debug = 1) THEN
1511: print_debug('Cannot get defer logical trx flag from mtl_parameters', 9);
1512: END IF;
1513: FND_MESSAGE.SET_NAME('INV', 'INV_DEFER_LOGICAL_ERR');
1514: FND_MSG_PUB.ADD;
1515: RAISE FND_API.G_EXC_ERROR;

Line 3107: FROM mtl_parameters

3103: l_prev_organization_id := p_mtl_trx_tbl(i).organization_id;
3104:
3105: SELECT NVL(process_enabled_flag, 'N')
3106: INTO l_process_enabled_flag
3107: FROM mtl_parameters
3108: WHERE organization_id = p_mtl_trx_tbl(i).organization_id;
3109: END IF;
3110:
3111: IF (l_debug = 1) THEN

Line 4245: FROM mtl_parameters mp

4241:
4242: CURSOR c_process_flag(p_organization_id BINARY_INTEGER)
4243: IS
4244: SELECT NVL(mp.process_enabled_flag,'N')
4245: FROM mtl_parameters mp
4246: WHERE mp.organization_id = p_organization_id;
4247:
4248:
4249: CURSOR c_from_to_ou(p_organizaiton_id BINARY_INTEGER, p_xfer_organization_id BINARY_INTEGER)

Line 4310: FROM mtl_parameters mp

4306:
4307: l_stmt_num := 20;
4308: SELECT MOD(SUM(DECODE(process_enabled_flag, 'Y', 1, 2)), 2)
4309: INTO l_pd_txfr_ind
4310: FROM mtl_parameters mp
4311: WHERE mp.organization_id = l_organization_id
4312: OR mp.organization_id = l_xfer_organization_id;
4313:
4314: IF l_pd_txfr_ind <> 1

Line 4878: FROM mtl_parameters

4874: l_stmt_num := 160;
4875: SELECT DECODE(NVL(process_enabled_flag, 'N'), 'N', 'N', NULL),
4876: DECODE(NVL(process_enabled_flag, 'N'), 'Y', 'N', NULL)
4877: INTO l_costed_flag, l_opm_costed_flag
4878: FROM mtl_parameters
4879: WHERE organization_id = l_owner_org_id;
4880:
4881:
4882: IF (l_debug = 1) THEN