APPS.CSD_PROCESS_PVT dependencies on CS_STD

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

3034: -- Assigning values for the order record
3035: l_order_rec.incident_id := l_incident_id;
3036: l_order_rec.party_id := l_party_id;
3037: l_order_rec.account_id := l_account_id;
3038: l_order_rec.org_id := Cs_Std.get_item_valdn_orgzn_id;
3039:
3040: -- Interface the charge line to OM if the flag is checked
3041: IF x_product_txn_rec.interface_to_om_flag = 'Y'
3042: THEN

Line 3054: Cs_Std.get_item_valdn_orgzn_id

3050: SELECT revision_qty_control_code
3051: INTO l_rev_ctl_code
3052: FROM mtl_system_items
3053: WHERE organization_id =
3054: Cs_Std.get_item_valdn_orgzn_id
3055: AND inventory_item_id =
3056: x_product_txn_rec.inventory_item_id;
3057: EXCEPTION
3058: WHEN NO_DATA_FOUND THEN

Line 3074: Cs_Std.get_item_valdn_orgzn_id

3070: FROM mtl_item_revisions
3071: WHERE inventory_item_id =
3072: x_product_txn_rec.inventory_item_id
3073: AND organization_id =
3074: Cs_Std.get_item_valdn_orgzn_id
3075: AND revision = x_product_txn_rec.revision;
3076: EXCEPTION
3077: WHEN NO_DATA_FOUND THEN
3078: Fnd_Message.SET_NAME('CSD',

Line 9105: AND Organization_id = Cs_Std.Get_Item_Valdn_Orgzn_Id;

9101: SELECT Serial_Number_Control_COde
9102: INTO l_Serial_num_COntrol_Code
9103: FROM Mtl_System_Items_B
9104: WHERE Inventory_Item_Id = l_Inventory_Item_Id
9105: AND Organization_id = Cs_Std.Get_Item_Valdn_Orgzn_Id;
9106: -- If item is serial controlled then raise error
9107: IF l_Serial_num_COntrol_Code > 1
9108: THEN
9109: -- Display Message: RO quantity can not be greater then for serial controlled items.

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

9121: INTO l_Item_Name
9122: FROM mtl_system_items_vl items, csd_repairs dra
9123: WHERE dra.repair_line_id = p_Repair_Line_Id
9124: and dra.inventory_item_id = items.inventory_item_id
9125: and items.organization_id = cs_std.get_item_valdn_orgzn_id;
9126:
9127: -- Get Service Validation Org name
9128: SELECT Name
9129: INTO l_Service_Valdn_Org_Name

Line 9132: Cs_Std.Get_Item_Valdn_Orgzn_Id;

9128: SELECT Name
9129: INTO l_Service_Valdn_Org_Name
9130: FROM Hr_Organization_Units
9131: WHERE Organization_id =
9132: Cs_Std.Get_Item_Valdn_Orgzn_Id;
9133:
9134: Fnd_Message.SET_NAME('CSD',
9135: 'CSD_NO_ITEM_FOR_SRV_VALDN_ORG');
9136: Fnd_Message.Set_Token('ITEM', l_Item_Name);