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 3898: l_prev_org_id mtl_parameters.organization_id%TYPE := NULL;

3894: IS
3895: l_api_name CONSTANT VARCHAR2(50) := 'cost_group_update';
3896: l_txn_temp_id NUMBER := 0;
3897: l_prev_rowid ROWID := NULL;
3898: l_prev_org_id mtl_parameters.organization_id%TYPE := NULL;
3899: l_primary_qty NUMBER := NULL;
3900: l_is_lot_control BOOLEAN := NULL;
3901: l_is_serial_control BOOLEAN := NULL;
3902: l_cost_group_id NUMBER := 0;