DBA Data[Home] [Help]

APPS.CSD_INTERNAL_ORDERS_PVT dependencies on FND_PROFILE

Line 1065: fnd_profile.get('CSD_DEF_PICK_RELEASE_RULE',l_order_rec.picking_rule_id);

1061: END IF;
1062:
1063: IF p_picking_rule_id IS NULL OR p_picking_rule_id = 0 THEN
1064: -- get the default picking rule id.
1065: fnd_profile.get('CSD_DEF_PICK_RELEASE_RULE',l_order_rec.picking_rule_id);
1066: ELSE
1067: l_order_rec.picking_rule_id := p_picking_rule_id;
1068: END IF;
1069:

Line 1381: AND msi.organization_id = fnd_profile.value('CSD_DEF_REP_INV_ORG');

1377: l_item_name
1378: FROM mtl_system_items_kfv msi, csd_product_transactions cpt
1379: WHERE cpt.product_transaction_id = p_product_txn_id
1380: AND cpt.inventory_item_id = msi.inventory_item_id
1381: AND msi.organization_id = fnd_profile.value('CSD_DEF_REP_INV_ORG');
1382:
1383: -- item is serial controlled.
1384: IF l_serial_control_flag IN (2,5,6)
1385: THEN