DBA Data[Home] [Help]

APPS.INV_COST_GROUP_UPDATE dependencies on MTL_PARAMETERS

Line 405: FROM mtl_parameters

401: x_return_status := fnd_api.g_ret_sts_success;
402:
403: SELECT primary_cost_method, negative_inv_receipt_code
404: INTO l_primary_cost_method, l_negative_balances_allowed
405: FROM mtl_parameters
406: WHERE organization_id = p_organization_id;
407:
408: IF (l_debug = 1) THEN
409: print_debug('proc_get_default_costgroup.. l_negative_balances_allowed ' || l_negative_balances_allowed);

Line 491: FROM mtl_parameters

487: EXCEPTION
488: WHEN no_data_found THEN
489: SELECT default_cost_group_id
490: INTO x_cost_group_id
491: FROM mtl_parameters
492: WHERE organization_id = p_organization_id;
493: IF (l_debug = 1) THEN
494: print_debug('proc_get_default_costgroup.. default_org_cost_group: ' || x_cost_group_id);
495: END IF;

Line 500: FROM mtl_parameters

496: END;
497: ELSE
498: SELECT default_cost_group_id
499: INTO x_cost_group_id
500: FROM mtl_parameters
501: WHERE organization_id = p_organization_id;
502: IF (l_debug = 1) THEN
503: print_debug('proc_get_default_costgroup.. default_org_cost_group: ' || x_cost_group_id);
504: END IF;

Line 3886: l_prev_org_id mtl_parameters.organization_id%TYPE := NULL;

3882: IS
3883: l_api_name CONSTANT VARCHAR2(50) := 'cost_group_update';
3884: l_txn_temp_id NUMBER := 0;
3885: l_prev_rowid ROWID := NULL;
3886: l_prev_org_id mtl_parameters.organization_id%TYPE := NULL;
3887: l_primary_qty NUMBER := NULL;
3888: l_is_lot_control BOOLEAN := NULL;
3889: l_is_serial_control BOOLEAN := NULL;
3890: l_cost_group_id NUMBER := 0;