APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on MTL_PARAMETERS

Line 270: FROM mtl_parameters

266: END IF;
267:
268: SELECT default_cost_group_id
269: INTO x_cost_group_id
270: FROM mtl_parameters
271: WHERE organization_id = p_organization_id;
272:
273: IF (l_debug = 1) THEN
274: print_debug('x_cost_group_id = ' || x_cost_group_id, 9);

Line 417: mtl_parameters parentorg, mtl_parameters logicalorg,

413: l_parentorg_process_org, l_logicalorg_process_org,
414: l_logicalorg_ou_id, l_parentorg_currency,
415: l_transfer_price
416: FROM mtl_material_transactions_temp mmtt,
417: mtl_parameters parentorg, mtl_parameters logicalorg,
418: cst_organization_definitions cod, cst_organization_definitions codx
419: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
420: AND parentorg.organization_id = mmtt.organization_id
421: AND logicalorg.organization_id = mmtt.transfer_organization

Line 441: FROM mtl_parameters

437: --changes for backport3990277
438: --check if Project ref enabled
439: SELECT NVL(project_reference_enabled,2)
440: INTO prj_ref_enabled
441: FROM mtl_parameters
442: WHERE organization_id = l_organization_id ;
443:
444: SELECT REQUISITION_HEADER_ID
445: INTO l_trx_src_id

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

1362: | 1 - YES. This would indicate that the creation of |
1363: | logical transactions would be deferred. |
1364: | 2 - No. This would indicate that the creation of |
1365: | logical transactions would not be deferred. |
1366: | 3 - Use the flag set at the Org level. mtl_parameters|
1367: | will hold the default value for a specific |
1368: | organization. |
1369: | Default would be set to 3 - use the flag set at |
1370: | the organization level. |

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

1503:
1504:
1505: l_progress := 10;
1506: -- If the defer accounting trx is 3 (at org level)
1507: -- get the defer logical transactions flag from mtl_parameters
1508: IF (l_defer_logical_trx = G_DEFER_LOGICAL_TRX_ORG_LEVEL) THEN
1509: BEGIN
1510: IF (l_debug = 1) THEN
1511: print_debug('l_defer_logical_trx = 3', 9);

Line 1518: FROM mtl_parameters

1514: END IF;
1515: l_progress := 20;
1516: SELECT defer_logical_transactions
1517: INTO l_defer_logical_trx
1518: FROM mtl_parameters
1519: WHERE organization_id = p_mtl_trx_tbl(1).organization_id;
1520:
1521: l_progress := 30;
1522: IF (l_debug = 1) THEN

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

1524: END IF;
1525: EXCEPTION
1526: WHEN no_data_found THEN
1527: IF (l_debug = 1) THEN
1528: print_debug('Cannot get defer logical trx flag from mtl_parameters', 9);
1529: END IF;
1530: FND_MESSAGE.SET_NAME('INV', 'INV_DEFER_LOGICAL_ERR');
1531: FND_MSG_PUB.ADD;
1532: RAISE FND_API.G_EXC_ERROR;

Line 3152: FROM mtl_parameters

3148: l_prev_organization_id := p_mtl_trx_tbl(i).organization_id;
3149:
3150: SELECT NVL(process_enabled_flag, 'N')
3151: INTO l_process_enabled_flag
3152: FROM mtl_parameters
3153: WHERE organization_id = p_mtl_trx_tbl(i).organization_id;
3154: END IF;
3155:
3156: IF (l_debug = 1) THEN

Line 4332: FROM mtl_parameters mp

4328:
4329: CURSOR c_process_flag(p_organization_id BINARY_INTEGER)
4330: IS
4331: SELECT NVL(mp.process_enabled_flag,'N')
4332: FROM mtl_parameters mp
4333: WHERE mp.organization_id = p_organization_id;
4334:
4335:
4336: CURSOR c_from_to_ou(p_organizaiton_id BINARY_INTEGER, p_xfer_organization_id BINARY_INTEGER)

Line 4397: FROM mtl_parameters mp

4393:
4394: l_stmt_num := 20;
4395: SELECT MOD(SUM(DECODE(process_enabled_flag, 'Y', 1, 2)), 2)
4396: INTO l_pd_txfr_ind
4397: FROM mtl_parameters mp
4398: WHERE mp.organization_id = l_organization_id
4399: OR mp.organization_id = l_xfer_organization_id;
4400:
4401: IF l_pd_txfr_ind <> 1

Line 4966: FROM mtl_parameters

4962: l_stmt_num := 160;
4963: SELECT DECODE(NVL(process_enabled_flag, 'N'), 'N', 'N', NULL),
4964: DECODE(NVL(process_enabled_flag, 'N'), 'Y', 'N', NULL)
4965: INTO l_costed_flag, l_opm_costed_flag
4966: FROM mtl_parameters
4967: WHERE organization_id = l_owner_org_id;
4968:
4969:
4970: IF (l_debug = 1) THEN