APPS.CSD_PROCESS_PVT dependencies on CS_STD

Line 3120: l_order_rec.org_id := Cs_Std.get_item_valdn_orgzn_id;

3116: -- Assigning values for the order record
3117: l_order_rec.incident_id := l_incident_id;
3118: l_order_rec.party_id := l_party_id;
3119: l_order_rec.account_id := l_account_id;
3120: l_order_rec.org_id := Cs_Std.get_item_valdn_orgzn_id;
3121:
3122: -- Interface the charge line to OM if the flag is checked
3123: IF x_product_txn_rec.interface_to_om_flag = 'Y'
3124: THEN

Line 3136: Cs_Std.get_item_valdn_orgzn_id

3132: SELECT revision_qty_control_code
3133: INTO l_rev_ctl_code
3134: FROM mtl_system_items
3135: WHERE organization_id =
3136: Cs_Std.get_item_valdn_orgzn_id
3137: AND inventory_item_id =
3138: x_product_txn_rec.inventory_item_id;
3139: EXCEPTION
3140: WHEN NO_DATA_FOUND THEN

Line 3156: Cs_Std.get_item_valdn_orgzn_id

3152: FROM mtl_item_revisions
3153: WHERE inventory_item_id =
3154: x_product_txn_rec.inventory_item_id
3155: AND organization_id =
3156: Cs_Std.get_item_valdn_orgzn_id
3157: AND revision = x_product_txn_rec.revision;
3158: EXCEPTION
3159: WHEN NO_DATA_FOUND THEN
3160: Fnd_Message.SET_NAME('CSD',

Line 4849: --p_org_id => cs_std.get_item_valdn_orgzn_id, -- FP for bug fix 9198116

4845:
4846: -- If wrong sub-inventory is entered, throw explanatory error message
4847: if x_product_txn_rec.sub_inventory is not null then
4848: if NOT csd_process_util.validate_subinventory_ship(
4849: --p_org_id => cs_std.get_item_valdn_orgzn_id, -- FP for bug fix 9198116
4850: p_org_id => l_ship_from_org_id,
4851: p_sub_inv => x_product_txn_rec.sub_inventory,
4852: p_inventory_item_id => x_product_txn_rec.inventory_item_id,
4853: p_serial_number => x_product_txn_rec.source_serial_number ) then

Line 9260: AND Organization_id = Cs_Std.Get_Item_Valdn_Orgzn_Id;

9256: SELECT Serial_Number_Control_COde
9257: INTO l_Serial_num_COntrol_Code
9258: FROM Mtl_System_Items_B
9259: WHERE Inventory_Item_Id = l_Inventory_Item_Id
9260: AND Organization_id = Cs_Std.Get_Item_Valdn_Orgzn_Id;
9261: -- If item is serial controlled then raise error
9262: IF l_Serial_num_COntrol_Code > 1
9263: THEN
9264: -- Display Message: RO quantity can not be greater then for serial controlled items.

Line 9280: and items.organization_id = cs_std.get_item_valdn_orgzn_id;

9276: INTO l_Item_Name
9277: FROM mtl_system_items_vl items, csd_repairs dra
9278: WHERE dra.repair_line_id = p_Repair_Line_Id
9279: and dra.inventory_item_id = items.inventory_item_id
9280: and items.organization_id = cs_std.get_item_valdn_orgzn_id;
9281:
9282: -- Get Service Validation Org name
9283: SELECT Name
9284: INTO l_Service_Valdn_Org_Name

Line 9287: Cs_Std.Get_Item_Valdn_Orgzn_Id;

9283: SELECT Name
9284: INTO l_Service_Valdn_Org_Name
9285: FROM Hr_Organization_Units
9286: WHERE Organization_id =
9287: Cs_Std.Get_Item_Valdn_Orgzn_Id;
9288:
9289: Fnd_Message.SET_NAME('CSD',
9290: 'CSD_NO_ITEM_FOR_SRV_VALDN_ORG');
9291: Fnd_Message.Set_Token('ITEM', l_Item_Name);